This content has been marked as final. Show 4 replies
You should create a profile with no password expiry and assign it to the RMAN user. The expiry date on the user record is for informational purposes only.1 person found this helpful
Ategrity Solutions Ltd
Hello,1 person found this helpful
Set the PASSWORD_LIFE_TIME to UNLIMITED in the profile that has been assigned to the RMAN user.
How to make password not to expire permanently.
If you feel that your question has been answered, then please consider closing the thread by providing appropriate points. Please keep the forum clean !!
Krishna Agnihotri wrote:Not unless you want to risk corrupting the data dictionary.
In My case 22.214.171.124 RMAN password expired and backup failed. We want that RMAN user password should never expire. Kindly advice us how i can do this.
should i use
update dba_users set expiry_date=NULL where username='RMAN'
All the data dictionary views (DBA_*, ALL_*, USER_*, V$*) are provided to reveal system information from underlying and undocumented tables. You should NEVER - EVER issue DML against them.
or i should create a new user profile for password never expires and attached to RMAN user.
Thanks to all for advice.