하나의 포트로 여러 리스너 설정하기...
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 |
'Database > ORACLE' 카테고리의 다른 글
| 테이블 생성 후 초기 값(INITIAL) 및 Next 크기 조정하기 (0) | 2013.09.12 |
|---|---|
| 오라클 미디어 팩 신청하기 (0) | 2013.01.31 |
| DBMS_XPLAN 정보 조회 (0) | 2012.09.07 |
| Automatic SQL Tuning in Oracle Database 10g (0) | 2012.07.20 |
| 10G OCP 자격증 관련 (2) | 2012.07.08 |