ORA-00018 and ORA-00604

[KY.Chuang]

Deal all,
My system occur a error message( ORA-00018 and ORA_00604)
I find the reslove method as fllow:
"Action: Try the operation again in a few minutes. If this message occurs often, shut down Oracle, increase the SESSIONS parameter in the initialization parameter file, and restart Oracle "

Question is:
Should I to modify the init.ora that enlarge the process number from 50 to 200 ???
Thanks.K.Y.

[T G Manikandan]

//*

You need to increase the value of the SESSIONS parameter in the init.ora file.
-or-
Increase the value of PROCESSES since SESSIONS is derived off of the PROCESSES parameter.
SESSIONS = (1.1 * PROCESSES + 5)

*//

Then re-started the database to re-read the initSID.ora file to make changes take effect

[T G Manikandan]

K.Y,

There is another feature in this forums of assigning points to the answers.

Just check this

http://us-support.external.hp.com/estaff/bin/doc.pl/screen=estaffAssistance/distrib_redir=0+1045209670|*?Page=file0002

[KY.Chuang]

Help !!!
When I try to modify the init.ora which change the process number to 150..
Shutdown Oracle, and Try to
restart Oracle....
It fail....
Give me error message...
HP:28 No space left on device.
I check the filesystem Usage.
It is normal...Why???

Thanks. and Regards.

[T G Manikandan]

You have tried to increase the parameter processes in the initsid.ora file.

Then the problem is it is running out of semaphores.
You need to increase the value of SEMMNS in the kernel.
Normally,this value is configured for oracle instance as
processes * 2 => semmns value

calculate if you are running more oracle instances accordingly.

Set your Semmns value to the double the value of the processes value configured in the instance.

You can do this in SAM

SAM---->kernel configuration--->parameters

change SEMMNS

Re-build the new kernel and reboot the system.

That should solve this error.

Thanks