Querying gv$instance keeps failing with ORA-12805 in RAC
(Doc ID 2014298.1)
Last updated on SEPTEMBER 03, 2023
Applies to:
Oracle Database Cloud Service - Version N/A and laterOracle Database Backup Service - Version N/A and later
Oracle Database - Standard Edition - Version 12.2.0.1 to 12.2.0.1 [Release 12.2]
Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Information in this document applies to any platform.
Symptoms
Querying gv$instance keeps failing with ORA-12805 on 11.2 RAC database.
SQL> select * from gv$instance;
ERROR:
ORA-12805: parallel query server died unexpectedly
Also happens while using RMAN -
RMAN> backup database;
Starting backup at 06-NOV-14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=127 instance=<instance> device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00601: fatal error in recovery manager
RMAN-03004: fatal error during execution of command
RMAN-10039: error encountered while polling for RPC completion on channel ORA_DISK_1
RMAN-10006: error running SQL statement: select action from gv$session where sid=:1 and serial#=:2 and inst_id=:3
RMAN-10002: ORACLE error: ORA-12805: parallel query server died unexpectedly
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |