|
에고.. 벌써 날 샜군여.. T_T
리스너 시작할때 자꾸 에러가 납니다.
TCP쪽은 잘 되는거 같은데..
에러메세지는 아래와 같습니다.
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=ORCL))
TNS-12224: TNS:no listener
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=....)(Port=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 8.0.5.0.0 - Production
Start Date 13-NOV-00 05:09:20
Uptime 0 days 0 hr. 0 min. 6 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /home/oracle/app/oracle/product/8.0.5/network/admin/listener.ora
Listener Log File /home/oracle/app/oracle/product/8.0.5/network/log/listener.log
Services Summary...
ORCL has 1 service handler(s)
extproc has 1 service handler(s)
The command completed successfully
tnsnames.ora 파일 내용은 아래와 같습니다.
==============================================
# Installation Generated Net8 Configuration
# Version Date: Oct-27-97
# Filename: Tnsnames.ora
#
extproc_connection_data =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = ORCL))
(CONNECT_DATA = (SID = extproc))
)
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL= TCP)(Host= ....)(Port= 1521))
(CONNECT_DATA = (SID = ORCL))
)
ORCL_BEQ =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = BEQ)(PROGRAM = /home/oracle/app/oracle/product/8.0.5)
(argv0 = oracleORCL)
(args = '(DESCRIPTION = (LOCAL=YES)(ADDRESS=(PROTOCOL=BEQ)))')
(envs = 'ORACLE_HOME=/home/oracle/app/oracle/product/8.0.5,ORACLE_SID=ORCL')
)
)
listener.ora 파일 내용은 아래와 같습니다.
==============================================
# Installation Generated Net8 Configuration
# Version Date: Jun-17-97
# Filename: Listener.ora
#
LISTENER =
(ADDRESS_LIST =
(ADDRESS= (PROTOCOL= IPC)(KEY= ORCL))
# (ADDRESS= (PROTOCOL= IPC)(KEY= PNPKEY))
(ADDRESS= (PROTOCOL= TCP)(Host= ....)(Port= 1521))
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME= .....)
(ORACLE_HOME= /home/oracle/app/oracle/product/8.0.5)
(SID_NAME = ORCL)
)
(SID_DESC =
(SID_NAME = extproc)
(ORACLE_HOME = /home/oracle/app/oracle/product/8.0.5)
(PROGRAM = extproc)
)
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
리스너가 제대로 시작이 안 되어서 아래같은 에러가 나는것 같습니다.
_oci_open_server: Error while trying to retrieve text for error ORA-12154 in /usr/local/apache/htdocs/test.php on line 2
아시는분 계시면 좀 알려주세여..T_T
|
