• Design
  • Tuning
  • Apache Derby
  • IBM DB2
  • MySQL
  • Oracle
  • SQL Server
  • Oracle Net Services

    You are currently using a web browser that does not support HTML pages with style sheets. Please try the XHTML 1 or XHTML 1 Mobile version of this page instead.

    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 2 Style Sheet* format (* see Clicklets for more infomation). This document is also available in HTML Style Sheet*XHTML 1* XML* HTML 4*HTML 5 Style Sheet*HTML 5 XML*HTML 5 non-XML* 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.