0 Replies Latest reply on Apr 24, 2017 8:55 AM by Nick Bedeker

    EBS 12.2 Dataguard on Oracle DB 12.1

    Nick Bedeker

      I have configured DataGuard for EBS12.2 on DB version 12.1.0.2. The DataGuard setup works, I have configured DG Broker and a switchover goes smooth. However, the EBS configuration after the switchover doesn't.

      When I run ./adautoconfig.sh on the DB after switchover it fails. I suspect something with TNS or the services advertised by the DB.

      My context_ifile.ora:

      VIS =

        (DESCRIPTION =

          (ADDRESS = (PROTOCOL = TCP)(HOST = primary-host)(PORT = 1561))

          (CONNECT_DATA =

            (SERVER = DEDICATED)

            (SID = VIS)

          )

        )

       

       

      VISDG =

        (DESCRIPTION =

          (ADDRESS = (PROTOCOL = TCP)(HOST = standby-host)(PORT = 1561))

          (CONNECT_DATA =

            (SERVER = DEDICATED)

            (SID = VIS)

          )

        )

       

      VIS is the Alias for my primary and VISDG the Alias for my standby. According to MOS 1963472.1 the entry for VISDG has to change to point to the New standby-host after switchover. However, only by changing the entry for VIS to point to the New primary-host does autoconfig complete successfully. Unfortunately this change breaks dataguard and I start getting DGID mismatch errors.