Kbase P104674: Error ORA-12560 when connecting to a local Oracle database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
03/12/2009 |
|
Status: Unverified
SYMPTOM(s):
Error ORA-12560 when connecting to a local Oracle database
Connecting to a local Oracle database from Data Administration
ORA-12560, "TNS:protocol adapter error"
Oracle error - 1012 see "Oracle Error Messages and Codes Manual". (1252)
Failed to connect to ORACLE database <db_name>. (1451)
FACT(s) (Environment):
Connection works fine from SQL*Plus
Progress 9.x
OpenEdge 10.x
All Supported Operating Systems
Oracle DataServer
CAUSE:
The Oracle environment variables for the Oracle database is set.
FIX:
The ORACLE_SID and ORACLE_HOME environment variables need to be set:
1) Exit the Progress session.
2) Go into Control Panel --> System. On the Advanced tab, click the Environment Variables button.
3) Add the following two parameters, and save/exit:
ORACLE_SID = <Your Oracle Instance ID>
ORACLE_HOME = <The directory where the Oracle product is installed>
4) Start your Progress session again and connect to the schema holder, and connect to the Oracle database.