How to disconnect user in Oracle 11g as a sysdba

Posted on 2010-09-08
Last Modified: 2013-12-19
I want to drop a user, It says "cannot drop a user that is already connected"
Question by:pegahelpdesk1
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 22

Expert Comment

by:Om Prakash
ID: 33624703
The user is still connected so you cannot drop. check the following thread for possible actions:

Assisted Solution

esmail1349 earned 62 total points
ID: 33624743
You have to kill its opened sessions first then drop it.

Accepted Solution

sumit2906 earned 63 total points
ID: 33625040
thats right, you will find out the sid and serial# from v$session:
select sid, serial# from v$session where username = 'username';
alter system kill session 'sid, serial#' immediate;

Author Comment

ID: 33625115

Featured Post

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Character matching different date formats for dates between 6 73
Oracle DB monitor SW 21 74
capture vmstat info and insert it into an oracle table 31 62
Excess Redo 3 32
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question