>>콩자반 님께서 쓰시길<<
:: # LISTENER.ORA Configuration
:: File:/oracle/app/oracle/product/8.1.5/network/admin/listener.ora
:: # Generated by Oracle Net8 Assistant
::
:: LISTENER =
:: (DESCRIPTION_LIST =
:: (DESCRIPTION =
:: (ADDRESS_LIST =
:: (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
:: )
:: (ADDRESS_LIST =
:: (ADDRESS = (PROTOCOL = TCP)(HOST = ORCL)
:: (PORT = 1521))
:: )
:: )
:: )
::
:: SID_LIST_LISTENER =
:: (SID_LIST =
:: (SID_DESC =
:: (SID_NAME = PLSExtProc)
:: (ORACLE_HOME = /oracle/app/oracle/product/8.1.5)
:: (PROGRAM = extproc)
:: )
:: (SID_DESC =
:: (GLOBAL_DBNAME = ORCL)
:: (ORACLE_HOME = /oracle/app/oracle/product/8.1.5)
:: (SID_NAME = ORCL)
:: )
:: )
::
:: 위의 내용은 제가.. 리스너 파일 설정한 부분이고요..
:: 밑에거는 이에 대한 오류 입니다..
:: 어떤거가 잘못 된건지 잘 모르겠습니다..
:: 리스터 파일 은 맨나중에 하는건가요??
:: 제가 하려는건.. 리눅스에 현재 오라클이 깔려 있는데...
:: NT가 깔려있는 다른 컴퓨터에 오라클 클라이언트 를 깔고..
:: 연동 시키려 하거든요...
:: 제발 도와 주세요...
:: 제가 좀 초보입니다... 초보인가 감안 해서. .알려주세요..
::
:: TNSLSNR for Linux: Version 8.1.5.0.0 - Production on 15-MAR-01 22:48:13
::
:: (c) Copyright 1998 Oracle Corporation. All rights reserved.
::
:: System parameter file is /oracle/app/oracle/product/8.1.5/network/admin/listener.ora
:: Log messages written to /oracle/app/oracle/product/8.1.5/network/log/listener.log
::
:: Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
:: Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ORCL)(PORT=1521)))
:: Attempted to listen on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ORCL)(PORT=1521)))
:: TNS-12545: Connect failed because target host or object does not exist
:: TNS-12560: TNS:protocol adapter error
:: TNS-00515: Connect failed because target host or object does not exist
:: Linux Error: 2: 그런 파일이나 디렉토리가 없음
우선 오라클이있는 서버쪽에서 lsnrctl stat 명령어로 리스너가 떠있는지확인
해보세요
만약 떠있다면
listener.ora화일을
LISTENER =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 111.111.111.111)(PORT = 1521))
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = 111.111.111.111)
(ORACLE_HOME = /oracle/app/oracle/product/8.1.5)
(SID_NAME = ORCL)
)
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
LOGGING_LISTENER = ON
해보시고
$>lsnrctl stop
$>lsnrctl start
해보세요.
|