Mixing
ora-00020 maximum number of processes
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
[code] ora-02095: specified initialization parameter cannot be modified[/code]
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
oracle
edited Jul 20 '17 at 8:57
user272735
7,72164877
asked Jul 20 '17 at 5:29
ama989ama989
244317
add a comment |
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
[code] ora-02095: specified initialization parameter cannot be modified[/code]
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
oracle
edited Jul 20 '17 at 8:57
user272735
7,72164877
asked Jul 20 '17 at 5:29
ama989ama989
244317
scope = psfileis a typo. But did you make the typo here or when you ran it?
– APC
Jul 20 '17 at 10:32
add a comment |
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
[code] ora-02095: specified initialization parameter cannot be modified[/code]
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
oracle
edited Jul 20 '17 at 8:57
user272735
7,72164877
asked Jul 20 '17 at 5:29
ama989ama989
244317
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
[code] ora-02095: specified initialization parameter cannot be modified[/code]
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
oracle
oracle
edited Jul 20 '17 at 8:57
user272735
7,72164877
asked Jul 20 '17 at 5:29
ama989ama989
244317
edited Jul 20 '17 at 8:57
user272735
7,72164877
asked Jul 20 '17 at 5:29
ama989ama989
244317
edited Jul 20 '17 at 8:57
user272735
7,72164877
edited Jul 20 '17 at 8:57
user272735
7,72164877
edited Jul 20 '17 at 8:57
user272735
7,72164877
7,72164877
asked Jul 20 '17 at 5:29
ama989ama989
244317
asked Jul 20 '17 at 5:29
ama989ama989
244317
asked Jul 20 '17 at 5:29
ama989ama989
244317
244317
scope = psfileis a typo. But did you make the typo here or when you ran it?
– APC
Jul 20 '17 at 10:32
add a comment |
scope = psfileis a typo. But did you make the typo here or when you ran it?
– APC
Jul 20 '17 at 10:32
scope = psfile is a typo. But did you make the typo here or when you ran it?– APC
Jul 20 '17 at 10:32
scope = psfile is a typo. But did you make the typo here or when you ran it?– APC
Jul 20 '17 at 10:32
add a comment |
2 Answers
2
active
oldest
votes
The Solution :
Go to database files
go to ADMINdatabasepfileinit.ora
open it
change
processes = 59
to
processes = 200
then shutdown and start the database.
Problem Solved. Thanks for all.
answered Aug 20 '17 at 9:29
ama989ama989
244317
add a comment |
- Open cmd as Administrator
- C:UsersUsuario> sqlplus "/as sysdba"
- SQL> alter system set processes=500 scope=spfile;
- SQL> shutdownimmediate
- SQL> startup
- SQL> show parameter processes
answered Jan 2 at 17:04
Jose Boretto BlenginoJose Boretto Blengino
16115
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f45205893%2fora-00020-maximum-number-of-processes%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
The Solution :
Go to database files
go to ADMINdatabasepfileinit.ora
open it
change
processes = 59
to
processes = 200
then shutdown and start the database.
Problem Solved. Thanks for all.
answered Aug 20 '17 at 9:29
ama989ama989
244317
add a comment |
The Solution :
Go to database files
go to ADMINdatabasepfileinit.ora
open it
change
processes = 59
to
processes = 200
then shutdown and start the database.
Problem Solved. Thanks for all.
answered Aug 20 '17 at 9:29
ama989ama989
244317
add a comment |
The Solution :
Go to database files
go to ADMINdatabasepfileinit.ora
open it
change
processes = 59
to
processes = 200
then shutdown and start the database.
Problem Solved. Thanks for all.
answered Aug 20 '17 at 9:29
ama989ama989
244317
The Solution :
Go to database files
go to ADMINdatabasepfileinit.ora
open it
change
processes = 59
to
processes = 200
then shutdown and start the database.
Problem Solved. Thanks for all.
answered Aug 20 '17 at 9:29
ama989ama989
244317
answered Aug 20 '17 at 9:29
ama989ama989
244317
answered Aug 20 '17 at 9:29
ama989ama989
244317
answered Aug 20 '17 at 9:29
ama989ama989
244317
244317
add a comment |
add a comment |
- Open cmd as Administrator
- C:UsersUsuario> sqlplus "/as sysdba"
- SQL> alter system set processes=500 scope=spfile;
- SQL> shutdownimmediate
- SQL> startup
- SQL> show parameter processes
answered Jan 2 at 17:04
Jose Boretto BlenginoJose Boretto Blengino
16115
add a comment |
- Open cmd as Administrator
- C:UsersUsuario> sqlplus "/as sysdba"
- SQL> alter system set processes=500 scope=spfile;
- SQL> shutdownimmediate
- SQL> startup
- SQL> show parameter processes
answered Jan 2 at 17:04
Jose Boretto BlenginoJose Boretto Blengino
16115
add a comment |
- Open cmd as Administrator
- C:UsersUsuario> sqlplus "/as sysdba"
- SQL> alter system set processes=500 scope=spfile;
- SQL> shutdownimmediate
- SQL> startup
- SQL> show parameter processes
answered Jan 2 at 17:04
Jose Boretto BlenginoJose Boretto Blengino
16115
- Open cmd as Administrator
- C:UsersUsuario> sqlplus "/as sysdba"
- SQL> alter system set processes=500 scope=spfile;
- SQL> shutdownimmediate
- SQL> startup
- SQL> show parameter processes
answered Jan 2 at 17:04
Jose Boretto BlenginoJose Boretto Blengino
16115
answered Jan 2 at 17:04
Jose Boretto BlenginoJose Boretto Blengino
16115
answered Jan 2 at 17:04
Jose Boretto BlenginoJose Boretto Blengino
16115
answered Jan 2 at 17:04
Jose Boretto BlenginoJose Boretto Blengino
16115
16115
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f45205893%2fora-00020-maximum-number-of-processes%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
scope = psfileis a typo. But did you make the typo here or when you ran it?– APC
Jul 20 '17 at 10:32