Re: DROP USER - cannot drop a user that is currently connected

Hi Mathias,

     Oracle bugs apart, if there are no user sessions connected you can drop the oracle user.
Your post refers to an opencms user. My guess is that you are using a cms product based on a java application server. It's very likely that this product is using a connection pool to connecto to the db, and it's also likely that the pool is "clever" and periodically checks for bad connection (i.e. dead ones) and if finds one it recreates it. Try to stop the application server (tomcat?) or the single web application and try to re-execute the drop command, it should work. Hope it helps,

    Giovanni

On 4/21/06, Mathias Diehl <md_at_evoconcept.de> wrote:
> Hi List,
>
> may I ask again for your support.
>
> I try to run automatic installer but fail with the message but can't drop the user:
>
>
> drop user OPENCMS cascade;
>
> -->"cannot drop a user that is currently connected"
>
> Now I googled and found:
>
> select username, sid, serial# from v$session where lower(username)='OPENCMS';
>
> What brought:
>
> USERNAME SID SERIAL#
> ------------------------------ ---------- ----------
> OPENCMS 143 148
> OPENCMS 144 623
> OPENCMS 145 19
> OPENCMS 147 378
> OPENCMS 148 609
> OPENCMS 158 764
>
>
>
>
> alter system kill session '143, 148';
>
> seem's to have no effect as the error persists.... any idea how to solve that issue?
>
> Thanx in advance
>
> Mat
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
--------------------------------------------------------------------
Another free oracle resource profiler
http://sourceforge.net/projects/oraresprof/
Now version 0.9
--
http://www.freelists.org/webpage/oracle-l