From Wiki-UX.info

Oracle 12c Linux Basic Administration Tasks
Jump to: navigation, search

Oracle 12c Linux Basic Administration Tasks

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

  1. Login to the server using the oracle account.
# ssh localhost

  1. 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
  1. 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

Authors

Editor

This page was last modified on 4 May 2014, at 20:57. This page has been accessed 1,662 times.