Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I would like to be able to temporarily disable all access to an Oracle database, except my own, to be able to perform maintenance actions without interruptions. Simplest way?

share|improve this question

Check out this link:

How to switch Oracle in Single User-Multi Session Mode

During a migration it may be important, that nobody can connect to the database. You may have two possibilities to achieve this

On Table Level using LOCK TABLE

On Database Level using RESTRICTED SESSION

share|improve this answer

This is known as quiescing the database, there are number of options depending on how you want to deal with users who are presently connected. My favourite technique when I'm in a tight change window is STARTUP FORCE RESTRICT.

share|improve this answer

See Quiescing a Database


    puts the Database in quiesce mode

    puts the database back in normal operation

share|improve this answer

Additionally, a more basic solution would be to shutdown the listener.

share|improve this answer
This will only work if you have no access from the database server itself. These connections bypass the listener. – Robert Merkwürdigeliebe Nov 23 '10 at 8:16

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.