|
>>신영대 님께서 쓰시길<<
:: 에고.. 벌써 날 샜군여.. 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/h
:: tdocs/test.php on line 2
::
:: 아시는분 계시면 좀 알려주세여..T_T
=> 우선은 listener가 떠 있는지 확인을 하는 것이 순서인것 같습니다.
ps -ef|grep LISTENER로 listener가 떠 있는지 확인을 해 보시고 떠있지 않다면
lsnrctl start로 listener를 띄어 보시기 바랍니다.
짧은 지식으로 올리는 글이지만 도움이 되셨으면 좋겠네요....
|
