Oracle 12c Linux Basic Administration Tasks
From Wiki-UX.info
Abstract
This article shows many basic administration tasks for Oracle 12c running on a RedHat or Fedora linux.
Contents
Stop Oracle database
Before shutdown the linux system where Oracle 12c database is executing, you need to gracefully shutdown the application. The shutdown command is use on a sqlplus session.
1. Login to the server using the oracle account.
2. Start a sqlplus session, connect SYS as SYDBA.
# $ORACLE_HOME/sqlplus SYS@SYSDBA
# shutdown
Start Oracle database
- Login to the server using the oracle account.
# ssh localhost
- Start Oracle database
[oracle@hostname oracle]$ sqlplus / AS SYSdBA
SQL*Plus: Release 12.1.0.1.0 Production on Sun May 4 13:05:27 2014
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL> STARTUP
ORACLE instance started.
Total System Global Area 2505338880 bytes
Fixed Size 2291472 bytes
Variable Size 671090928 bytes
Database Buffers 1811939328 bytes
Redo Buffers 20017152 bytes
Database mounted.
Database opened.
SQL> exit
- Check that the oracle processes are running using the ps command.
[oracle@xw8200 oracle]$ ps -ef | grep [o]ra_
oracle 9732 1 0 13:06 ? 00:00:00 ora_pmon_FED20ORA12C
oracle 9734 1 0 13:06 ? 00:00:00 ora_psp0_FED20ORA12C
oracle 9736 1 0 13:06 ? 00:00:05 ora_vktm_FED20ORA12C
oracle 9740 1 0 13:06 ? 00:00:00 ora_gen0_FED20ORA12C
oracle 9742 1 0 13:06 ? 00:00:00 ora_mman_FED20ORA12C
oracle 9746 1 0 13:06 ? 00:00:00 ora_diag_FED20ORA12C
oracle 9748 1 0 13:06 ? 00:00:00 ora_dbrm_FED20ORA12C
oracle 9750 1 0 13:06 ? 00:00:00 ora_dia0_FED20ORA12C
oracle 9752 1 0 13:06 ? 00:00:00 ora_dbw0_FED20ORA12C
oracle 9754 1 0 13:06 ? 00:00:00 ora_lgwr_FED20ORA12C
oracle 9756 1 0 13:06 ? 00:00:00 ora_ckpt_FED20ORA12C
oracle 9758 1 0 13:06 ? 00:00:00 ora_lg00_FED20ORA12C
oracle 9760 1 0 13:06 ? 00:00:00 ora_lg01_FED20ORA12C
oracle 9762 1 0 13:06 ? 00:00:00 ora_smon_FED20ORA12C
oracle 9764 1 0 13:06 ? 00:00:00 ora_reco_FED20ORA12C
oracle 9766 1 0 13:06 ? 00:00:00 ora_lreg_FED20ORA12C
oracle 9768 1 0 13:06 ? 00:00:01 ora_mmon_FED20ORA12C
oracle 9770 1 0 13:06 ? 00:00:00 ora_mmnl_FED20ORA12C
oracle 9772 1 0 13:06 ? 00:00:00 ora_d000_FED20ORA12C
oracle 9774 1 0 13:06 ? 00:00:00 ora_s000_FED20ORA12C
oracle 9786 1 0 13:06 ? 00:00:00 ora_tmon_FED20ORA12C
oracle 9788 1 0 13:06 ? 00:00:00 ora_tt00_FED20ORA12C
oracle 9790 1 0 13:06 ? 00:00:00 ora_smco_FED20ORA12C
oracle 9792 1 0 13:06 ? 00:00:00 ora_aqpc_FED20ORA12C
oracle 9794 1 0 13:06 ? 00:00:00 ora_w000_FED20ORA12C
oracle 9798 1 0 13:06 ? 00:00:04 ora_p000_FED20ORA12C
oracle 9800 1 0 13:06 ? 00:00:05 ora_p001_FED20ORA12C
oracle 9802 1 0 13:06 ? 00:00:00 ora_p002_FED20ORA12C
oracle 9804 1 0 13:06 ? 00:00:00 ora_p003_FED20ORA12C
oracle 9806 1 0 13:06 ? 00:00:00 ora_p004_FED20ORA12C
oracle 9808 1 0 13:06 ? 00:00:00 ora_p005_FED20ORA12C
oracle 9810 1 0 13:06 ? 00:00:00 ora_p006_FED20ORA12C
oracle 9812 1 0 13:06 ? 00:00:00 ora_p007_FED20ORA12C
oracle 9840 1 0 13:06 ? 00:00:01 ora_cjq0_FED20ORA12C
oracle 9846 1 0 13:06 ? 00:00:00 ora_qm02_FED20ORA12C
oracle 9854 1 0 13:06 ? 00:00:00 ora_q002_FED20ORA12C
oracle 9858 1 0 13:06 ? 00:00:00 ora_q003_FED20ORA12C
oracle 10069 1 0 13:16 ? 00:00:00 ora_w001_FED20ORA12C
Starting and Stopping the Oracle Enterprise Manager Console
$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.1.0 Production on Sun May 4 14:26:16 2014
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> show parameter dispatchers
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
dispatchers string (PROTOCOL=TCP) (SERVICE=FED20O
RA12CXDB)
max_dispatchers integer
SQL> exec dbms_xdb_config.sethttpsport (5500)
PL/SQL procedure successfully completed.
SQL> select dbms_xdb_config.gethttpsport () from dual;
DBMS_XDB_CONFIG.GETHTTPSPORT()
------------------------------
5500
Reference
- Starting Up the Database Using the SQL Command Line
- Oracle® Database Administrator's Guide - 12c Release 1 (12.1) - Starting Up and Shutting Down
- Automating Database Startup and Shutdown on Linux
- Oracle Database 12c: Enterprise Manager Database Express
- Starting and Stopping the Oracle Enterprise Manager Console