Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Cannot kill a user connected to the database

Cannot kill a user connected to the database

From: yaru22 <yaru22_at_gmail.com>
Date: 19 Mar 2007 13:12:01 -0700
Message-ID: <1174335121.157471.18720@y66g2000hsf.googlegroups.com>


Hi,

I have to kill this user on my database but it cannot be killed.

When I check v$session, there's the user.

However, when I try to kill the user by

alter system kill session 'sid,serial#' immediate

It says ORA-00030: User session ID does not exist.

How should I do in this case?

I couldn't even shutdown the database.

Whenever I try to shutdown the database, it just hangs.

Thank you. Received on Mon Mar 19 2007 - 15:12:01 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US