Oracle 12c Administration I

The Database Instance

Database Memory Structures

Database Process Structures

Database Storage Architecture

Oracle Clusterware

Host Configuration Overview

Choosing a Database Host

Choosing an Operating System

Proprietary Unix vs Open-Source Linux

Making the OS Selection

Prepare an Oracle LINUX Installation

Perform Oracle LINUX Installation

Configure the LINUX Host

Step 1 - Confirm General System Requirements

Step 2 - Confirm The Operating System Platform

Step 3 - Confirm LINUX Package Requirements

Step 4 - Confirm Network Configuration

Configure Host for Virtualization

VM Technologies

Configure Oracle Linux for Virtualization

Step 1 - Download Linux Updates

Step 2 - Check Linux Kernel

Step 3 - Download Latest yum Configuration File

Step 4 - Enable Oracle Linux Add-ons

Step 5 - Install VirtualBox

Oracle Optimal Flexible Architecture

OFA Goals

ORACLE_BASE

ORACLE_HOME

Database Files

Multiple ORACLE_HOMEs

Databse Software Upgrades

Mutliple Oracle Software Installations

Configure the Linux Installation

About ASM Devices

Configure Linux Devices for ASM

Partioning a Device

Oracle ASMLib

Configue MS Windows Devices

Perform the Installation

Download

Unpack the Installation Package

Launch the Installation Session

The Installation Dialog

Verify the Installation

Operating System Confirmation

Oracle Utilities Setup

SQL*Plus Confirmation

Using EM Cloud Control

Troubleshooting Problems

Configure a Linux Installation

System Groups & Users

Configure Kernel Parameters

Create the Physical Directories

Configure MS Windows Installation

Prerequisite Checks & Fixup Utility

ABOUT THE INSTALLATION

The Installation Tools

About The Installation Dialog

The Installation Session Log

PERFORM INSTALLATION ON LINUX

Download

Unpack The Installation Files

Set Environment Variables

Launch The Installation

SERVER CLASS INSTALLATION DIALOG

More About The Global Database Name

About Enterprise Manager Cloud Control

Secure The New Database

PERFORM INSTALLATION ON WINDOWS

Launch The Installation

POST---INSTALLATION CONFIGURATION

Required Environment Variables

Defining The Environment Variables

About SSH

VERIFY THE INSTALLATION

SQL*PlusConfirmation

Operating System Confirmation

Firewall Configuration

Accessing EM Database Express

About DBCA

DBCA Templates

Are You Sure?

DEFAULT CONFIGURATION DATABASE

ADVANCED MODE DATABASE

File Location Variables

Database Vault and Label Security

CONFIGURE AN EXISTING DATABASE

DELETE A DATABASE

MANAGE TEMPLATES

MANUALLY CREATE A DATABASE

The CREATE DATABASE Command

WHAT IS ORACLE RESTART?

What Oracle Restart Does

Is Oracle Restart Deprecated?

Registering With Oracle Restart

More About srvctl

Terminal Session Configuration

COMPONENT STATUS USING SRVCTL

Database Status

Grid Infrastructure Status

Oracle Home Status

CONFIGURATION USING SRVCTL

Examining A Database Configuration

Examining The Listener Configuration

Examining The ASM Configuration

Manual Registration

ListenerConfiguration Modification

Database ConfigurationModification

STARTUP/SHUTDOWN USING SRVCTL

Why Use srvctl?

MANAGING ORACLE RESTART

Obtaining Oracle Restart Status

Start/Stop Oracle Restart

What is a Database Upgrade?

Database Upgrade Methods

Real World Database Upgrade

Develop A Database Upgrade Plan

ABOUT THE DATABASE VERSION

Direct Upgrade

The COMPATIBLE Database Parameter

PRE-UPGRADE PREPARATIONS

Oracle Warehouse Builder

Oracle Label Security (OLS)

Oracle Database Vault

Locating The Older Database Installations

THE PRE-UPGRADE INFORMATION TOOL

Pre-Upgrade Information Tool Files

Run The Pre---Upgrade Information Tool

Examining The Pre---Upgrade Information Tool Results

Launch DBUA

Database Upgrade Dialog

Post-Upgrade Checklist

Enable Unified Auditing

Migrate to Unified Auditing

Database Parameter Changes

Enable New Features

Source Destination Specific Post-Upgrade Tasks

About Enterprise Architectures

The Relational Database

Legacy Computing Models

The Multi-Tiered Computing Model

Scaling Up

Cloud-Based Deployment

ORACLE INFRASTRUCTURE ECOSYSTEM

USING ORACLE ENTERPRISE MANAGER

More About EM

Using EM Database Express

Using EM Cloud Control

The Database Server Stack

PROCESSOR LAYER

CPU Resources

Memory Resources

I/O & STORAGE PROCESSING

OS LAYER PROCESSING MODES

DATABASE SERVER VIRTUALIZATION

STORAGE VIRTUALIZATION

ORACLE DATABASE SERVER STACK

ORACLE ENGINEERED SYSTEMS

Oracle Exadata Database Platform

Exalogic Cloud Machine

Exalytics BI Machine

Grid Computing Principles

Why Grid Computing?

What Is Grid Computing?

PARALLELIZATION PRINCIPLES

Hardware Parallelization

Grid Computing Devices

Clustered Database Servers

CLOUD COMPUTING PRINCIPLES

Multi-Tenancy

The Database Server Software

Database Versions & Releases

Database Editions

Using PRODUCT_COMPONENT_VERSION View

The Core Database Components

Using V$VERSION View

Understanding The Database Version Number

The COMPATIBLE Database Parameter

DATABASE INSTANCE ELEMENTS

Individual Elements Of A Database Instance

Physical Database Elements

An Operational Database installation

DATABASE INSTANCE CONFIGURATIONS

Single Instance

Parameter Files & Instance Configuration

MAX_STRING_SIZE Parameter Example

Independent Instances

Clustered Instances

The Database Instance In A Multi-tenant Configuration

RECONFIGURING A DATABASE INSTANCE

Static Vs. Dynamic Parameters

Dynamic Parameter Setting

Parameter Setting Scope

Parameter Setting Level

Setting Upgrade Related Parameters

DATABASE COMPONENTS

Advanced Data Functionality Components

Security Components

High-Performance Components

Administration Components

Database F