프로토콜을 TCP 와 IPC 를 사용하여 LISTENER 를 START 를 할시
ORA-12560 이 발생하는 경우에는 다음과 같이 SETTING 이 되어 있는지
확인을 하시면 됩니다


ERROR 확인:

$ lsnrctl start
LSNRCTL for SVR4: Version 2.3.1.1.0 - Beta on 14-NOV-95 19:41:20
Copyright (c) Oracle Corporation 1994. All rights reserved.
Starting /u00/beta73/oracle/bin/tnslsnr: please wait...
TNSLSNR for SVR4: Version 2.3.1.1.0 - Beta
System parameter file is /u00/beta73/oracle/network/admin/listener.ora
Log messages written to /u00/beta73/oracle/network/log/listener.log
Trace information written to /u00/beta73/oracle/network/trace/listener.trc
Listening on: (ADDRESS=(PROTOCOL=tcp)(DEV=8)(HOST=146.125.84.112)(PORT=1521))
Connecting to (ADDRESS=(PROTOCOL=ipc)(KEY=BETA))
TNS 12224: TNS:no listener
TNS 12541: TNS:no listener
TNS 12560: TNS:protocol adapter error
TNS 511: No listener
SVR4 Error: 6: No such device or address
Connecting to (ADDRESS=(PROTOCOL=TCP)(HOST=anthrax)(PORT=1521))
STATUS of the LISTENER
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for SVR4: Version 2.3.1.1.0 - Beta
Start Date 14-NOV-95 19:41:23
Uptime 0 days 0 hr. 0 min. 3 sec
Trace Level admin
Security OFF
SNMP ON
Listener Parameter File /u00/beta73/oracle/network/admin/listener.ora
Listener Log File /u00/beta73/oracle/network/log/listener.log
Listener Trace File /u00/beta73/oracle/network/trace/listener.trc
Services Summary...
BETA has 2 service handler(s)
C has 1 service handler(s)
The command completed successfully

.
Listener.ora file 점검

LISTENER=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=ipc)(KEY=BETA))
(ADDRESS=
(PROTOCOL=TCP)
(HOST=anthrax)
(PORT=1521)
)
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC= (GLOBAL_DBNAME=BETA.ANTHRAX.DSD.ML.COM)(SID_NAME=BETA)
(ORACLE_HOME=/u00/beta73/oracle)
)
(SID_DESC= (SID_NAME=C) (ORACLE_HOME=/u00/oracle/product/7.2.2)
)
(SID_DESC=
(SID_NAME=BETA)
(ORACLE_HOME=/u00/beta73/oracle)
(GLOBAL_DBNAME=BETA))
)
TRACE_LEVEL_LISTENER = ADMIN
USE_CKPFILE_LISTENER = true
USE_PLUG_AND_PLAY_LISTENER = true

initSID.ora file 점검

mts_dispachers="tcp,1"
mts_dispachers="ipc,1"
..
mts_listener_address="(ADDRESS=(PROTOCOL=tcp)(port=1521)(host=ipaddress))"
mts_listener_address="(ADDRESS=(PROTOCOL=ipc)(key=beta))"

을 점검하시고 이상이 없다면 listener.ora file 에 garvage character 의
존재여부를 확인하십시요

이상이 없다면 고객의 unix kernel 에 IPC 가 INSTALL 되어있는지
IPC 의 CONFIGURE 를 점검하셔야 합니다.
711 보기 태그: