Friday, October 2, 2015

Received exception while creating connection for pool "oamDS" : ORA-28001 : the password has expired.

One of the error I have faced is password expiration for OIM, OAM, SOAINFRA etc when i tried to open the VM after long time.

ISSUE:
Received exception while creating connection for pool "oamDS" : ORA-28001 : the password has expired.

Error Observed:


























CAUSE:
The password has expired for the schema.

SOLUTION:
1.  Login to Database using sqlplus command.
2.  Provide username name as sys as sysdba and the password.
3. Run the query  select USERNAME,EXPIRY_DATE,LOCK_DATE,ACCOUNT_STATUS from dba_users where username like '%DEV%'; where DEV  is the schema prefix. Please provide it as per your environment.
4. USERNAME                 EXPIRY_DA/ LOCK_DATE      ACCOUNT_STATUS
            ------------------------------ --------- --------- ----------------------------------------------------------
            DEV_IAU_APPEND                  25-SEP-15                                   OPEN
            DEV_IAU_VIEWER                   25-SEP-15                                   OPEN
            DEV_IAU                                    25-SEP-15                                    OPEN
            DEV_ORASDPM                       29-SEP-15                                    EXPIRED
            DEV_MDS                                  29-SEP-15                                    EXPIRED
            DEV_OIM                                   29-SEP-15                                    EXPIRED
            DEV_SOAINFRA                       29-SEP-15                                    EXPIRED
            DEV_OAM                                  29-SEP-15                                    EXPIRED

      5. Now from above table we can see that password for some schema is expired. Now we have to reset this            password.

      6. Run the following queries to reset the password for Expired schema.

          alter user DEV_ORASDPM identified by <password>;
          alter user DEV_OIM identified by <password>;
          alter user DEV_MDS identified by <password>;
          alter user DEV_SOAINFRA identified by <password>;
          alter user DEV_OAM identified by <password>;
          commit;
    
     7. Now restart the server and provide the new password you have given in above step. It will start now                   without any issues.
  

No comments:

Post a Comment

Other Posts