How to get a list of locked users in Oracle

Document ID : KB000097574
Last Modified Date : 22/05/2018
Show Technical Document Details
Introduction:
When trying to get to the login screen we see an Oracle error saying we cannot connect. How can we check if we're locked out of the database?

You may also see strings errors, such as [MSG - Messages/General/ERROR_INTERNAL_ERROR_TEXT] 
Instructions:
The following query will list all the users in the system and their lock status, so you can see if any need to be unlocked:

SELECT username, 
       account_status
  FROM dba_users;

If you do have any locked ones, then they can be unlocked and/or have their password reset with
 
ALTER USER user_name IDENTIFIED BY password ACCOUNT UNLOCK;

Then you'll need to use the PassUpdate utility on both Web and App servers to ensure that BSI knows the correct password for that user:

   %OG_HOME%\Utilities\PassUpdate\PassUpdate.exe

You'll find more about PassUpdate in the BSI Documentation:

https://docops.ca.com/ca-business-service-insight/8-3-5/en/administration/passwords