oracle的tnsping命令使用

oracle@oracle:/oracle/12.1/network/admin$ tnsping localhost:1521/jhon   #用hostname和端口好加服务tnsping

TNS Ping Utility for Solaris: Version 12.1.0.1.0 - Production on 17-7月 -2013 05:21:54

Copyright (c) 1997, 2013, Oracle.  All rights reserved.

已使用的参数文件:

已使用 HOSTNAME 适配器来解析别名
尝试连接 (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=jhon))(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))

OK (10 毫秒)

oracle@oracle:/oracle/12.1/network/admin$ tnsping jhon #可以用服务名来tnsping

TNS Ping Utility for Solaris: Version 12.1.0.1.0 - Production on 17-7月 -2013 05:22:21

Copyright (c) 1997, 2013, Oracle.  All rights reserved.

已使用的参数文件:


已使用 TNSNAMES 适配器来解析别名
尝试连接 (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = oracle)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = JHON)))
OK (0 毫秒)
oracle@oracle:/oracle/12.1/network/admin$ tnsping localhost #可以用IP或主机名加默认配置类tnsping

TNS Ping Utility for Solaris: Version 12.1.0.1.0 - Production on 17-7月 -2013 05:22:33

Copyright (c) 1997, 2013, Oracle.  All rights reserved.

已使用的参数文件:

已使用 HOSTNAME 适配器来解析别名
尝试连接 (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))
OK (0 毫秒)
oracle@oracle:/oracle/12.1/network/admin$ tnsping oracle     #用主机名tnsping

TNS Ping Utility for Solaris: Version 12.1.0.1.0 - Production on 17-7月 -2013 05:22:42

Copyright (c) 1997, 2013, Oracle.  All rights reserved.

已使用的参数文件:

已使用 HOSTNAME 适配器来解析别名
尝试连接 (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=188.188.3.224)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=::1)(PORT=1521)))
OK (0 毫秒)

迷途小运维随笔

作者：john