Re: Cannot kill a user connected to the database

On Mar 19, 1:12 pm, "yaru22" <yar..._at_gmail.com> 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.

Do you have an "intelligent agent" running? Can you shutdown abort?

jg

--
@home.com is bogus.
ZZZzzzzzz wha?  http://www.signonsandiego.com/uniontrib/20070320/news_lz1n20readthi.html