Kbase P6909: Oracle error -12154: TNS could not resolve service name.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/14/2003 |
|
Status: Unverified
FACT(s) (Environment):
Oracle 8.1.7
SYMPTOM(s):
ORA -12154: TNS could not resolve service name.
Oracle error -12154 is seen when connecting to oracle through schema holder
"tnsping ORACLE_SID" returns Oracle error TNS-03505: Failed to resolve name
TNS_ADMIN environment variable is manually set, however not set to the directory where "tnsnames.ora" file resides.
TNS_ADMIN environment variable is directly set to the tnsnames.ora filename
CAUSE:
TNS_ADMIN variable is not pointing to the correct direcly where tnsnames.ora resides and is also directly pointing to the tnsnames.ora filename.
Example of the problem:
TSN_ADMIN=/usr1/tnsnames.ora
TSN_ADMIN=C:\xyz\tnsnames.ora
FIX:
Set TSN_ADMIN only to the directory path, not to the filename. This variable can be set on either a UNIX or a Windows environment.
TSN_ADMIN=/usr1/oracle/ora81
etwork/ADMIN
TSN_ADMIN=C:\oracle\ora81\network\ADMIN