linux close oracle

Under the Linux operating system, Oracle is a key database used by many enterprises and institutions. However, sometimes we need to shut down the Oracle database. This article explains how to safely and efficiently shut down an Oracle database on a Linux system.

Step 1: Stop the database connection

Before shutting down the Oracle database, you must first stop all applications currently connecting to the database. This can be done in one of two ways:

Method One: Using SQL*Plus

First, log in to the database as "SYSDBA" using the SQL*Plus tool:

sqlplus / as sysdba

Then, use the following command to list all currently active database connections:

SELECT SID, Serial#, UserName, Status, Program
FROM V$SESSION
WHERE STATUS = 'ACTIVE';

Confirm the application currently connected to the database by viewing the returned information. Next, use the following command to disconnect from the database:

ALTER SYSTEM KILL SESSION 'sid,serial#';

where "sid" and "serial#" are the session ID and serial number of the connection respectively.

Method 2: Using Oracle Enterprise Manager

In Oracle Enterprise Manager, select the “Database” tab, and then select the “Sessions” subtab. List all currently active database connections and select the connection to close. Finally, click the “Disconnect” button.

Step 2: Stop the Oracle service

After closing the connection, we can stop the Oracle service to allow further work. The following are two methods to stop Oracle services in the Linux operating system:

Method One: Using Oracle Utilities

First, open a Linux terminal and change the directory to the home directory of the Oracle instance . Run the following command to stop the Oracle service:

cd /path/to/oracle_home
./bin/dbshut

Upon stopping, you will be prompted for the username and password for the database account. Once entered, the Oracle service will be stopped.

Method 2: Use system management service

In the Linux operating system, the Oracle service can be configured as a system management service. In this way, we can use the following command to stop the service:

systemctl stop oracle.service

Step 3: Clean up database resources

If you need to perform tasks such as backup or other database cleanup operations, you must before shutting down the Oracle database Unload database resources. The following are two methods to uninstall database resources in the Linux operating system:

Method 1: Using Oracle Utilities

First, use the SQL*Plus tool to log in to the database as "SYSDBA":

sqlplus / as sysdba

Then, use the following command to unload the database resource:

SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
BACKUP DATABASE;

This will start the database in read-only mode (MOUNT) before unloading the database resource. Then, use the BACKUP command to back up the database. After the backup is completed, use the following command to shut down the database:

SHUTDOWN IMMEDIATE;

Method 2: Use RMAN

In RMAN (Oracle's backup and recovery management tool), you can use the following command to back up and uninstall the database Resources:

rman target /
backup database;
shutdown immediate;
startup mount;
backup database;
shutdown immediate;

This will back up the database and unload the database resources.

Summary

Although shutting down an Oracle database may be unavoidable, be sure to make preparations before shutting down, such as stopping all applications that are connecting to the database and backing up the data. Also remember to use appropriate methods to stop Oracle services to avoid data corruption or other problems. Based on this, we can shut down the Oracle database very safely and efficiently and unload the database resources for backup or other operations.

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