Starting and Stopping Oracle Database¶
This chapter covers how to start up and shutdown Oracle Database using cx_Oracle.
Starting Oracle Database Up¶
cx_Oracle can start up a database instance. A privileged connection is
required. This example shows a script that could be run as the ‘oracle’
operating system user who administers a local database installation on Linux.
It assumes that the environment variable ORACLE_SID
has been set to the SID
of the database that should be started:
# the connection must be in PRELIM_AUTH mode to perform startup
connection = cx_Oracle.connect("/",
mode = cx_Oracle.SYSDBA | cx_Oracle.PRELIM_AUTH)
connection.startup()
# the following statements must be issued in normal SYSDBA mode
connection = cx_Oracle.connect("/", mode = cx_Oracle.SYSDBA, encoding="UTF-8")
cursor = connection.cursor()
cursor.execute("alter database mount")
cursor.execute("alter database open")
To start up a remote database, you may need to configure the Oracle Net
listener to use static service registration
by adding a SID_LIST_LISTENER
entry to the database listener.ora file.
Shutting Oracle Database Down¶
cx_Oracle has the ability to shutdown the database using a privileged
connection. This example also assumes that the environment variable
ORACLE_SID
has been set:
# need to connect as SYSDBA or SYSOPER
connection = cx_Oracle.connect("/", mode = cx_Oracle.SYSDBA)
# first shutdown() call must specify the mode, if DBSHUTDOWN_ABORT is used,
# there is no need for any of the other steps
connection.shutdown(mode = cx_Oracle.DBSHUTDOWN_IMMEDIATE)
# now close and dismount the database
cursor = connection.cursor()
cursor.execute("alter database close normal")
cursor.execute("alter database dismount")
# perform the final shutdown call
connection.shutdown(mode = cx_Oracle.DBSHUTDOWN_FINAL)