Re: Cannot kill a user connected to the database

yaru22 wrote:
> 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.

What version?

What is the result of the following query? SELECT osuser, schemaname, state, status FROM gv$session;

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org