This content has been marked as final. Show 7 replies
1) did you check the (solaris) OS kernel parameters - are they the same on your two servers?
- Check Metalink for how to set these values for larger numbers of users/processes
(sorry, I have no access at the moment)
2) do you really need 10.000 processes (ten thousand it says in your detail, only 1000 in the post title). That's a lot of sessions!! How many sessions are you really expecting? You can try increasing the parameter
500, 1.000, 2.000, 5.000, 10.000 and see what happens.
I have exactly the same problem. I've changed PROCESS parameter to 3000 and Oracle does not start anymore.
My database is on Windows Server 2003 and Oracle 10.2.0
How can I change the parameter back to the previous value if Oracle is not started? I've tried thru ALTER SYSTEM command but got a ora01034...
I'm no DBA and have no clue on how to do this.
open the initSID.ora file from
$ORACLE_HOME/database (on windows)
$ORACLE_HOME/dbs (on unix)
and change the parameter
processes=100 (your required value)
then try to start the instance.
no such parameter on this file.
any other suggestions?
If there is no such parameter in initSID.ora, then you are using spfile. Do the following:
sqlplus "/as sysdba"
create pfile from spfile; -- without starting the instance
edit the pfile to change the processes parameter, delete spfile
create spfile from pfile
Now I'm getting a ORA-03113...
This error shows that your session with oracle database has been ended.
If database is still running then you can simply reconnect and continue.
ORA-3113 could be signaled for any of these scenarios:
- Server machine crashed
- Your server process was killed at O/S level
- Network problems
- Oracle internal errors / aborts on the server
- Client incorrectly handling multiple connections
- etc.. etc.. etc.. - a lot of possible causes !!
check if your database is running or not on unix enter this command
ps -ef|grep smon
if it show you smon_YOURDBSID then you db is running.