Blog dedicated to Oracle Applications (E-Business Suite) Technology; covers Apps Architecture, Administration and third party bolt-ons to Apps

Thursday, August 5, 2010

ORA-28000: the account is locked at OCI call OCISessionBegin

If you ever get this error in OTM/FTI Transportation Intelligence screens:

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 17001] Oracle Error code: 28000, message: ORA-28000: the account is locked at OCI call OCISessionBegin. [nQSError: 17014] Could not connect to Oracle database. (HY000)

Your HDOWNER user is locked out at database stage. Unlock the user

Login as the unix owner of ROD database. Make sure your ORACLE_HOME and other environment variables are set correctly.

sqlplus /nolog
conn / as sysdba
alter user HDOWNER account unlock;

No comments: