Hi everyone,
I am having some trouble reaching a DB using tnsping utility on Solaris 5.10.
I have no issue connecting to this db (db1) using other PC's, but something about this configuration is messing it up. I should mention that there are currently 4 oracle installs on this machine, 9.2.0.8, 10.2.0.3, 10.2.0.4, and 11g (the most recent install).
It seems from the below that since the 11g install, tnsping & sqlplus are trying to use the 11g files, so I updated the tnsnames and sqlnet files.
here is the feedback from tnsping:
tnsping db1
Used parameter files:
/opt/oracle/product/11g/11.1.0.6/network/admin/sqlnet.ora
TNS-03505: Failed to resolve name
sqlnet.ora
/admin$ pwd
/opt/oracle/product/11g/11.1.0.6/network/admin
/admin$ cat sqlnet.ora
# sqlnet.ora Network Configuration File: c:\apps\oracle\client\10.2.0\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.
# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT, LDAP)
tnsnames.ora
/admin$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /opt/oracle/product/11g/11.1.0.6/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
LISTENER_aduh12 =
(ADDRESS = (PROTOCOL = TCP)(Host = fyr21.us.xyz.com)(Port = 1524))
db1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = au101.ips.xyz.com)(PORT = 1521))
(CONNECT_DATA =
(SID = db1)
)
)
aduh12 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(Host = bsel71.us.xyz.com)(Port = 1524))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = aduh12.us.xyz.com)
)
)
Any ideas why this does not work as expected? Any help would be appreciated. Thanks!