Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle 12.2 ORA-12805: parallel query server died unexpectedly

mAsHERJun 5 2018 — edited Oct 2 2018

I have a problem with running gv$ queries on instances. Any query with gv$ will trigger an error message ORA-12805: parallel query server died unexpectedly

Example:

SQL> select * from gv$instance;

ERROR:

ORA-12805: parallel query server died unexpectedly 

Instance:

Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production 

PL/SQL Release 12.2.0.1.0 - Production

CORE    12.2.0.1.0    Production    0

TNS for Linux: Version 12.2.0.1.0 - Production

NLSRTL Version 12.2.0.1.0 - Production

I have also another instance (the same version) where the problem does not exist. I need help.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 30 2018
Added on Jun 5 2018
#performance-availability, #rac-asm-clusterware-installation
5 comments
16,602 views