How to restart the database in Oracle?

2 years ago
Isabella Edwards
1 minute

To restart the Oracle database, you need to follow the steps below:

  1. Access the terminal or command line interface of the operating system.
  2. Log in to SQL*Plus as the system database administrator by using the following command:
    sqlplus / as sysdba
  3. Enter the password to log in to the database.
  4. shut down quickly
  5. Wait for the database to fully shut down.
  6. new business venture.
  7. Waiting for the database to fully start.
  8. Show the name and status of the instance from the v$instance table.

Please make sure to back up the database before performing these actions, just in case.

bannerAds