OCI OBIEE Cannot connect to database When sometimes you try to run a Wuery in Answers you will get the below error.
“The account is locked at OCI call OCILogon”
This can happen for various reasons for example, when trying to rename a repository that is currently online. You may get the error message:
* ORA-28000: the account is locked at OCI call OCLogon. [nQSError: 17014] Could not connect to Oracle database. (HY000)
or even just the Could not connect component of it. What s surprising is that the account that is locked has nothing to do with OBIEE. It s the Oracle database schema used by the Connection Pool within the repository account sh in the case of the tutorials.
Logon to SQL*Plus as sys or system and issue the command:
* alter user account unlock;
Unfortunately, this error seems to tie the entire OBIEE configuration up in knots , so you may well have to reboot the system to get Answers up and working again.