Advabuild user locked out of Adminitrative Client,Control Builder, TCL Builder, TLL Builder or MOD 300 Engineering Displays
When the user tries to log into Adminstrative Client, Control Builder, TCL Builder, TLL Builder or MOD 300 Engineering Designs, he gets the following popup error
If he tries to log into Oracle with that username and password, he receives the Oracle error
ORA-28000 : User Account is locked.
Rebooting the engineering station does not correct the problemSymptoms:
In order to unlock the user account in Oracle, you will need to log into Oracle in a windows command window with
sqlplus "/ as sysdba"
To see which accounts are locked, at the SQL prompt enter
SQL>SELECT username, account_status from dba_profiles where profle='DEFAULT';
The usernames you are interested in seeing if they are locked are admin, admin_RDR, admin_DCQ, and <project>._CFG where <project> is the name of your Advabuild database. If you see one of these usernames locked, enter the following commands at the SQL prompt. As an example I will use the admin username. Replace admin in these command with the username that is locked.
SQL> alter user admin account unlock;
SQL> grant connect, resource to admin;
The username should be unlocked and you should be able to log into the applications.