Hi,
I got this error. How do I get out of this. I am not able to get a new connection, so I cannot increase the processes in init.
Pl. advice me.
Thanks
Sathidevi
Printable View
Hi,
I got this error. How do I get out of this. I am not able to get a new connection, so I cannot increase the processes in init.
Pl. advice me.
Thanks
Sathidevi
a) learnt to post in the right forum
b) what version? you dont need a connection to update the init.ora file
c) stop other connections if you want to get a connect
To Increase the number of process
Step-1
Create pfile= /oracle/.... from spfile
Step 2
Shutdown database
Step-3
Amend that pfile and increase the number of processes
Step -4
startup the database with new pfile
startup pfile='/oracle/....'
Step-5
Create spfile from pfile='/otacle/....'
So that when you startup database next time it will read spfile (new)
Best of luck.
Regards
what is wrong with alter system scope=spfile?
why create a pfile???
there is no need, Mr Mahsnj doesnt appear to know fully what to do here
Beacuse you can not change parameter called process by alter system
I have clearly mentioned these steps are to increase the number of process in init.ora file.Quote:
Originally Posted by davey23uk
To get rid of connections I think she will have to kill connections so that application can make new connections.and this also calls for Increase of number of process in init.ora file
ANY suggestion DAVEY23UK SIR
Don't be silly, of course you can change it directly in spfile!Quote:
Originally Posted by mahsnj
Code:Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> alter system set processes=150 scope=spfile;
System altered.
SQL>
Your are right I was missing scope=SpfileQuote:
Originally Posted by jmodic
SQL> alter system set processes=150;
alter system set processes=150
*
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified
Thanks