Tuesday, September 25, 2018

ORA-00020: maximum number of processes (200) exceeded

Unable to generate forwarding URL. Exception: oracle.apps.fnd.common.AppsException: oracle.apps.fnd.common.PoolException: Exception creating new Poolable object.
 
ORA-00020: maximum number of processes (200) exceeded
 
 
Login with sqlplus -prelim "/as sysdba" shut down the database with abort option & increase the process parameter.
kill the db side LOCAL=NO
 
ps -ef|grep oraascp
oraascp 28756 1 0 10:28 ? 00:00:00 oracleASR (LOCAL=NO)
oraascp 28758 1 0 10:28 ? 00:00:00 oracleASR (LOCAL=NO)
oraascp 28816 1 0 10:28 ? 00:00:00 oracleASR (LOCAL=NO)
oraascp 28818 1 0 10:28 ? 00:00:00 oracleASR (LOCAL=NO)
oraascp 28820 1 0 10:28 ? 00:00:00 oracleASR (LOCAL=NO)
oraascp 28822 1 0 10:28 ? 00:00:00 oracleASR (LOCAL=NO)
oraascp 28824 1 0 10:28 ? 00:00:00 oracleASR (LOCAL=NO)
 
 
Login and
set the
 
alter system set processes=400 scope=spfile;
 
 
>create pfile from spfile;
>shut immediate
>cd $ORACLE_HOME/dbs
vi initASR.ora
 
PGA_AGGREGATE_MEM:2GB
SGA_AGGREGATE_MEM:2GB
 
Processess:400
session:2X400
 
SQL> startup pfile='/uatdb/app/oraascp/db/11.2.0/dbs/initASR.ora';
ORACLE instance started.
 
Total System Global Area 2137886720 bytes
Fixed Size 2254952 bytes
Variable Size 503318424 bytes
Database Buffers 1610612736 bytes
Redo Buffers 21700608 bytes
Database mounted.
Database opened.
 
 
 
 

No comments:

Post a Comment

[ERROR]: The value of s_patch_service_name is not set correctly in atleast one of the context files.

[ERROR]: The value of s_patch_service_name is not set correctly in atleast one of the context files. I got the issue below wh...