Solved

How to disconnect user in Oracle 11g as a sysdba

Posted on 2010-09-08
4
3,697 Views
Last Modified: 2013-12-19
I want to drop a user, It says "cannot drop a user that is already connected"
0
Comment
Question by:pegahelpdesk1
4 Comments
 
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:
http://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=10354
0
 
LVL 1

Assisted Solution

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

Accepted Solution

by:
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;
0
 

Author Comment

by:pegahelpdesk1
ID: 33625115
thankyou
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Oracle sql query 7 74
Character matching different date formats for dates between 6 59
Oracle DB monitor SW 21 60
Function to return one result based on data in first query 11 50
This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows how to recover a database from a user managed backup
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

839 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