Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

tnsping and sqlnet.ora

flying_penguinJun 6 2008 — edited Jun 6 2008

When i do a tnsping, why is it looking in sqlnet.ora file? Shouldn't tnsping utility be looking at tnsnames.ora alone?

F:\>tnsping oraprod74 8

TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 06-JUN-2008 14:18:10

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

Used parameter files:
C:\oracle\product\10.2.0\db_2\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.100.176.163)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = oraprod74.kohn.com)))
OK (480 msec)
OK (270 msec)
OK (250 msec)
OK (250 msec)
OK (270 msec)
OK (250 msec)
OK (250 msec)
OK (260 msec)

F:\>
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 4 2008
Added on Jun 6 2008
5 comments
885 views