【Oracle】リスナー 動的登録と静的登録

動的登録なリスナー

[oracle@single admin]$ cat listener.ora

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = single)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

静的登録リスナー

[oracle@single admin]$ cat listener.ora

LISTENER2 =
  (DESCRIPTION=
    (ADDRESS_LIST=
      (ADDRESS=(PROTOCOL=tcp)(HOST=single)(PORT=1561))))

SID_LIST_LISTENER2 =
  (SID_LIST=
    (SID_DESC=
      (SID_NAME=PROD1
      (ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1)))