SQL Account Is Locked (ORA-28000)

If you ever get the following message:

SQL Access Manager
SQL error. Stmt #: 2 Error Position: 0 Return 2800 - ORA-28000: the account is locked.

This means that the system account used by PeopleSoft (typically SYSADM in Oracle) has been locked. If you (can) try to login to the environment using SYSADM through a SQL tool you would get the same error. This error occurred when I was attempting to do a compare report in application designer but could happen at any time.

Ask your DBA to unlock the account, as they will need to login with SYS access to an Oracle database.

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License