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

Hi Alessandro,

thanx for the idea - but a) I'm still testing so I don't have access to the metalink and b) I'm using redhat for the database and debian/java for the client.

any other idea (Or at least: what doen metalink 100859.1 suggest?)

cheers,

Mat

-----Original Message-----
Sent: Freitag 21.04.06 10:03:48
Subject: Re:DROP USER - cannot drop a user that is currently conne...

>If your system is Windows NT/2K try to follow Metalink doc 100859.1; I had the same issue on a Win2K system and I solved it in that way.
>
>Good work,
>
>Alessandro
>
>> 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
>>
>>
>>
>

--
http://www.freelists.org/webpage/oracle-l