OraFAQ Forum: Server Administration » how to increase processes parameter?

Home » RDBMS Server » Server Administration » how to increase processes parameter? (oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to increase processes parameter? [message #356980]

Mon, 03 November 2008 07:06

grpatwari
Messages: 288
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

Report message to a moderator

Re: how to increase processes parameter? [message #356990 is a reply to message #356980]

Mon, 03 November 2008 07:41

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

grpatwari
Messages: 288
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.

Report message to a moderator

Re: how to increase processes parameter? [message #356993 is a reply to message #356991]

Mon, 03 November 2008 07:52

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: how to increase processes parameter? [message #357100 is a reply to message #356980]

Mon, 03 November 2008 23:05

grpatwari
Messages: 288
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.

Report message to a moderator

Re: how to increase processes parameter? [message #357103 is a reply to message #357100]

Mon, 03 November 2008 23:20

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

alter system set processes=500 scope=spfile;
shutdown immediate;
startup;

Regards
Michel

Report message to a moderator

Re: how to increase processes parameter? [message #357111 is a reply to message #356980]

Tue, 04 November 2008 00:23

grpatwari
Messages: 288
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>

Report message to a moderator

Re: how to increase processes parameter? [message #357121 is a reply to message #357111]

Tue, 04 November 2008 01:06

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: how to increase processes parameter? [message #357132 is a reply to message #356980]

Tue, 04 November 2008 02:17

grpatwari
Messages: 288
Registered: June 2008
Location: Hyderabad

Senior Member

how to restart with spfile?

Report message to a moderator

Re: how to increase processes parameter? [message #357139 is a reply to message #357132]

Tue, 04 November 2008 02:38

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: how to increase processes parameter? [message #357143 is a reply to message #356980]

Tue, 04 November 2008 02:46

grpatwari
Messages: 288
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?

Report message to a moderator

Re: how to increase processes parameter? [message #357149 is a reply to message #357143]

Tue, 04 November 2008 02:58

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: how to increase processes parameter? [message #357150 is a reply to message #356980]

Tue, 04 November 2008 03:03

grpatwari
Messages: 288
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?

Report message to a moderator