ANKUSH THAVALI
- 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 -pIf 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';