HELP:shutdown startup/too many processes

[hemanr]

Hi gurus,
I first get a too many processes message when I try to connect.

I raised the processes parameter...

Then,
SVRMGR> shutdown immediate
ORA-01034: ORACLE not available
SVRMGR> startup
ORA-01081: cannot start already-running ORACLE - shut it down first

What do I do?

This is urgent..my db is down!

[grjohnson]

If you are running o unix. Try running

/usr/proc/bin/ptree

and it may return ALOT of processes such as the following...

26694 oracleCFA (DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))

In startup, init.ora, you scecifiy how many process Oracle may keep running at anyone time. In your case, when you try and log in, Oracle senses you trying to exceed this and returns the error you are seeing.

You are going to have to manually kill at least one process, before you can log in.

The big question is WHY is it occuring. I have this issue currently, we are running a Websphere front end, and webphere keeps the Oracle processes alive if somebody drops out of Websphere, which is a real pain in the butt, because it means websphere has to be manually stopped and restarted periodically in order to release the Oracle processess. You may be having a similer issue.

Hope this helps.

Cheers,

[hemanr]

Thanks John,
You gave me exactly what I needed!

Cheers!

[sambavan]

When you, issue the shutdown immediate and still if you see oracle not available, then it would be the time to just abort the oracle instace through shutdown abort...

SVRMGR> shutdown immediate
ORA-01034: ORACLE not available
SVRMGR> shutdown abort
SVRMGR> startup mount
SVRMGR> recover database
SVRMGR> alter database open;


This would be the way to go...

Sam

[Kishore]

You can try one more thing.

In this situation.

STARTUP FORCE

Will start the database ignoring the earlier errors.

Kishore

[sambavan]

This is quiet unsafe!!

Sam

[julian]

It is quite a risky game to startup force :-) If you then get the 1019 error, you'll need to manually remove the old SGA.

[pando]

I think it´s ok if you do

alter system checkpoint
startup force
shutdown immediate
startup

[sambavan]

I once played the game of startup force and got into trouble... Its not worth the trouble that you have to go through to get it back if it goes wrong!!!

This is my personal opinion. I would take a long shot and save time....

Sam

[grjohnson]

Ahhh guys.... it was the number of processes running on the server. It wouldn't mater what shutdown method you used, if the number of processes have maxed out, you wouldn't be able to connect to do any on that until you kill one of the Dedicated Oracle processes in the background..

Cheers,