Oracle7 Server Administrator's Guide

Contents Index Home Previous Next

Altering Database Availability

You can make a database partially available by opening a previously mounted but closed database so that users can connect to and use the database.

The following sections explain how to alter a database's availability:

Mounting a Database to an Instance

When you need to perform specific administrative operations, the database must be started and mounted to an instance, but closed. This can be accomplished by starting the instance and mounting the database.

When mounting the database, you can indicate whether to mount the database exclusively to this instance or concurrently to other instances.

To mount a database to a previously started instance, use either of the following options:

Use the following statement when you want to mount a database in exclusive mode:

ALTER DATABASE MOUNT;

See Also: For a list of operations that require the database to be mounted and closed, (and procedures to start an instance and mount a database in one step) see "Starting an Instance and Mounting a Database" [*].

Opening a Closed Database

You can make a mounted but closed database available for general use by opening the database. To open a mounted database, use either of the following options:

Use the following statement to open a mounted database:

ALTER DATABASE OPEN;

After executing this statement, any valid Oracle7 user with the CREATE SESSION system privilege can connect to the database.

Restricting Access to an Open Database

Under normal conditions, all users with the CREATE SESSION system privilege can connect to an instance. However, you can take an instance in and out of restricted mode. When an instance is in restricted mode, only users who have both the CREATE SESSION and RESTRICTED SESSION system privileges can connect to it. Typically, only administrators have the RESTRICTED SESSION system privilege.

Restricted mode is useful when you need to perform the following tasks:

To place an instance in restricted mode, use the Restrict menu item of Server Manager or the SQL command ALTER SYSTEM with the ENABLE RESTRICTED SESSION option. After placing an instance in restricted mode, you might want to kill all current user sessions before performing any administrative tasks.

To lift an instance from restricted mode, use the Allow All menu item of Server Manager or the SQL command ALTER SYSTEM with the DISABLE RESTRICTED SESSION option.

See Also: For more information about killing sessions, see "Terminating Sessions" [*].

For more information about starting a database instance, and mounting and opening the database in restricted mode, see "Restricting Access to a Database at Startup" [*].


Contents Index Home Previous Next