Kbase P101751: Oracle DataServer returns ORA-01012 on any failed database connection
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/27/2006 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.1D
Progress 9.1E
OpenEdge 10.x
Oracle DataServer
SYMPTOM(s):
All failed logins for the Oracle Database returns error ORA-01012
Users logging in with wrong, expired or locked password or wrong username receive ORA-01012
ORA-01012: not logged on
Oracle DataServer returns ORA-01012 instead of ORA-01017
ORA-01017; invalid username/password; logon denied
Oracle DataServer returns ORA-01012 instead of ORA-28000
ORA-28000: password locked
Oracle DataServer returns ORA-01012 instead of ORA-28001
ORA-28001: password expired
Oracle DataServer returns ORA-01012 instead of ORA-28002
ORA-28002: password going to expire
CAUSE:
In 9.1D, the connection code for the Oracle DataServer was changed so that no matter what caused the connection to fail, error number -01012 would be returned.
FIX:
To monitor for a failed connection, you need to recognize error ORA-01012 instead of the individual error messages that might be issued from Oracle.