Oracle提供了一个名为tnsping的实用程序：
- R:\>tnsping someconnection
- TNS Ping Utility for 32-bit Windows: Version 9.0.1.3.1 - Production on 27-AUG-20
- 08 10:38:07
- Copyright (c) 1997 Oracle Corporation. All rights reserved.
- Used parameter files:
- C:\Oracle92\network\ADMIN\sqlnet.ora
- C:\Oracle92\network\ADMIN\tnsnames.ora
- TNS-03505: Failed to resolve name
- R:\>
- R:\>tnsping entpr01
- TNS Ping Utility for 32-bit Windows: Version 9.0.1.3.1 - Production on 27-AUG-20
- 08 10:39:22
- Copyright (c) 1997 Oracle Corporation. All rights reserved.
- Used parameter files:
- C:\Oracle92\network\ADMIN\sqlnet.ora
- C:\Oracle92\network\ADMIN\tnsnames.ora
- Used TNSNAMES adapter to resolve the alias
- Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = **)
- (PROTOCOL = TCP) (Host = ****) (Port = 1521))) (CONNECT_DATA = (SID = ENTPR0
- 1)))
- OK (40 msec)
- R:\>
