Database Administration for Specific Platforms › UNIX/Oracle Routine Procedures › Stopping the Database

Stopping the Database

Follow these steps:

1. Stop the Message Dispatcher, following the instructions for stopping the servers.
2. Set the SID for the required database:
   1. If you are using Bourne Shell or Korn Shell, set and export the SID. For example:

      ORACLE_SID=<database name>
      

      export ORACLE_SID
      

   2. If you are using C Shell, use the setenv command to set the SID. For example:

      setenv ORACLE_SID
      

3. Type the Oracle command:

   sqlplus /nolog
   

   connect sys as sysdba
   

   shutdown
   

   exit
   

4. Run Steps 2 and 3 for the Coordination and the Encyclopedia database.

Note: If there are processes pending against the database, the system may not respond to a normal shutdown. If this occurs, type the following:

sqlplus shutdown immediate

For more information, see the Client Server Encyclopedia User Guide.