Database Administration (MOSC)

MOSC Banner

ora-16000

edited Jun 14, 2018 4:59PM in Database Administration (MOSC) 10 commentsAnswered

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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center