How to Restart the Oracle Database

 

For restart operation, we must stop and start the Oracle database.

In this article we will show the below scenarios;

  • stop an instance of rack database
  • stop all instance of rack database
  • start an instance of rack database
  • start all instance of rack database

 

To stop the Instance, we load the profile as follows, or with “. Oraenv”.

You can read the following articles to load profiles.

 

How To Connect To Oracle With sqlplus“,

How To Create .profile File To Connect The Oracle

 

Stop an instance of rack database:

if you want to stop an instance of the database you should use the below commands.

After the -d parameter we write the database name, after the -i parameter we write the instance name.

 

You can also use the following commands after you connect the instance with sqlplus to close the instance.

 

Stop all instance of rack database:

If you want to stop the database you should use the below commands.

You can stop the database as follows. After the -d parameter we write the database name.

 

Start an instance of rack database:

If you want to open the database to work on only one instance, you can use the following commands after connecting to instance with sqplus.

If only the startup command is executed, the above operations are executed automatically in order.

 

Start all instance of rack database:

You can start the database as follows. After the -d parameter we write the database name.

dbtut
Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *