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.
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