Wednesday, April 30, 2014

ORA-28000: the account is locked – PeopleSoft

Just a small PeopleSoft issue I ran into while running an SQR:
(SQR 5528) ORACLE OCISessionBegin(RDBMS) error 28000 in cursor 0:
   ORA-28000: the account is locked
(SQR 4701) Cannot logon to the database.

SQR for PeopleSoft: Program Aborting.
For some reason the sysadm account had been locked, thankfully there’s a fairly easy fix:

For some reason the sysadm account had been locked, thankfully there’s a fairly easy fix:
1
ALTER USER sysadm ACCOUNT UNLOCK;
If you don’t have access you may need to get a DBA to run it.

No comments:

Post a Comment