Thanks for the question, Arun.
Asked: May 15, 2016 - 8:26 pm UTC
Last updated: May 16, 2016 - 2:45 am UTC
Version: 11G R2
Viewed 1000+ times
You Asked
I have configured weblogic appserver to use the database. It create lot of connection requests to my listener. My Listener reaches the max limit for processes and session and goes to blocked state.
Can we increase the listener max processes and session size?
I did this by using the two command below,
alter system set processes=150 scope=spfile;
alter system set sessions=555 scope=spfile;
shutdown immediate;
startup;
But I ended up in big mess..... My database would not start now and says the below error if I issue startup,
SQL> startup;
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
And where is the spfile and cpfile located?? how to modify it manually when db is down.
and Connor said...
That is most likely unrelated to your changes. If your path or evironment is not set correctly, you can get this, because in effect you are trying to start a database (for example) under the wrong user, or wrong software path etc. Double check all of that.
And dont forget...sessions/processes must include the background processes that Oracle has to run the databases. 150 seems very low - you might need a fair bit more than that
Is this answer out of date? If it is, please let us know via a Comment