Home » SQL & PL/SQL » SQL & PL/SQL » Solution for ora-00020 maximum number of processes (oracle database 8i )
Solution for ora-00020 maximum number of processes [message #664474] Thu, 20 July 2017 00:24 Go to next message
amjad_alahdal
Messages: 92
Registered: October 2013
Location: Saudi Arabia
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 #664476 is a reply to message #664474] Thu, 20 July 2017 01:21 Go to previous messageGo to next message
Michel Cadot
Messages: 65255
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
I tried to use the following command:
Which is invalid and so can't return what you said.

Quote:
I need to follow the equations below :
No you don't need it.

Quote:
I tried to increase the processes first by the command above.
I got another error
Not possible, the syntax of the "above command" is invalid.

Quote:
can you please help me.
You still did not feedback in your previous topics but the last 2 ones (and just because I asked you to do so).
Is Littlefoot's solution the good one in http://www.orafaq.com/forum/m/644173/#msg_644173?
And in http://www.orafaq.com/forum/m/642014/#msg_642014?
And cookiemonster's one in http://www.orafaq.com/forum/m/641218/#msg_641218?
And in the previous topics?
If you don't want to help others with your questions and solutions, why should we help you?

Re: Solution for ora-00020 maximum number of processes [message #664477 is a reply to message #664476] Thu, 20 July 2017 01:37 Go to previous messageGo to next message
amjad_alahdal
Messages: 92
Registered: October 2013
Location: Saudi Arabia
Member
If the command is invalid. Do you Know how to increase the maximum number of processes ?
You can delete the other topics if they bother you
Re: Solution for ora-00020 maximum number of processes [message #664478 is a reply to message #664477] Thu, 20 July 2017 01:40 Go to previous messageGo to next message
Michel Cadot
Messages: 65255
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
If the command is invalid. Do you Know how to increase the maximum number of processes ?
Yes I know it.

Quote:
You can delete the other topics if they bother you
No but I can delete this one. Wink
So stop to refuse to help others and follow the rules and feedback in your previous topics (all of them not just the 3 I mentioned).

Re: Solution for ora-00020 maximum number of processes [message #664479 is a reply to message #664478] Thu, 20 July 2017 01:47 Go to previous messageGo to next message
amjad_alahdal
Messages: 92
Registered: October 2013
Location: Saudi Arabia
Member
I will. But, you could've send me a private message. You are blackmailing me .

[Updated on: Thu, 20 July 2017 01:52]

Report message to a moderator

Re: Solution for ora-00020 maximum number of processes [message #664491 is a reply to message #664479] Thu, 20 July 2017 01:56 Go to previous messageGo to next message
Michel Cadot
Messages: 65255
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

I already did, at least 2 or 3 times, and this is the reason you fed-back in your 2 previous topics.
And a feedback s not just "Thank You. Problem solved." you copied and pasted in all your topics, it is how you exactly solved it, what option worked.

Re: Solution for ora-00020 maximum number of processes [message #664492 is a reply to message #664491] Thu, 20 July 2017 02:02 Go to previous messageGo to next message
amjad_alahdal
Messages: 92
Registered: October 2013
Location: Saudi Arabia
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 #664500 is a reply to message #664492] Thu, 20 July 2017 05:53 Go to previous messageGo to next message
Flyby
Messages: 181
Registered: March 2011
Location: Belgium
Senior Member
if you are using a pfile, you can edit processes there
if you are using a spfile, you might want to check
In the intial post you mentioned scope = psfile instead of scope = spfile
Re: Solution for ora-00020 maximum number of processes [message #664501 is a reply to message #664500] Thu, 20 July 2017 05:55 Go to previous messageGo to next message
amjad_alahdal
Messages: 92
Registered: October 2013
Location: Saudi Arabia
Member
Sorry, I made this mistake when I wrote the post. I tried spfile. It didn't work. I also get ora-02095

[Updated on: Thu, 20 July 2017 05:56]

Report message to a moderator

Re: Solution for ora-00020 maximum number of processes [message #664502 is a reply to message #664501] Thu, 20 July 2017 05:58 Go to previous messageGo to next message
ThomasG
Messages: 3205
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Of course spfile was only introduced in 9i, and you state you are on 8i. So you will have to edit the pfile itself and restart the instance.
Re: Solution for ora-00020 maximum number of processes [message #664503 is a reply to message #664501] Thu, 20 July 2017 06:01 Go to previous messageGo to next message
Michel Cadot
Messages: 65255
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

This is why we asked you several times to COPY AND PASTE what you do and get, the rest is pointless.
At the moment we read something wrong in your post then it is clear we can't believe anything you post.

Quote:
It didn't work.
This is also completely useless.

Re: Solution for ora-00020 maximum number of processes [message #664504 is a reply to message #664503] Thu, 20 July 2017 06:05 Go to previous messageGo to next message
amjad_alahdal
Messages: 92
Registered: October 2013
Location: Saudi Arabia
Member
Okay, Next time, I will make sure to post the correct command. Thank You for your comment.
Re: Solution for ora-00020 maximum number of processes [message #664508 is a reply to message #664474] Thu, 20 July 2017 07:24 Go to previous messageGo to next message
EdStevens
Messages: 863
Registered: September 2013
Senior Member
Same question posted on OTN Forums.
Re: Solution for ora-00020 maximum number of processes [message #664528 is a reply to message #664474] Thu, 20 July 2017 17:18 Go to previous messageGo to next message
scottyyu
Messages: 7
Registered: July 2017
Junior Member
alter system set processes = 500 scope = spfile, then bounce instance.

scott
Re: Solution for ora-00020 maximum number of processes [message #664529 is a reply to message #664528] Thu, 20 July 2017 17:48 Go to previous messageGo to next message
BlackSwan
Messages: 25751
Registered: January 2009
Location: SoCal
Senior Member
scottyyu wrote on Thu, 20 July 2017 15:18
alter system set processes = 500 scope = spfile, then bounce instance.

scott
above will simply throw error when run on OP's V8 database.
Re: Solution for ora-00020 maximum number of processes [message #664549 is a reply to message #664529] Fri, 21 July 2017 15:25 Go to previous messageGo to next message
scottyyu
Messages: 7
Registered: July 2017
Junior Member
I did not realize there is still it is 8i, until I went back for previous post.


scott
Re: Solution for ora-00020 maximum number of processes [message #664550 is a reply to message #664549] Fri, 21 July 2017 15:36 Go to previous messageGo to next message
BlackSwan
Messages: 25751
Registered: January 2009
Location: SoCal
Senior Member
scottyyu wrote on Fri, 21 July 2017 13:25
I did not realize there is still it is 8i, until I went back for previous post.


scott
it is Best Practice to actually read Whole Thread from Top down to bottom before responding

You never get a second chance to make a first impression.
Re: Solution for ora-00020 maximum number of processes [message #665048 is a reply to message #664474] Sun, 20 August 2017 02:23 Go to previous message
amjad_alahdal
Messages: 92
Registered: October 2013
Location: Saudi Arabia
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

Previous Topic: function
Next Topic: Join and group by on multiple tables
Goto Forum:
  


Current Time: Sat Dec 16 00:33:24 CST 2017

Total time taken to generate the page: 0.02791 seconds