Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re:Re: DROP USER - cannot drop a user that is currently con.
Hi List,
I found the problem - a buggy installation wizard :-(
During pre-install checks the wizard checked for existing tables - As the wizad found one the problem was a remaining connection of user OPENCMS.
So I run the wizard up to the check, looked for active sessions and killed them. After that I could proceed installing my CMS...
thanx too all
Mat
-----Original Message-----
Sent: Freitag 21.04.06 11:08:18
Subject: Re: DROP USER - cannot drop a user that is currently conn...
>Lock the account before killing it so that it can't reconnect. Also if
>session is in the middle of long transaction it might take a while to
>roll it back so wait a bit.
>
>2006/4/21, Mathias Diehl <md_at_evoconcept.de>:
>> 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
>>
>>
>>
>
>
>--
>Best regards,
>Alex Gorbachev
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Apr 21 2006 - 09:43:40 CDT