This content has been marked as final. Show 4 replies
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 220.127.116.11 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.