Kbase P79357: oracle error 1012 connecting to Oracle when ORACLE_SID is defined but Instance is remote
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
19/09/2008 |
|
Status: Verified
SYMPTOM(s):
oracle error 1012 when connecting to Oracle
Oracle error - 1012 see "Oracle Error Messages and Codes Manual". (1252)
ORA: -1012 not logged on
Use login and password to log in from DataServer
The login and password is for a valid user in Oracle database
ORACLE_SID is set prior to starting DataServer session
Oracle instance is remote
Only Oracle client installed on the machine
Receive errors when running
sqlplus login/password
FACT(s) (Environment):
Oracle DataServer
UNIX
Progress 8.x
Progress 9.x
OpenEdge 10.x
CAUSE:
Oracle is remote but when ORACLE_SID is set, both sqlplus and DataServer will try to resolve instance name from local configuration. Because locally only Oracle client is installed, this caused error
FIX:
1. unset ORACLE_SID environment variable, the command to use is:
unset ORACLE_SID
2. Connect to Oracle as login@instance/password