hi everyone,
I got this message during an RMAN backup to the catalog database that resides on another server yesterday. when I query the RMAN user I get the following output.
it appears all the resources for RMAN user are already UNLIMITED.
SQL> select LIMIT, RESOURCE_NAME from dba_profiles where RESOURCE_NAME in ('PASSWORD_GRACE_TIME','PASSWORD_LIFE_TIME','PASSWORD_REUSE_MAX','PASSWORD_REUSE_TIME') and PROFILE=(select profile from dba_users where username='RMAN');
LIMIT RESOURCE_NAME
----------------------------------------------------------------------------------------------------
UNLIMITED PASSWORD_LIFE_TIME
UNLIMITED PASSWORD_REUSE_TIME
UNLIMITED PASSWORD_REUSE_MAX
UNLIMITED PASSWORD_GRACE_TIME
SQL> select username, account_status from dba_users where username='RMAN';
USERNAME
ACCOUNT_STATUS
---------------------------------------------------------------------------
---------------------------- --------------------------------
RMAN
OPEN
THIS ERROR OCCURED when I connected to the CATALOG DATABASE :
G:\>RMAN TARGET sys/sysdba CATALOG rcman/rcman@rxxx;
Recovery Manager: Release 12.1.0.2.0 - Production on Sun Feb 18 18:17:18 2018
Copyright (c) 1982, 2016, Oracle and/or its affiliates. All rights reserved.
connected to target database: Pxxx (DBID=xxxxxxxxxxxxxxx)
RMAN-04007: WARNING from recovery catalog database: ORA-28002: the password will expire within 7 days
so my question is, is it the RCMAN password that needs to be changed. when I query rcman I get no output.
SQL> select username from dba_users where username='RCMAN'
no rows selected
SQL>
this error seems to be happening under RCMAN not RMAN...thanks for any tips and advice.