Solution for ora-00020 maximum number of processes [message #664474] |
Thu, 20 July 2017 00:24 |
|
amjad_alahdal
Messages: 102 Registered: October 2013 Location: Saudi Arabia
|
Senior Member |
|
|
Hello guys,
Recently, I have been facing this error
ora-00020 maximum number of processes
I have read articles that says that I have to increase the number of processes, sessions, and the transactions.
I tried. and Simply I have done the followings:
I logged in as SYSDBA to the database.
I tried to use the following command:
alter system set processes = 500 scope = psfile
to increase the sessions and the transactions I need to follow the equations below :
sessions = (1.1*processes) + 5
transactions = (1.1*sessions)
well, I am not sure if it's correct or not.
so, I tried to increase the processes first by the command above.
I got another error
ora-02095: specified initialization parameter cannot be modified
After reading about ora-02095. I found that I have to check the scope if it's spfile or pfile.
SELECT DECODE(value, NULL, 'PFILE', 'SPFILE') "Init File Type"
FROM sys.v_$parameter WHERE name = 'spfile';
no rows selected
can you please help me.
|
|
|
|
|
|
|
|
Re: Solution for ora-00020 maximum number of processes [message #664492 is a reply to message #664491] |
Thu, 20 July 2017 02:02 |
|
amjad_alahdal
Messages: 102 Registered: October 2013 Location: Saudi Arabia
|
Senior Member |
|
|
Mr. Michel Cadot. I understand that I didn't complete my topics " the one you mentioned" Because, It's has been 2 years. How can I remember what I have done or What I have done or Does really that help or not. I understand that You want me to close the cases. So, I told them that I have fixed the problems. Anyways, From now on, The topics will be closed the way it should.
So, Mr.Michel Cadot, if you know the solution of my problems, it would be generous of you to help me.
[Updated on: Thu, 20 July 2017 02:06] Report message to a moderator
|
|
|
|
|
|
|
|
|
|
|
|
|
Re: Solution for ora-00020 maximum number of processes [message #665048 is a reply to message #664474] |
Sun, 20 August 2017 02:23 |
|
amjad_alahdal
Messages: 102 Registered: October 2013 Location: Saudi Arabia
|
Senior Member |
|
|
The Solution :
Go to database files
go to ADMIN\database\pfile\init.ora
open it
change
processes = 59
to
processes = 200
then shutdown and start the database.
Problem Solved. Thanks for all.
====================================================================
"Mr. Michel Cadot" Is this good enough?
NOTES: Even though I posted this on 20th of july. I fixed it today
[Updated on: Sun, 20 August 2017 02:31] Report message to a moderator
|
|
|