Question about TNSNAMES and EZCONNECT
984675Jan 14 2013 — edited Jan 14 2013I have 10.2.0.4 EE, RAC + Data Guard. From an app server, I issue the following:
+$tnsping database1+
TNS Ping Utility for Solaris: Version 10.2.0.4.0 - Production on 14-JAN-2013 12:37:36
Copyright (c) 1997, 2007, Oracle. All rights reserved.
Used parameter files:
oracle/product/10.2.0.4/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.19.246.142)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 172.19.246.143)(PORT = 1521)) (LOAD_BALANCE = no) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = DATABASE1)))
OK (0 msec)
It said it had used the tnsnames, so I went to take a look at it:
+$cd /oracle/product/10.2.0.4/network/admin/+
+$ls+
samples shrept.lst sqlnet.log sqlnet.ora
There's no tnsnames.ora. Did Oracle lie to me? :) This is the sqlnet.ora:
+$cat sqlnet.ora+
+# sqlnet.ora Network Configuration File: /oracle/product/10.2.0.4/network/admin/sqlnet.ora+
+# Generated by Oracle configuration tools.+
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
Thanks for your help.