Error connecting to Oracle DB with Data Guard enabled

Asked By anville 10 points N/A Posted on - 02/12/2012

Hello,

This is the error message on Tableau data connection:

Oracle database error 16224: ORA-16224:Database Guard is enabled.

The error took place just after clicking Connect (Step 3: establish connection).  My environments:

• Tableau Desktop 6.1.3
• Oracle driver for Desktop 6.1 (downloaded from tableausoftware.com site)

The Oracle database is a reflection database which is using Oracle Data Guard.  Using SQLPlus and Toad, the database connection is successful and queries run without problems. But the problem occurs while trying to connect with Tableau. The Oracle DB version is 10.2.0.1.

Can anyone here help me please?

Thanks.

• Status: Open
• Question Views: 2034
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: Oracle Database

Best Answer by cathy emrald

Go To Solution

Answered By Hoiske bahu 0 points N/A #95019

Error connecting to Oracle DB with Data Guard enabled

 

Hello Anville,

I hope this could help you… 

It could be possible that the operation could not connect to a physical database because the database guard is enabled. Have you checked your data guard status? The logical standby has to be checked as to which it has been set – since its status – all, standby, or none gives protection to your data from being changed. Look into your v$database:

SQL> select guard_status from v$database;

GUARD_S

Thus, get to verify if the operation performed is correct, check your guard status, and update the data guard instance as “standby”. Guard status are categorized as the following:

ALL – ONLY SYS can perform changes to any data in the DB

STANDBY – ONLY SYS can perform changes to any DB object maintained by logical standby.

NONE – provides normal security for all data in the DB

 

 

About Hoiske bahu

Questions
4

Answers
9

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 02/12/2012
• Question Category: Oracle Database

Best Answer

Best Answer

Answered By cathy emrald 5 points N/A #95021

Error connecting to Oracle DB with Data Guard enabled

The problem defines itself, ORA-16224: Database Guard is enabled. It means that the database guard is set to Enabled. So to fix it, please disable and verify the operation. To disable it:

On Standby Database:

1. SQL > Alter database recover managed standby database cancel;

2. SQL > Alter system set log_archive_dest_state_2=DEFER;

On Primary Database:

1. SQL > Alter system set_log_archive_dest_state_2=DEFER;

Disabling the Database Guard depends on what are you actually doing.

 

About cathy emrald

Questions
3

Answers
415

Best Answers
148

• Vote Up 0 Vote Down

• Posted on - 08/21/2012
• Question Category: Oracle Database