Error ORA-28001: the password has expired, during System Startup
Kiran Dalvi
13 Sep, 2023
0 Comments
37 Secs Read
Error ORA-28001: the password has expired, during System Startup
Error ORA-28001: the password has expired, during System Startup.
Solution :
Check the database owner with the following statements:
SELECT owner FROM dba_tables WHERE table_name='T000';
SELECT owner FROM dba_tables WHERE table_name='J2EE_CONFIG';
Use the result in the following statement:
ALTER USER <username>IDENTIFIED BY <password> ;
Now password is altered but the table SAPUSER isn’t changed, so you may face ORA-01017. so use brconnect oracle dictionary and SAPUSER table and update it with following statement:
brconnect -u system/ -f chpass -o -p
If a user is already locked, you can unlock it as follows (951167):
ALTER USER ACCOUNT UNLOCK;
SELECT owner FROM dba_tables WHERE table_name='J2EE_CONFIG';