Too many arguments passed in(2023). Limit is 2000 in Apex

Error:

Too many arguments passed in(2023). Limit is 2000


Solution:

Add the marked line in plsql.conf file and then restart ohs service

[root@IOFFSHORE ohs1]# vim /u01/oracle/middleware/asinst_1/config/OHS/ohs1/moduleconf/plsql.conf

PlsqlLogEnable On

PlsqlLogDirectory "${ORACLE_INSTANCE}/diagnostics/logs/${COMPONENT_TYPE}/${COMPONENT_NAME}"

# PlsqlIdleSessionCleanupInterval 15 (default)

# PlsqlDMSEnable On (default)
PlsqlMaxParameters 4000

# ============================================================================
# Database Access Descriptors Settings Section
# ============================================================================
include "${ORACLE_INSTANCE}/config/${COMPONENT_TYPE}/${COMPONENT_NAME}/mod_plsql/dads.conf"


-------Now restart the ohs1 component-----

[root@IOFFSHORE ohs1]# cd /u01/oracle/middleware/asinst_1/bin/
[root@IOFFSHORE bin]# ./opmnctl stopall
opmnctl stopall: stopping opmn and all managed processes...
[root@IOFFSHORE bin]# ./opmnctl startall
opmnctl startall: starting opmn and all managed processes...
================================================================================
opmn id=IOFFSHORE:6701
Response: 2 of 3 processes started.

ias-instance id=asinst_1
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
ias-component/process-type/process-set:
  emagent_asinst_1/EMAGENT/EMAGENT/

Error
--> Process (index=1,uid=2072455298,pid=91782)
  failed to start a managed process after the maximum retry limit
  Log:
  /u01/oracle/middleware/asinst_1/diagnostics/logs/EMAGENT/emagent_asinst_1/console~EMAGENT~1.log

[root@IOFFSHORE bin]# ./opmnctl status

Processes in Instance: asinst_1
---------------------------------+--------------------+---------+---------
ias-component                    | process-type       |     pid | status
---------------------------------+--------------------+---------+---------
emagent_asinst_1                 | EMAGENT            |     N/A | Down
RptSvr_IOFFSHORE_asinst_1        | ReportsServerComp~ |   91568 | Alive
forms                            | FormsRuntime       |   91406 | Alive
forms                            | FormsRuntime       |   91225 | Alive
forms                            | FormsRuntime       |   84824 | Alive
ohs1                             | OHS                |   91566 | Alive

[root@IOFFSHORE bin]#