Oracle Net Services

Checking connectivity

Check TCP/IP connectivity to the remote system


         ping -c 1 hostname
         

         PING hostname.domain.com: (10.1.1.3): 56 data bytes
         

         64 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 alias
         

         Attempting 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: Oracle on z/OS

Home > Computers > Databases > Oracle > Net Services > Oracle Net

Viewing mobile website page. Switch to WML or Full HTML