| Asset ID: |
1-72-2056750.1 |
| Update Date: | 2017-07-18 |
| Keywords: | |
Solution Type
Problem Resolution Sure
Solution
2056750.1
:
Oracle Communications PIC Unable to Connect to DWS ORA-00020: Maximum Number Of Processes (500) Exceeded
| Related Items |
- Oracle Communications Performance Intelligence Center (PIC) Software
|
| Related Categories |
- PLA-Support>Sun Systems>CommsGBU>Global Signaling Solutions>SN-SND: Tekelec PIC
|
In this Document
Created from <SR 3-11387357574>
Applies to:
Oracle Communications Performance Intelligence Center (PIC) Software - Version 10.1.0 and later
Information in this document applies to any platform.
Symptoms
Oracle database connection failed to DWS because maximum number of Oracle processes has been reached. THis issue will prevent the end user from querying data with NSP application and will also impact the IxpStore processes if they are trying to reconnect.
Cause
There is a high number of IxpStore processes running on the subsytem, each of them generates 2 connections on the first DWS they connect. If we add the connections related to internal Oracle processing plus the queries from NSP, it can easily reach the 500 max processes.
Solution
It is recommended to see the DWS to maintenance mode in CCM before applying the workaround.
To permanently fix the issue the following workaround can be used:
- Log as oracle user on the DWS
- Connect via sqlplus: sqlplus / as sysdba
- Execute the following sql commands:
alter system set processes=2400 scope=spfile;
- Stop the database:
shutdown immediate
- Start the database:
startup
- Set the DWS to active mode in CCM. This procedure must be applied on all DWS of the pool.
References
<BUG:21848153> - IXPSTORE ARE OPENING 2 ORACLE CONNECTIONS ON THE FIRST DWS THEY CONNECT TO
<NOTE:1682295.1> - How to calculate the proper value from processes, sessions, and transactions
Attachments
This solution has no attachment
