错误信息:
The test did not succeed.
ORA-12203: TNS:无法与目标连接There may be an error in the fields entered
or the server may not be ready for a connection.
You can check the server and retry, or continue.
The test did not succeed.
ORA-12203: TNS:无法与目标连接There may be an error in the fields entered
or the server may not be ready for a connection.
You can check the server and retry, or continue.
首先确定网络是通的
/oracle/92/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
OK (0 msec)应该没问题的吧
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 133.170.22.6)(PORT = 1521))
)
(CONNECT_DATA =
# (SERVER = DEDICATED)
(SERVICE_NAME = hpora9)
# (SID=hpora9)
)
)试一下
004 09:13:07Copyright (c) 1997 Oracle Corporation. All rights reserved.已使用的参数文件:
D:\oracle9i\ora92\network\admin\sqlnet.ora已使用 HOSTNAME 适配器来解析别名
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SID=*)(SERVICE_NAME=133.170.22
.6))(ADDRESS=(PROTOCOL=TCP)(HOST=133.170.22.6)(PORT=1521)))
TNS-12535: TNS: 操作超时C:\Documents and Settings\user_1>ping 133.170.22.6Pinging 133.170.22.6 with 32 bytes of data:Request timed out.Ping statistics for 133.170.22.6:
Packets: Sent = 1, Received = 0, Lost = 1 (100% loss),
Control-C
[oracle@zhkmobile admin]$ tnsping 133.170.22.6TNS Ping Utility for Linux: Version 9.2.0.4.0 - Production on 20-SEP-2004 08:392Copyright (c) 1997 Oracle Corporation. All rights reserved.Used parameter files:
/oracle/92/network/admin/sqlnet.oraTNS-03505: Failed to resolve name
[oracle@zhkmobile admin]$ ping 133.170.22.6
PING 133.170.22.6 (133.170.22.6) 56(84) bytes of data.
64 bytes from 133.170.22.6: icmp_seq=0 ttl=0 time=0.040 ms
64 bytes from 133.170.22.6: icmp_seq=1 ttl=0 time=0.025 ms
64 bytes from 133.170.22.6: icmp_seq=2 ttl=0 time=0.022 ms
64 bytes from 133.170.22.6: icmp_seq=3 ttl=0 time=0.013 ms
64 bytes from 133.170.22.6: icmp_seq=4 ttl=0 time=0.018 ms
64 bytes from 133.170.22.6: icmp_seq=5 ttl=0 time=0.020 ms
?
--- 133.170.22.6 ping statistics ---
6 packets transmitted, 6 received, 0% packet loss, time 5024ms
rtt min/avg/max/mdev = 0.013/0.023/0.040/0.008 ms, pipe 2
[oracle@zhkmobile admin]$ tnsping hpora9TNS Ping Utility for Linux: Version 9.2.0.4.0 - Production on 20-SEP-2004 09:060Copyright (c) 1997 Oracle Corporation. All rights reserved.Used parameter files:
/oracle/92/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
OK (10 msec)