How to reboot the Oracle database

2 years ago
William Carter
1 minute

To restart the Oracle database, you can follow these steps:

  1. Log in to the Oracle database server on the operating system with administrator privileges.
  2. Open the command prompt or terminal window.
  3. To stop the Oracle database instance, input the following command:
sqlplus / as sysdba
shutdown immediate
  1. Wait for the database instance to finish closing.
  2. Use the following command to start the Oracle database instance:
sqlplus / as sysdba
startup
  1. Waiting for the database instance to finish starting.
  2. You can use the following command to verify if the database has been successfully launched:
sqlplus / as sysdba
select instance_name, status from v$instance;

If the status of the database is “OPEN”, it indicates that the database has been successfully launched.

Please be aware that restarting the Oracle database may interrupt any ongoing operations, so make sure there are no critical operations in progress before executing this action. Additionally, ensure to perform a proper backup before restarting.

bannerAds