obieefans.com

Feed Rss

Account is locked by OCI call … Could not connect to Oracle database

07.28.2011, OBIEE, by .

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.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>