How to temporariliy disable access to Oracle database?

Question

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?

Answer 1

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

Answer 2

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.

Answer 3

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

Answer 4

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