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
|