crafty762

Geodatabase Connection to Oracle Active Data Guard Physical Standby

Discussion created by crafty762 on Feb 4, 2014
Latest reply on Feb 28, 2014 by crafty762
Thank you in advance for any help you can provide. 


ENVIRONMENT

Database Server:

  • Oracle 11.2.0.2.0 Single-Instance Database on Windows Server 2003 R2 Enterprise 64-bit

  • Oracle Active Data Guard for Oracle Database 11g R2

  • ArcSDE for Oracle 11g 9.3.1 SP2 using SDELOB


Client Machine:

  • Oracle Client 11.2.0.1.0 on Windows 7 Enterprise

  • ArcGIS Desktop 9.3.1 SP2 on Windows 7 Enterprise

  • ArcGIS Desktop 9.3.1 SP2 QIP Patch

  • ArcGIS Desktop 9.3.1 SP2 Geodatabase Patch

  • ArcGIS Desktop 9.3.1 SP2 Geometric Network Patch



BACKGROUND

I have successfully created two standby databases from my primary Oracle database; one is a physical standby and the other is a logical standby.  When attempting to connect to either of the standby databases using direct connect in ArcCatalog, I receive the following error: "Failed to connect to the specified server.  Operation Failed".  After some online research, it seemed like there may be an issue with the authorization of the geodatabase from a licensing perspective.  This would make sense since the standby databases have a different DB_UNIQUE_NAME than the primary.  Therefore, I tried to authorize both standby databases using the ArcSDE for Oracle 11g Post Installation, trying both of the standby database unique names as the NET SERVICE value.  However, I end up with a similar error:

ESRI ArcSDE Server Setup Utility Tue Feb 04 13:33:01 2014
----------------------------------------------------------------
Error: Operation Failed (-1).
Error: Error upgrading authorization key.

It then occurs to me that both standby databases are running in read-only mode, which is expected when creating standby databases via Oracle Active Data Guard.  After some more research, I find that it is possible to modify a standby database such that it can run in read-write mode.  After modifying the physical standby to run in read-write mode, I am then able to authorize it using the ArcSDE for Oracle 11g Post Installation.  Afterward, however, I was unable to resume the application of redo logs for the standby database which essentially broke the connection between my standby and my primary.  This was evident after receiving a variety of Oracle errors (e.g., ORA-01665 and ORA-01153) when following the Oracle documentation for how to switch from the standby back to the primary. 


QUESTION

Has anyone used ArcSDE in conjunction with Oracle Active Data Guard?  If so, how am I able to make a geodatabase connection to the standby?  I am trying to determine the high-level proper workflow for creating a standby database, authorizing the geodatabase, and subsequently configuring the standby to receive archived redo data from the primary database (using either Redo Apply or Real-Time Apply).   


Again, thank you in advance for any help you can provide.  If you require more information, please just let me know.

Outcomes