Querying gv$instance keeps failing with ORA-12805 in RAC (Doc ID 2014298.1)

Last updated on OCTOBER 14, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 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=rcdp_2 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
[oracle@ehcprac01 ~]$

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms