Re:Re:DROP USER - cannot drop a user that is currently conn.
- From: "Mathias Diehl" <md@xxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 21 Apr 2006 10:08:24 +0100
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
>> --
>> //www.freelists.org/webpage/oracle-l
>>
>>
>>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » Re:Re:DROP USER - cannot drop a user that is currently conn.
