Re: too many session open and you can't log in?

What about using os debugger to connect to an existing process, dump hanganalyze (or systemstate and then run ass.awk on it) to see the root cause and start killing from that point onwards rather than shooting the whole system down? In wither case a systemstate would be useful for a post-martem.

I also noticed that in 10203 (and perhaps in 10202), the scheduler uses internal_quiesce resource plan, activated it at 10pm and then you see lot of sessions (which appear hung) waiting on 'resmgr:become active' wait event. In this case, the solution is a simple alter system to set the resource manager plan to a null value.

Since Ryan didn't mention version, I don't know if it is his problem.

Another situation I have seen when things do get hung is when a logon trigger goes invalid and before it is validated by a dba, incoming sessions do try to compile it and since (usually) they don't have privs to compile logon triggers, everything seems to hang. Personally I have experienced this in 9204.

rjamya

On 3/15/07, Dennis Williams <oracledba.williams_at_gmail.com> wrote:
>
> Ryan,
>
> You might try logging in with sqlplus '/ as sysdba'.
> I agree with the advice to use kill -9.
> If you do get in with sqlplus you're probably going to do a shutdown
> abort.
>
>

--
http://www.freelists.org/webpage/oracle-l