RMAN-04009: warning from auxiliary database: ORA-28002: the password will expire within 6 days
First check the profile that user has been assigned.
SQL> select username , profile from dba_users where username=’RMAN’;
username profile
------------- ---------------
RMAN DEFAULT
Check the current status of the user
SQL> select USERNAME, ACCOUNT_STATUS from dba_users where USERNAME = ‘RMAN’;
USERNAME ACCOUNT_STATUS
------------- ----------------- --------------------------------
RMAN EXPIRED(GRACE)
Check the RESOUCE_NAME, LIMIT for the Default profile.
SQL> select RESOURCE_NAME,LIMIT from dba_profiles where PROFILE='DEFAULT';
RESOURCE_NAME LIMIT
--------------------------- -------------------------------------------------
COMPOSITE_LIMIT UNLIMITED
SESSIONS_PER_USER UNLIMITED
CPU_PER_SESSION UNLIMITED
CPU_PER_CALL UNLIMITED
LOGICAL_READS_PER_SESSION UNLIMITED
LOGICAL_READS_PER_CALL UNLIMITED
IDLE_TIME UNLIMITED
CONNECT_TIME UNLIMITED
PRIVATE_SGA UNLIMITED
FAILED_LOGIN_ATTEMPTS 10
PASSWORD_LIFE_TIME 180
RESOURCE_NAME LIMIT
PASSWORD_REUSE_TIME UNLIMITED
PASSWORD_REUSE_MAX UNLIMITED
PASSWORD_VERIFY_FUNCTION NULL
PASSWORD_LOCK_TIME 1
PASSWORD_GRACE_TIME 7
INACTIVE_ACCOUNT_TIME UNLIMITED
As we see password PASSWORD_LIFE_TIME set to 180 days
First you need to change the password for the issue to resolve.
SQL> Alter user rman identified by rman_new_password;
As current password life time set 180 days, You can change the password life time to avoid this issue in future. Either you can set to specific number of days or UNLIMITED.
SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
Profile altered.
You can check the modified resource limit for PASSWORD_LIFE_TIME
SQL> select RESOURCE_NAME,LIMIT from dba_profiles where PROFILE='DEFAULT' and RESOURCE_NAME='PASSWORD_LIFE_TIME';
RESOURCE_NAME LIMIT
--------------------------- -------------------------------------------------
PASSWORD_LIFE_TIME UNLIMITED
username profile
------------- ---------------
RMAN DEFAULT
Check the current status of the user
SQL> select USERNAME, ACCOUNT_STATUS from dba_users where USERNAME = ‘RMAN’;
USERNAME ACCOUNT_STATUS
------------- ----------------- --------------------------------
RMAN EXPIRED(GRACE)
Check the RESOUCE_NAME, LIMIT for the Default profile.
SQL> select RESOURCE_NAME,LIMIT from dba_profiles where PROFILE='DEFAULT';
RESOURCE_NAME LIMIT
--------------------------- -------------------------------------------------
COMPOSITE_LIMIT UNLIMITED
SESSIONS_PER_USER UNLIMITED
CPU_PER_SESSION UNLIMITED
CPU_PER_CALL UNLIMITED
LOGICAL_READS_PER_SESSION UNLIMITED
LOGICAL_READS_PER_CALL UNLIMITED
IDLE_TIME UNLIMITED
CONNECT_TIME UNLIMITED
PRIVATE_SGA UNLIMITED
FAILED_LOGIN_ATTEMPTS 10
PASSWORD_LIFE_TIME 180
RESOURCE_NAME LIMIT
PASSWORD_REUSE_TIME UNLIMITED
PASSWORD_REUSE_MAX UNLIMITED
PASSWORD_VERIFY_FUNCTION NULL
PASSWORD_LOCK_TIME 1
PASSWORD_GRACE_TIME 7
INACTIVE_ACCOUNT_TIME UNLIMITED
As we see password PASSWORD_LIFE_TIME set to 180 days
First you need to change the password for the issue to resolve.
SQL> Alter user rman identified by rman_new_password;
As current password life time set 180 days, You can change the password life time to avoid this issue in future. Either you can set to specific number of days or UNLIMITED.
SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
Profile altered.
You can check the modified resource limit for PASSWORD_LIFE_TIME
SQL> select RESOURCE_NAME,LIMIT from dba_profiles where PROFILE='DEFAULT' and RESOURCE_NAME='PASSWORD_LIFE_TIME';
RESOURCE_NAME LIMIT
--------------------------- -------------------------------------------------
PASSWORD_LIFE_TIME UNLIMITED
Hope this helps
Thanks & Regards
http://oracleracexpert.com, Oracle ACE Pro
As I have seen you have a lot of database technical knowledge. I am also a PHP developer but resolve this kind of database error are very confusing. I am doing my PhD in IT and my professor assigned me two assignments, 'Database technologies' and 'Digital Marketing thesis writing'. The first one 'Database technologies' has been approved but the second one I am looking for digital marketing thesis writing services company. Because thesis is very hard for me. But I am not sure about these websites because it is my first time to take help from such websites if there is anyone who helps me regarding this?
ReplyDeleteAuxiliary databases are a great way to store data that needs to be accessed quickly, but they can also be a potential security risk. my assignment essay helper sure you have adequate security measures in place to protect your data from malicious actors.
ReplyDeleteThis article is incredibly helpful and informative! I'm looking forward to learning even more about composition from future articles.Online dissertation writer UAE
ReplyDelete