Scribd
Upload
21 views2 pages

Oracle12c Startup Shutdown Guide

The document provides a guide for starting up and shutting down Oracle 12c on RHEL 7.0. It outlines the necessary steps for logging in as the Oracle user, stopping the database and listener before shutdown, and starting them after booting the server. Additionally, it mentions the option to automate the Oracle startup process on system boot by editing configuration files.

Uploaded by

Nidhees Singh
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
21 views2 pages

Oracle12c Startup Shutdown Guide

The document provides a guide for starting up and shutting down Oracle 12c on RHEL 7.0. It outlines the necessary steps for logging in as the Oracle user, stopping the database and listener before shutdown, and starting them after booting the server. Additionally, it mentions the option to automate the Oracle startup process on system boot by editing configuration files.

Uploaded by

Nidhees Singh
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

Oracle 12c Startup and Shutdown Guide for RHEL 7.

BEFORE SHUTTING DOWN THE SERVER

1. Login as Oracle User:

$ su - oracle

2. Stop the Oracle Database:

$ sqlplus / as sysdba

SQL> SHUTDOWN IMMEDIATE;

SQL> EXIT;

3. Stop the Listener:

$ lsnrctl stop

(Optional) If Enterprise Manager (OEM/EM Express) is configured, stop it too.

----------------------------------------------

AFTER STARTING THE SERVER

1. Login as Oracle User:

$ su - oracle

2. Set Environment Variables (if not in ~/.bash_profile):

$ export ORACLE_BASE=/u01/app/oracle

$ export ORACLE_HOME=$ORACLE_BASE/product/12.1.0/dbhome_1
$ export ORACLE_SID=orcl (or your actual SID)

$ export PATH=$ORACLE_HOME/bin:$PATH

Or simply run:

$ source ~/.bash_profile

3. Start the Listener:

$ lsnrctl start

4. Start the Database:

$ sqlplus / as sysdba

SQL> STARTUP;

SQL> EXIT;

----------------------------------------------

OPTIONAL: Automate Oracle Startup on Boot

You can edit /etc/oratab and create a systemd or init.d script.

You might also like