PROCESSES EXCEEDED ON UAT SERVER

ERROR:

Error in database Alter log file and between conncation as “sys / as sysdba”

ERROR:

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

SOLUTION:

Stop Application First:

 [applmgr@uat-ebsap1 appl]$ pwd

/u1/oracle/UAT/apps/apps_st/appl

[applmgr@uat-ebsap1 appl]$ . ./APPSUAT_uat-ebsap1.env

[applmgr@uat-ebsap1 appl]$ cd $ADMIN_SCRIPTS_HOME

[applmgr@uat-ebsap1 scripts]$ ./adstpall.sh apps/apps

[applmgr@uat-ebsap1 scripts]$ ps -ef|grep FND|wc

     33     555   13479

[applmgr@uat-ebsap1 scripts]$ ps -ef|grep FND|wc

     30     531   12600

[applmgr@uat-ebsap1 scripts]$ ps -ef|grep FND|wc

      5      68    1109

[applmgr@uat-ebsap1 scripts]$ ps -ef|grep FND|wc

      1     7     59

Go to the Database server kill processes for create session with database as a “sys “user:

[oracle@uat-ebsdb1 11.2.0] $ps -ef |grep UAT_

oracle    4417     1 0 02:01 ?        00:00:01 oracleUAT (LOCAL=NO)

oracle    4421     1  0 02:01 ?        00:00:01 oracleUAT (LOCAL=NO)

oracle    4429     1  0 02:01 ?        00:00:00 oracleUAT (LOCAL=NO)

oracle    4431     1  0 02:01 ?        00:00:00 oracleUAT (LOCAL=NO)

oracle    4441     1  0 02:01 ?        00:00:01 oracleUAT (LOCAL=NO)

oracle    4443     1  0 02:01 ?        00:00:00 oracleUAT (LOCAL=NO)

oracle    4453     1  0 02:01 ?        00:00:00 oracleUAT (LOCAL=NO)

oracle    4455     1  0 02:01 ?        00:00:00 oracleUAT (LOCAL=NO)

oracle    4465     1  0 02:01 ?        00:00:00 oracleUAT (LOCAL=NO)

oracle    4477     1  0 02:01 ?        00:00:00 oracleUAT (LOCAL=NO)

oracle    4479     1  0 02:01 ?        00:00:00 oracleUAT (LOCAL=NO)

oracle    4489     1  0 02:01 ?        00:00:00 oracleUAT (LOCAL=NO)

oracle    4503     1  0 02:01 ?        00:00:00 oracleUAT (LOCAL=NO)

oracle    4515     1  0 02:01 ?        00:00:00 oracleUAT (LOCAL=NO)

oracle    4533     1  0 02:01 ?        00:00:01 oracleUAT (LOCAL=NO)

oracle    4554     1  0 02:02 ?        00:00:00 oracleUAT (LOCAL=NO)

oracle    4574     1  0 02:02 ?        00:00:00 oracleUAT (LOCAL=NO)

oracle    4582     1  0 02:02 ?        00:00:00 oracleUAT (LOCAL=NO)

oracle    4594     1  0 02:02 ?        00:00:00 oracleUAT (LOCAL=NO)

oracle   11733     1  0 08:49 ?        00:00:00 oracleUAT (LOCAL=NO)

oracle   11827     1  0 08:54 ?        00:00:00 oracleUAT (LOCAL=NO)

oracle   11840     1  0 08:55 ?        00:00:00 oracleUAT (LOCAL=NO)

[oracle@uat-ebsdb1 11.2.0]$ kill -9 4351 4361 4369 4371 4383 4385 4395 4397

[oracle@uat-ebsdb1 11.2.0]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Wed Dec 21 09:13:13 2016

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> show parameter spfile    -------------------- database not start with spfile

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

spfile                               string

SQL> create spfile from pfile;

File created.

SQL> shut immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount;

ORACLE instance started.

Total System Global Area 1068937216 bytes

Fixed Size                  2260088 bytes

Variable Size             436208520 bytes

Database Buffers          616562688 bytes

Redo Buffers               13905920 bytes

Database mounted.

SQL>  show parameter spfile

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

spfile                               string      /u1/oracle/UAT/db/tech_st/11.2.0/dbs/spfileUAT.ora

SQL> show parameter process

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

aq_tm_processes                      integer     1

cell_offload_processing              boolean     TRUE

db_writer_processes                  integer     1

gcs_server_processes                 integer     0

global_txn_processes                 integer     1

job_queue_processes                  integer     2

log_archive_max_processes            integer     4

processes                            integer     200

processor_group_name                 string

SQL> alter system set processes = 1000 scope=spfile;

System altered.

SQL> show parameter sessions;

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

java_max_sessionspace_size           integer     0

java_soft_sessionspace_limit         integer     0

license_max_sessions                 integer     0

license_sessions_warning             integer     0

sessions                             integer     402

shared_server_sessions               integer

SQL> alter system set sessions = 900 scope=spfile;

System altered.

SQL>  show parameter process

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

aq_tm_processes                      integer     1

cell_offload_processing              boolean     TRUE

db_writer_processes                  integer     1

gcs_server_processes                 integer     0

global_txn_processes                 integer     1

job_queue_processes                  integer     2

log_archive_max_processes            integer     4

processes                            integer     200

processor_group_name                 string

SQL>

SQL> show parameter sessions;

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

java_max_sessionspace_size           integer     0

java_soft_sessionspace_limit         integer     0

license_max_sessions                 integer     0

license_sessions_warning             integer     0

sessions                             integer     402

shared_server_sessions               integer

SQL>

SQL> shut immediate;

ORA-01109: database not open

Database dismounted.

startuORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area 1068937216 bytes

Fixed Size                  2260088 bytes

Variable Size             436208520 bytes

Database Buffers          616562688 bytes

Redo Buffers               13905920 bytes

Database mounted.

Database opened.

SQL> show parameter sessions;

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

java_max_sessionspace_size           integer     0

java_soft_sessionspace_limit         integer     0

license_max_sessions                 integer     0

license_sessions_warning             integer     0

sessions                             integer     1524

shared_server_sessions               integer

SQL> show parameter process

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

aq_tm_processes                      integer     1

cell_offload_processing              boolean     TRUE

db_writer_processes                  integer     1

gcs_server_processes                 integer     0

global_txn_processes                 integer     1

job_queue_processes                  integer     2

log_archive_max_processes            integer     4

processes                            integer     1000

processor_group_name                 string

SQL>

Start Application:

 [applmgr@uat-ebsap1 appl]$ pwd

/u1/oracle/UAT/apps/apps_st/appl

[applmgr@uat-ebsap1 appl]$ . ./APPSUAT_uat-ebsap1.env

[applmgr@uat-ebsap1 appl]$ cd $ADMIN_SCRIPTS_HOME

 [applmgr@uat-ebsap1 scripts]$ ./adstrtal.sh apps/apps

[applmgr@uat-ebsap1 scripts]$ ps -ef|grep FND|wc

      2      17     255

[applmgr@uat-ebsap1 scripts]$ ps -ef|grep FND|wc

      5      68    1109

[applmgr@uat-ebsap1 scripts]$ ps -ef|grep FND|wc

     30     531   12600

[applmgr@uat-ebsap1 scripts]$ ps -ef|grep FND|wc

     33     555   13479

[applmgr@uat-ebsap1 scripts]$ ps -ef|grep FND|wc

     33     555   13479