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

ORA-00298: Missing or invalid attribute value

1 Answers  


TNS-04070: Cannot administer a remote Oracle Connection Manager instance which is not yet started.

1 Answers  


ORA-28521: no heterogeneous capability information available

1 Answers  


RMAN-06063: DBID is not found in the recovery catalog

1 Answers  


ORA-19207: scalar parameter string of XMLELEMENT cannot have an alias.

1 Answers  


ORA-01070: Using an old version of Oracle for the server

1 Answers  


QSM-01058: MV, string, does not have column, string, for a joinback

1 Answers  


DRG-10000: failed to read column string.string

1 Answers  


LCD-00100: internal error, argument [number]

1 Answers  


PLS-00316: PL/SQL TABLEs must use a single index

1 Answers  


ORA-02794: Client unable to get key for shared memory

1 Answers  


RMAN-06438: error executing package DBMS_RCVMAN in string database

1 Answers  


Categories