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

  • From: rjamya <rjamya@xxxxxxxxx>
  • To: gundogar@xxxxxxxxx
  • Date: Fri, 16 Mar 2007 13:50:09 -0400

make sure you add "oradebug call ksmcpg" as per note *417879.1 if
applicable.

rjamya
*
On 3/16/07, A. Coskan Gundogar <gundogar@xxxxxxxxx> wrote:


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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 03-2007