In Oracle 12.2, ORA-04030:QERGH hash-agg,kllcqas:kllsltba, then we need do the following

[oracle@local03 run]$ grep CRS_LIMIT_OPENFILE /u01/app/12.2.0.1/grid/crs/install/s_crsconfig_local03_env.txt
Old value CRS_LIMIT_OPENFILE=65536

We need to change the value and restart the CRS

New value CRS_LIMIT_OPENFILE=400000

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.