Kbase P19326: ORACLE error -1012 when ORACLE_SID is not set correctly
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/24/2004 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.1x
Oracle DataServer
Oracle
SYMPTOM(s):
ORACLE error -1012 see "ORACLE Error Messages and Codes Manual". (1252)
not logged on Failed to connect to ORACLE database <dbname>. (1451)
BROKER: The server could not open the foreign database. (1891)
Oracle is running.
Dataserver broker running on UNIX
Receive same errors on both UNIX and on Windows from the client attempting to connect to Oracle database
CAUSE:
ORACLE_SID is not set correctly prior to starting dataserver broker, specifically, ORACLE_SID was set to mySid but the real ORACLE_SID is mysid.
FIX:
Set ORACLE_SID correctly. On Unix, prior to start broker, execute following commands
ORACLE_SID=mysid; export ORACLE_SID