Home › Discussions › Questions & Answers › Prerequisites for Running Reports on Standby Database (ADG)

Prerequisites for Running Reports on Standby Database (ADG)

Avatar photoCustomer September 10, 2023 at 8:23 pm

We want to configure certain Blitz Reports to run on our standby database via Active Data Guard. What database objects are required for this functionality?

Viewing 4 reply threads
  • Author
    Replies
    • Support September 11, 2023 at 3:00 am  

      Running reports on a standby database requires Oracle 19c or higher with Active Data Guard licensed and configured. The key database object needed is the xxen_adg database link, which must be created in the primary database APPS schema and point to the standby pluggable database (PDB).

    • Avatar photoCustomer September 11, 2023 at 11:46 pm  

      And how is the specific standby database selected for a report?

    • Support September 13, 2023 at 7:40 am  

      On the Blitz Report setup window, under Report Options, you specify the TNS descriptor of the standby database in the ‘Target Database’ field. This descriptor must be defined in $TNS_ADMIN/tnsnames.ora on the application server.

    • Avatar photoCustomer September 14, 2023 at 5:14 pm  

      Are there any necessary database events to set?

    • Support September 15, 2023 at 9:19 am  

      Yes, Event 10946 should be set in both primary and standby databases, as explained in Oracle documentation, to support this configuration.

  • Author
    Replies
Viewing 4 reply threads
  • You must be logged in to reply to this post.

Login with:
Popular Posts
How to track master data changes using Oracle EBS Audit function and Blitz Report™ 123744

Oracle Enterprise Command Center Framework Release 12.2 installation and integration with Oracle EBS 12.2.8 19788

Oracle Discoverer replacement – importing worksheets into Blitz Report™ 14609

How to check if a patch is applied in Oracle EBS 12.2 14382

Oracle Discoverer 11.1.1.7 installation and integration with Oracle EBS R12.1.3 14071

Oracle E-Business Suite 12.2.8 upgrade to version 12.2.9 11963

Oracle E-Business Suite 12.2.7 upgrade to version 12.2.8 9897

Migration to Java Web Start in Oracle EBS 12.2 instance 9890

Securing sensitive data with Oracle VPD 7793

EBS 12.1.3 BI Publisher Excel templates generate XLS instead of XLSX and limit row number to 65,536 6446

Blog Archive
2026
2025
2024
2023
2022
2021
2020
2019
2018
2017
Recent Events
2026
2025
2024
2023
2022
2021
2020
2019
2018