Close oracle command

Command to shut down Oracle

Oracle is one of the most popular relational database management system software in the world. Its high availability, high performance, high stability and other characteristics have been widely recognized and applied. When using Oracle, we usually need to shut down the database for maintenance or shutdown. So what is the specific command to shut down Oracle? This article will introduce in detail how to shut down the Oracle database in different environments.

1. Commands to close the Oracle database in Linux environment

1. Several ways to close the Oracle database

1) Use SQL*Plus to close the Oracle database

Enter the sqlplus command in the Linux system terminal to enter SQL*Plus, enter the user name and password, log in to the Oracle database, and then enter the shutdown command to close the database:

$ sqlplus / as sysdba
SQL> shutdown immediate

Among them, as sysdba has super administrator privileges, and we can also use other administrator accounts to shut down. The shutdown immediate command means to immediately shut down the database and forcefully kill the running process.

2) Use the Oracle command to close the database

You can also close the Oracle database by entering the following command in the Linux terminal:

$ oraenv
ORACLE_SID = [oracle] ? sid
ORACLE_HOME = [/u01/app/oracle/product/11.2.0/dbhome_1] ?
$ sqlplus / as sysdba
SQL> shutdown immediate

Among them, the oraenv command is to change the environment The variable is set to the Oracle instance currently being used, and sid is the system ID of Oracle. You need to specify the corresponding SID when using this command.

2. Notes

Before closing the Oracle database, you need to log off the instance of the database from the listener, otherwise the listener will fail to start when starting the database. Case. You can use the following command to log out:

$ lsnrctl
LSNRCTL> set current_listener LISTENER_NAME
LSNRCTL> status
LSNRCTL> status listener_name
LSNRCTL> stop

Where, LISTENER_NAME is the name of the listener. Use the status command to view the status of the current listener, and use the stop command to log out of the listener.

2. Commands to close the Oracle database in the Window environment

1. Several ways to close the Oracle database

In the Oracle Windows environment, we can Use the following methods to close the database:

1) Use SQL*Plus to close the Oracle database

Press the WIN R key to open the run window in the Windows system, and enter the cmd command to enter the command line interface . Enter the bin directory under the Oracle installation directory, execute the sqlplus command and enter the user name and password to log in to the Oracle database. Then enter the shutdown command to close the database:

$ sqlplus /nolog
SQL> connect / as sysdba
SQL> shutdown immediate

Connect logs in to the database in sysdba mode.

2) Use the Oracle service to shut down the Oracle database

It is very easy to use the service to shut down the Oracle database in the Windows system. You only need to execute the following command:

$ net stop OracleServiceORCL

ORCL is the system identifier of Oracle and needs to be replaced with the corresponding identifier.

2. Notes

When closing the Oracle database in Windows, you need to log out of the instance just like Linux, and you need to stop all services related to the database first.

Summary

Whether in a Linux environment or a Windows environment, shutting down the Oracle database is very simple and easy to understand. You only need to enter the shutdown command to completely shut down the database. However, it should be noted that before closing the database, you need to log out the corresponding instance and listener to ensure orderly shutdown and startup, which is very important for the stability and reliability of the database. At the same time, when shutting down and starting the database, you also need to pay attention to the database running status and log information in order to detect and deal with relevant exceptions in a timely manner.

The above is the detailed content of Close oracle command. For more information, please follow other related articles on the PHP Chinese website!