Search This Blog

Saturday, May 27, 2023

Weblogic: java.sql.SQLException: ORA-28001: the password has expired weblogic service start (During Admin Server start)

C:>sqlplus /nolog
SQL> connect / as SYSDBA
SQL> select * from dba_profiles;
SQL> alter profile default limit password_life_time unlimited;
SQL> alter user identified by ;
SQL> commit;

SQL> exit; 

First connect SYS users in the pluggable database:

We know, belows users are needed for WEBLOGIC start. May be, password of foloowing users may expire or locked account. 

DEV_IAU_VIEWER

DEV_IAU_APPEND

DEV_IAU

DEV_OPSS

DEV_STB

DEV_WLS

DEV_WLS_RUNTIME


For all above users, The following command needs to run from SYS user:


 alter user DEV_WLS account unlock

   alter user DEV_WLS_RUNTIME identified by ABc#654