Oracle 常用命令

监听器

监听文件路径

/home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora

一个能够正常启动的监听器文件内容

   1: # listener.ora Network Configuration File: /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
   2: # Generated by Oracle configuration tools.
   3:  
   4: SID_LIST_LISTENER =
   5:   (SID_LIST =
   6:     (SID_DESC =
   7:       (SID_NAME = PLSExtProc)
   8:       (ORACLE_HOME = /home/oracle/app/oracle/product/11.2.0/dbhome_1)
   9:       (PROGRAM = extproc)
  10:     )
  11:     (SID_DESC =
  12:       (GLOBAL_DBNAME = orcl)
  13:       (ORACLE_HOME = /home/oracle/app/oracle/product/11.2.0/dbhome_1)
  14:       (SID_NAME = ORCL)
  15:     )
  16:   )
  17:  
  18: LISTENER =
  19:   (DESCRIPTION_LIST =
  20:     (DESCRIPTION =
  21:       (ADDRESS_LIST =
  22:         (ADDRESS = (PROTOCOL = TCP)(HOST = 10.30.176.20 )(PORT = 1521))
  23:       )
  24:       (ADDRESS_LIST =
  25:         (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
  26:       )
  27:     )
  28:   )

启动监听器

lsnrctl start

posted @ 2013-11-13 15:19  LARSON _  Views(388)  Comments(0)  Edit  收藏  举报