ORA-16803: Unable to query a database table or fixed view.
- 2 Answers
- 9790 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
ORA-30945: Could not create mapping table 'string'
ORA-00258: manual archiving in NOARCHIVELOG mode must identify log
KUP-03002: end position (number) <= start position (number) for field: string
ORA-15038: disk 'string' size mismatch with diskgroup [string] [string] [string]
RMAN-08585: copying standby controlfile
TNS-04044: Specified gateways do not exist.
TNS-12215: TNS:poorly formed PREFERRED_NAVIGATORS Addresses in TNSNAV.ORA
ORA-38429: invalid datatype for a stored attribute: string
ORA-02366: The following index(es) on table string were processed:
TNS-12522: TNS:listener could not find available instance with given INSTANCE_ROLE
TNS-04047: Invalid specification for destination
ORA-36392: (XSMXCLEA02) When using CLEAR with the PRECOMPUTES or NONPRECOMPUTES options, you must supply an AGGMAP.
Oracle Errors 
