Hi!
Environment: Windows XP Pro, Oracle 9i Client, Oracle 11g Database
There seems to be a conflict. On my pc, I have Oracle 9i Client (9.2.0.1.0) with multiple entries in the tnsname.ora.
In addition, I have a database (11g) installed locally for testing purposes. The Windows services are set to manually,
so I do not have them running all the time. Strangely enough when trying to connect to a database in our domain
the above message appears.
So, the tnsping dbname (in domain) is using the sqlnet.ora for the locally installed database.
TNS Ping Utility for 32-bit Windows: Version 11.2.0.2.0 - Production on 25-NOV-2
011 11:51:51
Copyright (c) 1997, 2010, Oracle. All rights reserved.
Parameterdateien benutzt:
C:\app\oracle\product\11.2.0\dbhome_1\network\admin\sqlnet.ora
TNS-03505: Failed to resolve name
Local sqlnet.ora config.
# 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.
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
SQLNET.AUTHENTICATION_SERVICES = (NTS)
Goal is to be able to connect to the databases in the domain, as well as the local database.
Thanks for your help!