ORA-28002 : the password will expire within 5 days – WARNING from recovery catalog database

Published by Jignesh Jethwa
Oracle 11g Logo

Today morning, I have encountered “RMAN-04007: WARNING from recovery catalog database” & “ORA-28002: the password will expire within 5 days” warnings while logged in to RMAN prompt for daily database activities as below.

[oracle@dbserver ~]$ rman target / catalog rman/rman123@cata
Recovery Manager: Release 11.2.0.3.0 – Production on Mon Mar 3 14:47:41 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: G***** (DBID=3582658665)
RMAN-04007: WARNING from recovery catalog database: ORA-28002: the password will expire within 5 days

connected to recovery catalog database

 

Cause: RMAN repository database ( Catalog db ) user is suppose to expire within 5 days due to password expiry constraint applied to default profile.

 

Work around: Oracle warning message is pretty much self explanatory, we just need to change password of RMAN user. In my case i have configured my default profile password_life_time to unlimited & change RMAN user password to current( same ) password, so that all RMAN backup script need not to change for future backups.
Note: CATA is my catalog database name.

[oracle@dbserver ~]$ export ORACLE_SID=cata
[oracle@dbserver ~]$ sqlplus “/ as sysdba”
SQL*Plus: Release 11.2.0.3.0 Production on Mon Mar 3 14:52:32 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Release 11.2.0.3.0 – 64bit Production

SQL> select global_name from global_name;
GLOBAL_NAME
——————————
CATA

SQL> select profile from DBA_USERS where username = ‘RMAN’;
PROFILE
——————————
DEFAULT

SQL> alter profile default limit password_life_time UNLIMITED;

Profile altered.

SQL> alter user rman identified by rman123;

User altered.

//After following above work around, I would login RMAN prompt without any warnings & errors, like below:

[oracle@dbserver ~]$ rman target / catalog rman/rman123@cata
Recovery Manager: Release 11.2.0.3.0 – Production on Mon Mar 3 15:13:03 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: G***** (DBID=3582658665)
connected to recovery catalog database

RMAN>

***********************************************************************
Note: Please don’t hesitate to revert in case of any query OR feedback.

Thanking you.

Have a easy life ahead.

Leave a Reply