5 Replies Latest reply: Mar 30, 2010 8:48 AM by 601737 RSS

    Change SYS password in Dataguard enviroment.

    601737
      Hi all.
      I have a RAC with 2 nodes and 1 Physical Standby, 10.2.0.4 and Red Hat.

      I change sys password folowing this steps.
      Step 1: Defer the remote archival destination (log_archive_dest_state_n) parameter in primary
      Step 2: change the password in primary
      Step 3: Recreate or copy the password file in standby
      Step 4: Enable the remote archival destination (log_archive_dest_state_n) parameter in primary

      but when i perform a Switchover I have this error.

      DGMGRL for Linux: Version 10.2.0.4.0 - 64bit Production

      Copyright (c) 2000, 2005, Oracle. All rights reserved.

      Welcome to DGMGRL, type "help" for information.
      DGMGRL> Connected.
      DGMGRL> Performing switchover NOW, please wait...
      Operation requires shutdown of instance "OAPM3N1" on database "OAPM3N"
      Shutting down instance "OAPM3N1"...
      ORA-01017: invalid username/password; logon denied

      You are no longer connected to ORACLE
      Please connect again.
      Unable to shut down instance "OAPM3N1"
      You must shut down instance "OAPM3N1" manually
      Operation requires shutdown of instance "OAPM3D" on database "OAPM3D"
      You must shut down instance "OAPM3D" manually
      Operation requires startup of instance "OAPM3N1" on database "OAPM3N"
      You must start instance "OAPM3N1" manually
      Operation requires startup of instance "OAPM3D" on database "OAPM3D"
      You must start instance "OAPM3D" manually
      Switchover succeeded, new primary is "OAPM3D"
      DGMGRL>

      OAPM3N1 = Primary node 1
      OAPM3ND = Standby database

      after that, I need to restart all instances and everithing is OK.
      before change password i dont have any problem...

      I need to change the password in other place??