Sunday, January 22, 2017

ORA-16224: Database Guard is enabled

SQL> INSERT INTO TRANSACTION_INFO(BRANCH_CODE, HOUR, MINUTES)
VALUES(122,12,12);  2
INSERT INTO TRANSACTION_INFO(BRANCH_CODE, HOUR, MINUTES)
            *
ERROR at line 1:
ORA-16224: Database Guard is enabled


SQL> SELECT GUARD_STATUS FROM GV$DATABASE;

GUARD_S
-------
ALL
ALL

SQL> ALTER DATABASE GUARD NONE;

Database altered.

SQL> SELECT GUARD_STATUS FROM GV$DATABASE;

GUARD_S
-------
NONE
NONE

SQL> INSERT INTO TRANSACTION_INFO(BRANCH_CODE, HOUR, MINUTES)
VALUES(122,12,12);  2

1 row created.

SQL> commit;

Commit complete.

SQL>

No comments:

Post a Comment