리스너 프로세스 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))
)
)
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))
)
)
'OraclE' 카테고리의 다른 글
oracle enterprise manager 한글 버튼 깨짐 문제 (0) | 2009.04.24 |
---|---|
ORA 7445, 600 Trouble Shooting (0) | 2009.03.19 |
Snapshot vs Materialized View (0) | 2009.03.09 |
Oracle9i Dataguard 구성 방법 (0) | 2009.03.05 |
ORA-27300 ORA-27301 ORA-27302 in alert log. Cannot connect to database. (0) | 2009.02.05 |