Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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

4 Answers 4

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

Short:

  • ALTER SYSTEM QUIESCE RESTRICTED;
    puts the Database in quiesce mode

  • ALTER SYSTEM UNQUIESCE;
    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
1  
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

 
discard

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.