제가 작성한 파일을 기준으로 listener.ora 파일을
만들어 봤습니다. 그대로 복사 하셔서 사용해 보세요.
# LISTENER.ORA Network Configuration File: C:\Oracle\Ora81\network\admin\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = kh21)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\Oracle\Ora81)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = o8i)
(ORACLE_HOME = C:\Oracle\Ora81)
(SID_NAME = o8i)
)
)
>>이근행 님께서 쓰시길<<
:: tnsping kh21 하면 다음과 같은 오류가 발생합니다.
::
:: TNS Ping Utility for Linux: Version 8.1.6.0.0 - Production on 15-MAR-2001 11:43:00
:: (c) Copyright 1997 Oracle Corporation. All rights reserved.
::
:: TNS-03505: Failed to resolve name
::
::
:: -------------------------------------------------------
::
:: tnsping 111.111.111.111 하면
:: TNS Ping Utility for Linux: Version 8.1.6.0.0 - Production on 15-MAR-2001
:: 11:43:42
:: (c) Copyright 1997 Oracle Corporation. All rights reserved.
:: Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=111.111.111.111)(PORT=1521))
:: OK (60 msec)
:: -----------------------------------------------------------
:: (환경) 클라이언트 : 리눅스 + PHP4 + 아파치 + 오라클서버
:: DB서버 : 윈도우2000 어드벤스서버 + 오라클서버
::
:: 클라이언트 tnsnames.ora
:: --------------------------
:: # TNSNAMES.ORA Network Configuration File: C:\Oracle\Ora81\network\admin\tnsname
:: s.ora
:: # Generated by Oracle configuration tools.
::
:: kh21 =
:: (DESCRIPTION =
:: (ADDRESS_LIST =
:: (ADDRESS = (PROTOCOL = TCP)(HOST=111.111.111.111)(PORT = 1521))
:: )
:: (CONNECT_DATA =
:: (SERVICE_NAME = kh21)
:: )
:: )
::
:: o8i =
:: (DESCRIPTION =
:: (ADDRESS_LIST =
:: (ADDRESS = (PROTOCOL = TCP)(HOST=111.111.111.111)(PORT = 1521))
:: )
:: (CONNECT_DATA =
:: (SID = o8i)
:: )
:: )
::
:: ------------------------------------------------------------------------
:: 서버쪽 listener.ora
:: ----------------------
:: # LISTENER.ORA Network Configuration File: C:\Oracle\Ora81\network\admin\listener.ora
:: # Generated by Oracle configuration tools.
::
:: LISTENER =
:: (DESCRIPTION_LIST =
:: (DESCRIPTION =
:: (ADDRESS_LIST =
:: (ADDRESS = (PROTOCOL = TCP)(HOST = kh21)(PORT = 1521))
:: )
:: )
:: )
::
:: SID_LIST_LISTENER =
:: (SID_LIST =
:: (SID_DESC =
:: (SID_NAME = o8i)
:: (ORACLE_HOME = C:\Oracle\Ora81)
:: (GLOBAL_DBNAME = o8i)
:: )
:: )
::
:: ------------------------------------------------------------
:: 서버쪽 LSNRCTL 상태
:: ------------------------------------------------------------------------
:: LSNRCTL for 32-bit Windows: Version 8.1.6.0.0 - Production on 15-MAR-2001 11:34:48
:: (c) Copyright 1998, 1999, Oracle Corporation. All rights reserved.
:: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=kh21)(PORT=1521)))에 연결되었습니다
:: 리스너의 상태------------------------
:: 별칭 LISTENER
:: 버전 TNSLSNR for 32-bit Windows: Version 8.1.6.0.0 - Production
:: 시작 날짜 15-MAR-2001 11:10:38
:: 업타임 0 일 0 시간. 24 분. 12 초
:: 트레이스 수준 off
:: 보안 OFF
:: SNMP OFF리스너 매개변수 파일 C:\Oracle\Ora81\network\admin\listener.ora
:: 리스너 로그 파일 C:\Oracle\Ora81\network\log\listener.log
:: 서비스 요약...
:: o8i has 2 서비스 핸들러
:: o8i has 1 서비스 핸들러
:: 명령이 성공적으로 수행되었습니다
:: C:\Oracle\Ora81>
:: -----------------------
::
:: *** 서버측 init.ora파일중 수정한 부분입니다. ***
::
:: db_name = "o8i"
::
:: instance_name = o8i
::
:: service_names = kh21
::
:: db_files = 1024
::
|