静态、动态监听的配置

静态监听：
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = MPJ)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )
SID_LIST_LISTENER=
  (SID_LIST=
    (SID_DESC=
      (GLOBAL_DBNAME=MPJ)
      (ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1)
      (SID_NAME=MPJ))
    (SID_DESC=
      (SID_NAME=plsextproc)
      (ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1)
      (PROGRAM=extproc)
    )
  )

动态和静态一起：
LISTENER= (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = MPJ)(PORT = 1526))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1526))
    )
  )
SID_LIST_LISTENER=
  (SID_LIST=
    (SID_DESC=
      (SID_NAME=plsextproc)
      (ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1)
      (PROGRAM=extproc))
LISTENER= (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = MPJ)(PORT = 1526))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1526))
    )
  )
SID_LIST_LISTENER=
  (SID_LIST=
    (SID_DESC=
        (SID_NAME=MPJ)
        (ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1)
        (PROGRAM=extproc))
    )
 )  

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29812751/viewspace-1685428/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29812751/viewspace-1685428/