Articles Tagged: ORA-04030

ORA-04030:QERGH hash-agg,kllcqas:kllsltba

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

Read More →