listener.ora에 있는 global_dbname이 좀 이상하네요.
이게 ip address로 설정되면 아마 안될 겁니다.
아예 그 라인을 빼 보세요. 아니면 적당한 dns name으로 설정하시던가요...
>>눈비나 님께서 쓰시길<<
:: 오라클 8.1.6에서
::
:: vi 오라클홈/network/admin/listener.ora
::
:: LISTENER =
:: (ADDRESS_LIST =
:: (ADDRESS = (PROTOCOL = TCP)(HOST = 200.000.000.000)(PORT=1521))
:: )
::
:: SID_LIST_LISTENER =
:: (SID_LIST =
:: (SID_DESC =
:: (GLOBAL_DBNAME=200.000.000.000)
:: (SID_NAME = ORCL)
:: (ORACLE_HOME = /home/oracle/ORA816)
:: )
:: )
::
:: vi 오라클홈/network/admin/tnsnames.ora
::
:: DAMI =
:: (DESCRIPTION =
:: (ADDRESS_LIST =
:: (ADDRESS = (PROTOCOL = TCP)(HOST = 200.000.000.000)(PORT = 1521))
:: )
:: (CONNECT_DATA =
:: (SID = ORCL)
:: )
:: )
::
::
::
::
:: [oracle@darum oracle]$ lsnrctl start
::
:: LSNRCTL for Linux: Version 8.1.6.0.0 - Production on 26-APR-2001 17:12:02
::
:: (c) Copyright 1998, 1999, Oracle Corporation. All rights reserved.
::
:: Starting /home/oracle/ORA816/bin/tnslsnr: please wait...
::
:: TNSLSNR for Linux: Version 8.1.6.0.0 - Production
:: System parameter file is /home/oracle/ORA816/network/admin/listener.ora
:: Log messages written to /home/oracle/ORA816/network/log/listener.log
:: TNS-01152: All addresses specified for the listener name, LISTENER, failed
::
::
:: 이렇게 뜨네요.
::
:: 이때 listener.ora tnsnames.ora 말고 또 설정 해 주어야 하는 파일이 있나요?
::
:: 어디가 잘못인지 모르겠습니다.
|