Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

forcing a user to disconnect

Posted on 1998-07-21
3
Medium Priority
?
3,318 Views
Last Modified: 2008-02-26
How do I force a user to disconnect from the Oracle system 7.3.3.5 under unix?
0
Comment
Question by:glow060197
[X]
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
  • 2
3 Comments
 

Author Comment

by:glow060197
ID: 1083366
Edited text of question
0
 

Accepted Solution

by:
rpullella12 earned 280 total points
ID: 1083367
Here are the options :

1.  Find the unix username, specific unix process(pid) for the oracle connection (ps -ef), kill the session with kill -9 <pid>

2.  Login as DBA/svrmgr, query the v$session view
    where username = <DB user_name>.  Get the values for sid and
    serial# columns, issue the command
    alter system kill session 'sid, serial#' ;

Ensure the process size is manageable to fit within the available rollback segments.  

0
 

Author Comment

by:glow060197
ID: 1083368
wow you answered my question 20 minutes after i posted it.  thanks for the help

glow
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

721 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