Querying gv$instance keeps failing with ORA-12805 in RAC
(Doc ID 2014298.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 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=rcdp_2 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!