ORA-16397: statement redirection from Oracle Active Data Guard standby database to primary database failed

ORA-16397: statement redirection from Oracle Active Data Guard standby database to primary database failed

Error:
Following error occurred during insert/DML operation on the Standby side of Active Dataguard in Oracle.
On Standby Database:

[oracle@orcl19c ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 – Production on Sat Nov 16 11:33:18 2019
Version 19.2.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Beta
Version 19.2.0.0.0
SQL> select * from testDMLtable;
NAME      TESTDATE
------    ----------------------------
sunny     16-NOV-19 11.35.19.000000 AM

SQL> INSERT INTO testDMLtable(c1, c3) VALUES ('RAM', sysdate);
INSERT INTO testDML(c1, c3) VALUES ('RAM', sysdate)
            *
ERROR at line 1:
ORA-16397: statement redirection from Oracle Active Data Guard standby database
to primary database failed
SQL> exit

Cause
Found the cause that we need to connect the session with username/password@standby_tns in case of using Active Dataguard DML redirection operations instead of sqlplus / as sysdba.

Solution
We need to connect the STANDBY database with SQLPLUS username/password@standby

-- AT standby database

[oracle@orcl19c ~]$ sqlplus scott/password@stanbyorcl as sysdba
SQL*Plus: Release 19.0.0.0.0 – Production on Sat Nov 16 11:41:13 2019
Version 19.2.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Beta
Version 19.2.0.0.0

SQL> select * from testDMLtable;
NAME      TESTDATE
------    ----------------------------
sunny     16-NOV-19 11.42.14.000000 AM

SQL> INSERT INTO testDMLtable(c1, c3) VALUES ('RAM', sysdate);
1 row inserted.

SQL> Commit;
SQL> exit;

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.