Home » RDBMS Server » Server Administration » how to increase processes parameter? (oracle 10g)
how to increase processes parameter? [message #356980] Mon, 03 November 2008 07:06 Go to next message
grpatwari
Messages: 257
Registered: June 2008
Location: Hyderabad
Senior Member
Hi,

How to increase the processes parameter by using spfile or init.ora?

Please provide the steps.

Regards,
Gajanan
Re: how to increase processes parameter? [message #356990 is a reply to message #356980] Mon, 03 November 2008 07:41 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
alter system or vi.

Regards
Michel

[Updated on: Mon, 03 November 2008 07:41]

Report message to a moderator

Re: how to increase processes parameter? [message #356991 is a reply to message #356980] Mon, 03 November 2008 07:45 Go to previous messageGo to next message
grpatwari
Messages: 257
Registered: June 2008
Location: Hyderabad
Senior Member
Hi Micheal,

I followed below steps but i am not able to change.

show parameter processes;
create pfile from spfile;
shut immediate;
startup mount;
alter system set processes=500 scope=spfile;
create pfile from spfile;
alter database open;
shutdown immediate;
startup;
show parameter processes;


It is giving the error in alter system.

Please provide the clear steps.
Re: how to increase processes parameter? [message #356993 is a reply to message #356991] Mon, 03 November 2008 07:52 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Copy and paste your session, don't describe it.
Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter).
Use the "Preview Message" button to verify.

If you use spfile, you don't need to transit by pfile.

Regards
Michel
Re: how to increase processes parameter? [message #357100 is a reply to message #356980] Mon, 03 November 2008 23:05 Go to previous messageGo to next message
grpatwari
Messages: 257
Registered: June 2008
Location: Hyderabad
Senior Member
I am using ASM environment and I have init.ora file.I want to change process parameter from 350 to 900 and again 900 to 700.I am pasting the session.

[oracle@moose ~]$ export ORACLE_SID=BAM217J
[oracle@moose ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Nov 4 07:13:17 2008

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


Connected to:
Oracle Database 10g Release 10.2.0.1.0 - Production

SQL> show parameter spfile;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +BAMDATA1/bam_217j/spfilebam21
7j.ora
SQL> show parameter pfile;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +BAMDATA1/bam_217j/spfilebam21
7j.ora
SQL> show parameter processes

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 0
db_writer_processes integer 1
gcs_server_processes integer 0
job_queue_processes integer 10
log_archive_max_processes integer 2
processes integer 350
SQL>

please help me.

Re: how to increase processes parameter? [message #357103 is a reply to message #357100] Mon, 03 November 2008 23:20 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
alter system set processes=500 scope=spfile;
shutdown immediate;
startup;

Regards
Michel
Re: how to increase processes parameter? [message #357111 is a reply to message #356980] Tue, 04 November 2008 00:23 Go to previous messageGo to next message
grpatwari
Messages: 257
Registered: June 2008
Location: Hyderabad
Senior Member
I followed the steps but not modified.Please see the output from the screen.
[oracle@moose ~]$ export ORACLE_SID=BAM217J
[oracle@moose ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Nov 4 07:13:17 2008

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


Connected to:
Oracle Database 10g Release 10.2.0.1.0 - Production

SQL> show parameter spfile;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +BAMDATA1/bam_217j/spfilebam21
7j.ora
SQL> show parameter pfile;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +BAMDATA1/bam_217j/spfilebam21
7j.ora
SQL> show parameter processes

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 0
db_writer_processes integer 1
gcs_server_processes integer 0
job_queue_processes integer 10
log_archive_max_processes integer 2
processes integer 350
SQL> alter system set processes=500 scope=spfile;

System altered.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.

Total System Global Area 364904448 bytes
Fixed Size 1219448 bytes
Variable Size 109053064 bytes
Database Buffers 251658240 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.
SQL> show parameter processes

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 0
db_writer_processes integer 1
gcs_server_processes integer 0
job_queue_processes integer 10
log_archive_max_processes integer 2
processes integer 350
SQL> show parameter spfile;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string
SQL> show parameter pfile

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string
SQL>


Re: how to increase processes parameter? [message #357121 is a reply to message #357111] Tue, 04 November 2008 01:06 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You didn't restart with the spfile you modified.

Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter) and align the columns in result.
Use the "Preview Message" button to verify.

Regards
Michel
Re: how to increase processes parameter? [message #357132 is a reply to message #356980] Tue, 04 November 2008 02:17 Go to previous messageGo to next message
grpatwari
Messages: 257
Registered: June 2008
Location: Hyderabad
Senior Member
how to restart with spfile?
Re: how to increase processes parameter? [message #357139 is a reply to message #357132] Tue, 04 November 2008 02:38 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
How did you do it the first time?
Put "spfile=..." in your init.ora file or use "startup spfile=...".

Regards
Michel
Re: how to increase processes parameter? [message #357143 is a reply to message #356980] Tue, 04 November 2008 02:46 Go to previous messageGo to next message
grpatwari
Messages: 257
Registered: June 2008
Location: Hyderabad
Senior Member
First time I am creating the database with shell script.But now I want to create new script for changing parameter.I am following the steps while creating the database.
1) startup mount pfile="/opt/oracle/BAM/02120007/config/BAM217Linit.ora";
2) create spfile='+BAMDATA1/BAM_217H/spfileBAM217H.ora' FROM pfile='/opt/oracle/BAM/02120007/config/BAM217Hinit.ora';
3) shutting down the database and restarting.

How should I know the instance name if I want to change the parameter in ASM environment?
Re: how to increase processes parameter? [message #357149 is a reply to message #357143] Tue, 04 November 2008 02:58 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
How should I know the instance name if I want to change the parameter in ASM environment?

I don't understand the question.

Regards
Michel
Re: how to increase processes parameter? [message #357150 is a reply to message #356980] Tue, 04 November 2008 03:03 Go to previous messageGo to next message
grpatwari
Messages: 257
Registered: June 2008
Location: Hyderabad
Senior Member
If I run the below command,

SQL> startup spfile='+BAMDATA1/bam_217l/spfilebam217l.ora'
SP2-0714: invalid combination of STARTUP options

How should I know the spfile path?

Re: how to increase processes parameter? [message #357160 is a reply to message #357150] Tue, 04 November 2008 03:12 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't use ASM, try to put it in init.ora as I mentioned.

Regards
Michel
Re: how to increase processes parameter? [message #357164 is a reply to message #356980] Tue, 04 November 2008 03:20 Go to previous messageGo to next message
grpatwari
Messages: 257
Registered: June 2008
Location: Hyderabad
Senior Member
I am not getting, how to put in init.ora ?
Re: how to increase processes parameter? [message #357168 is a reply to message #357164] Tue, 04 November 2008 03:26 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use vi or any editor: "spfile=..."

Regards
Michel

[Updated on: Tue, 04 November 2008 03:26]

Report message to a moderator

Re: how to increase processes parameter? [message #357169 is a reply to message #356980] Tue, 04 November 2008 03:33 Go to previous message
grpatwari
Messages: 257
Registered: June 2008
Location: Hyderabad
Senior Member
Thank you for your help.
Previous Topic: instalation problem
Next Topic: Oracle Password
Goto Forum:
  


Current Time: Sat Dec 10 01:23:55 CST 2016

Total time taken to generate the page: 0.16622 seconds