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.

Last updated Wednesday October 4, 2006


Printer-friendly PDF* format:

Oracle Net Services

This Section

You are currently viewing this page in XHTML 1 Style Sheet* format (* see Clicklets for more infomation). This document is also available in XHTML 1*XML*HTML 4*HTML 5 Style Sheet*HTML 5 XML*HTML 5 non-XML* XHTML 2* XHTML Mobile* WML Mobile* and printer-friendly PDF* formats. This is accomplished with Single Source Publishing, a content management system that uses templates in XSLT style sheets provided by XML Styles .com to transform the source content for various content delivery channels. There is also RDF* metadata that describes the content of this document.