This discussion is archived
4 Replies Latest reply: Dec 13, 2012 1:31 AM by KrishnaAgnihotri RSS

RMAN User password expires.

KrishnaAgnihotri Explorer
Currently Being Moderated
Hi

In My case 11.2.0.3 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'

or i should create a new user profile for password never expires and attached to RMAN user.

Kindly advice.

Thanks
Krishna

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points