하나의 포트로 여러 리스너 설정하기...
listener.ora
일부 서버들에서 되고 안되고 문제는 SID_LIST_LISTENER 설정에서 SID_DESC 설정 정보가 없을 때 발생함... (랜덤 -_-ㅋ)
# listener.ora Network Configuration File: /oracle/product/10g/network/admin/listener.ora # Generated by Oracle configuration tools.
SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /oracle/product/10g) (PROGRAM = extproc) ) (SID_DESC = (SID_NAME = SEVSEDEV) (ORACLE_HOME = /oracle/product/10g) ) (SID_DESC = (SID_NAME = SEVPTDEV) (ORACLE_HOME = /oracle/product/10g) ) )
LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.86)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) )
SID_LIST_LISTENER_SEVPTDEV = (SID_LIST = (SID_DESC = (SID_NAME = SEVPTDEV) (ORACLE_HOME = /oracle/product/10g) ) )
LISTENER_SEVPTDEV = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.86)(PORT = 1521)) ) )
SID_LIST_LISTENER_SEVSEDEV = (SID_LIST = (SID_DESC = (SID_NAME = SEVSEDEV) (ORACLE_HOME = /oracle/product/10g) ) )
LISTENER_SEVSEDEV = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.86)(PORT = 1521)) ) ) |
sqlnet.ora
# sqlnet.ora Network Configuration File: /oracle/product/10g/network/admin/sqlnet.ora # Generated by Oracle configuration tools. SQLNET.INBOUND_CONNECT_TIMEOUT=0 |