ora-16000
Hello
I am getting this error in oracle 10.2.0.3
SQL> /
select * from approvallogm1@psvmgr7s.world
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-16000: database open for read-only access
ORA-02063: preceding 2 lines from PSVMGR7S
The psvmgr7s is a standby database in the read only mode ( I have verified that). I was told by the application team that this has been working just fine for them until today. When I login to the standby database locally I am able to execute this select without issues. But there is a note 437254.1 that seems to state that this error is expected. I am a little confused right now. Does anyone has any experience with this issue?