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

If you are on 10G and you cant log in with "sqlplus / as sysdba" you can try the -prelim option
it is a 'lightweight' session, you cant execute a sql command but take a system state dump

sqlplus -prelim / as sysdba
oradebug setmypid
oradebug unlimit;
oradebug dump systemstate 10

for more info

http://el-caro.blogspot.com/search/label/systemstate%20dump http://www.dbasupport.com/oracle/ora10g/crisis.shtml

On 3/16/07, ryan_gaffuri_at_comcast.net <ryan_gaffuri_at_comcast.net> wrote:
>
> it worked, but the problem existed. I could have sworn that i read if you
> kill -9 oracle processes it does not really kill them in the database.
>
> also after I did that I ran a top and the oracle background processes were
> still sucking up alot of memory.
>
>
> -------------- Original message --------------
> From: "Michael McMullen" <ganstadba_at_hotmail.com>
>
> > And it didn't work? I'm assuming you were logged in as oracle.
> > ----- Original Message -----
> > From: ryan_gaffuri_at_comcast.net
> > To: ganstadba_at_hotmail.com ; oracle-l_at_freelists.org
> > Cc: Michael McMullen
> > Sent: Thursday, March 15, 2007 10:57 AM
> > Subject: Re: too many session open and you can't log in?
> >
> >
> > I used kill -9 on every oracle session that was not a background
> process.
> >
> > -------------- Original message --------------
> >
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
>
>

-- 
A. Coskan GUNDOGAR

Oracle DBA

http://coskan.wordpress.com

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