Check TCP/IP connectivity to the remote system

ping -c 1 hostname​PING hostname.domain.com: (10.1.1.3): 56 data bytes64 bytes from 10.1.1.3: icmp_seq=0 ttl=64 time=0 ms----hostname.domain.com PING Statistics----1 packets transmitted, 1 packets received, 0% packet loss

Check Oracle service name resolution and connectivity

The tnsping command shows the connect descriptor that an Oracle service name is resolves to, and tests the connection to the service.

tnsping svcname​Used LDAP adapter to resolve the aliasAttempting to contact (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=hostname)(PORT=1521)))(CONNECT_DATA=(SID=xxxx))(HS=OK))OK (10 msec)

svcname can be the name of a service that has been defined as a Net Service Name in the LDAP server (OID) using Oracle Net Manager (oidadmin). The details of LDAP entries can also be displayed and/or modified using Oracle Directory Manager (oidadmin). svcname can also be a service name defined locally using the Local Net Service Name configuration option of the Oracle Net Configuration Assistant.

Next: Page 2
Back Up: Oracle