본문 바로가기
OraclE

리스너 2개 만들기

by 타마마임팩트_쫀 2009. 3. 17.
리스너 프로세스 2개 생성


SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = haha)
      (ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
      (SID_NAME = haha)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = xpuser)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
  )

SID_LIST_RBM2TEST =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = RBM2TEST)
      (ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
      (SID_NAME = RBM2TEST)
    )
  )

RBM2TEST =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = xpuser)(PORT = 1541))
    )
  )