Kbase P62268: Error ORA-12560 when connecting to a remote Oracle database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
13/01/2004 |
|
Status: Unverified
FACT(s) (Environment):
Oracle DataServer
SYMPTOM(s):
Connecting to a remote Oracle database from Data Administration
Using SQL*Net
ORA-12560, "TNS:protocol adapter error"
Failed to connect to ORACLE database <db_name>. (1451)
Oracle error - 1012 see "Oracle Error Messages and Codes Manual". (1252)
Connection works fine from SQL*Plus
CAUSE:
The Oracle instance of the remote Oracle database is not specified when connecting.
FIX:
Add the name of the Oracle instance to the User ID when connecting:
<User ID>@<Instance Name>