Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to disconnect a user who continues to connect

711405Sep 6 2011 — edited Sep 8 2011
Hi all,

I am seeing a quite strange issue here.

The schema owner '****' is connected to the database. Please disconnect and try again.

I tried to disconnect the user with the following command
select sid,serial# from v$session where username = '****';
alter system kill session '131,6' immediate;
I then see the the commands got successfully executed, and for a little while, there is not such user connecting to my database as I can do another select and no row is selected. But within some short amount of time, I see a new connection. In this case, how can I terminate the connection once and for all? Please help me and many thanks!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 6 2011
Added on Sep 6 2011
23 comments
27,670 views