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 later
Oracle Database Backup Service - Version N/A and later
Oracle Database - Standard Edition - Version 18.104.22.168 to 22.214.171.124 [Release 12.2]
Oracle Database - Enterprise Edition - Version 126.96.36.199 and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Information in this document applies to any platform.
Querying gv$instance keeps failing with ORA-12805 on 11.2 RAC database.
SQL> select * from gv$instance;
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-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
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
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