How to restart oracle database

Oracle database restart steps: Stop the database: Use the SHUTDOWN IMMEDIATE command. Start the listener: Use the lsnrctl start command. Restart the database: use the STARTUP command.

How to restart Oracle database

Steps to restart Oracle database:

1. Stop the database:

   • Log in to the database server.
   • Open a command prompt or terminal window.

   • Use sqlplus command to connect to the database:

     <code>sqlplus / as sysdba</code>

     Copy after login

     Copy after login

   • Enter <code>SHUTDOWN IMMEDIATE</code> command:

     <code>SHUTDOWN IMMEDIATE</code>

     Copy after login

2. Start the listener:

   • If the listener is not already running, use lsnrctl Command to start it:

     <code>lsnrctl start</code>

     Copy after login

3. Restart the database:

   • Use sqlplus command to connect to the database again:

     <code>sqlplus / as sysdba</code>

     Copy after login

     Copy after login

   • Enter <code>STARTUP</code> command:

     <code>STARTUP</code>

     Copy after login

Other related information:

• <code>SHUTDOWN IMMEDIATE</code> command will shut down the database immediately without waiting for any transactions to complete.
• If you need a cleaner shutdown, you can use the SHUTDOWN NORMAL command, which will wait for all transactions to complete.
• If the database crashes or encounters an error, you can use the STARTUP MOUNT command to mount it in read-only mode for recovery operations.
• Use the lsnrctl stop command to stop the listener.

The above is the detailed content of How to restart oracle database. For more information, please follow other related articles on the PHP Chinese website!