Thursday, November 20, 2008

ezconnect tnsping examples

Ping only hostname defaults to listener and port 1521
rac1:-) tnsping //rac1
TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 20-NOV-2008 21:24:19
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:/u01/app/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora
Used EZCONNECT adapter to resolve the aliasAttempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=rac1.mycorpdomain.com))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.2.131)(PORT=1521)))OK (10 msec)

Ping host and port
rac1:-) tnsping //rac1:1528
TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 20-NOV-2008 21:24:23
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:/u01/app/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora
Used EZCONNECT adapter to resolve the aliasAttempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=rac1.mycorpdomain.com))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.2.131)(PORT=1528)))OK (10 msec)

Ping host and port and servicename
rac1:-) tnsping //rac1:1528/patertje
TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 20-NOV-2008 21:24:28
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:/u01/app/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora
Used EZCONNECT adapter to resolve the aliasAttempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=patertje))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.2.131)(PORT=1528)))OK (10 msec)

Ping host and port and sid
rac1:-) tnsping //rac1:1528/xyz
TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 20-NOV-2008 21:24:33
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:/u01/app/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora
Used EZCONNECT adapter to resolve the aliasAttempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=xyz))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.2.131)(PORT=1528)))OK (0 msec)

No comments: