Re:Re: DROP USER - cannot drop a user that is currently con.
- From: "Mathias Diehl" <md@xxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 21 Apr 2006 15:43:40 +0100
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@xxxxxxxxxxxxx>:
>> 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
>>
>>
>>
>
>
>--
>Best regards,
>Alex Gorbachev
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » Re:Re: DROP USER - cannot drop a user that is currently con.
