4 Replies Latest reply: Dec 13, 2012 3:31 AM by KrishnaAgnihotri RSS

    RMAN User password expires.

    KrishnaAgnihotri
      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