Oracle Database - TNS Ping Utility

Card Puncher Data Processing

About

tnsping is an utility to verify that the net service name are resolved and find in the tnsnames.ora

Example

C:\Documents and Settings\gerardnico>tnsping ORCL

TNS Ping Utility for 32-bit Windows: Version 10.2.0.3.0 - Production on 20-OCT-2009 07:01:53

Copyright (c) 1997, 2006, Oracle.  All rights reserved.

Used parameter files:
E:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = ORACLE10G)(PORT = 1521)))
 (CONNECT_DATA = (SID = ORCL)) )
OK (30 msec)





Discover More
Hs Odbc Excel Define Name
Oracle Database - How to read data through an ODBC connection with Gateway (Heterogeneous services)

This article is aimed to show how you can access data from oracle database via an odbc connection direct by using the gateway odbc agent (or program) generic connectivity. In this example, an odbc connection...



Share this page:
Follow us:
Task Runner