linux oracle shutdown

In enterprises, Oracle database is a very common database, which provides reliable data storage and access. In addition, many enterprises also use Linux systems to run their servers and applications. In some cases, it may be necessary to shut down the Oracle database. This article will introduce how to shut down the Oracle database on Linux systems.

First, we need to confirm that we are logged in to the Oracle database server. We can connect to the server via SSH and log in as an administrator. After logging in, we enter the directory $ORACLE_HOME/bin, where $ORACLE_HOME is the path where the Oracle software is located. In this directory, we will see some Oracle Database related executable files, such as sqlplus and lsnrctl. These files will help us shut down the Oracle database.

Secondly, the files related to Oracle database shutdown are the "listener.ora" and "tnsnames.ora" files, which are both in the $ORACLE_HOME/network/admin directory. These files contain configuration information for the Oracle instance and listeners. When we shut down the Oracle database, we should also shut down all Oracle instances and listeners that make up the database.

To shut down the Oracle database, we first need to shut down the Oracle instance. We can use the "sqlplus" command line tool to log in to the database and connect to the target database as a system administrator. Run the following statement in sqlplus:

shutdown immediate;

This command will immediately close the database. If this database is performing certain transactions, running this command will stop them. If you want to shut down the database, you can also use the following command:

shutdown;

However, compared with "shutdown immediate", "shutdown" will wait for the transaction being executed to complete or enter the wait state before shutting down the database.

After closing the Oracle database instance, we also need to close its listener. We can use the "lsnrctl" command line tool to access the listener and close it. Run the following statement in the command line tool:

lsnrctl stop

This command will turn off the listener. After closing the listener, we have completed the shutdown of the Oracle database.

After closing the Oracle database, Python enthusiasts can use a simple Python script to verify whether the database has been closed. This Python script will connect to the database. If the connection fails, the database is closed.

import cx_Oracle

try:
    cx_Oracle.connect("{username}/{password}@{hostname}:{port}/{database}")
    print("Oracle database is still open!")
except cx_Oracle.DatabaseError as err:
    print("Oracle database is closed!")

In this article, we have learned how to shut down Oracle database on linux system. We achieved this by shutting down all Oracle instances and listeners that make up the database. Additionally, we introduced a Python script that verifies that the database has been closed. I hope this information will be helpful to companies that need to shut down Oracle databases.

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