ORA-01089: immediate shutdown in progress - no operations are permitted; and 'Global transaction acq
We get a strange error during select from database link.
The database link had been working for long time. But it won't work after we did the disaster recovery drill last weekend.(Data Guard failover/reinstate, switchover are all success).
One problem popup. The database link failed after database went back to original primary (the database is RAC with 3 nodes).
Select data from database link hanging. So I create a new one db link to test, then I get the error below:
SQL> select count(1) from EMP_VACATION_ITS@testzxg;
select count(1) from EMP_VACATION_ITS@testzxg
*
ERROR at line 1: