ORA-16803: Unable to query a database table or fixed view.

Answers were Sorted based on User's Feedback



ORA-16803: Unable to query a database table or fixed view...

Answer / guest

Tested one thing.

While primary and standby both are running, both configured
to use SPFILE and if manually rename SPFILE of primary to
something else, DGMGRL will give this error. Then renaming
back SPFILE properly solves this isssue.

AA

Is This Answer Correct ?    2 Yes 0 No

ORA-16803: Unable to query a database table or fixed view...

Answer / guest

Cause: Failed to query a database table or fixed view. The
database may not be open or mounted.

Action: Check Data Guard broker log for more details.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

NNO-00631: warning: forwarder number has invalid name "string", forwarder ignored

1 Answers  


ORA-03283: specified datafile string does not exist

1 Answers  


ORA-14057: partition "string": sum of PCTUSED and PCTFREE may not exceed 100

1 Answers  


ORA-07637: smsdbp: buffer protect option not specified when sga created

1 Answers  


PCC-02102: Fatal error while doing C preprocessing

1 Answers  


ORA-06261: NETNTT: nrange() failed

1 Answers  


ORA-38470: cannot revoke a privilege that was not granted.

1 Answers  


KUP-04047: error parsing record from external data source

1 Answers  


RMAN-08120: WARNING: archive log not deleted, not yet applied by standby

1 Answers  


ORA-14262: new subpartition name must differ from the old subpartition name

1 Answers  


SQL*Loader-00628: Character set conversion error.

1 Answers  


ORA-24382: statement handled already executed or described

1 Answers  


Categories