이 과정은 Oracle Database 12c R2 소프트웨어의 설치시 필요한 세부 정보에 대해 배우는 과정입니다.
오라클 전문강사로부터 Container database의 생성과 Pluggable database의 Provision에 대해 배우게 됩니다.

Learn To:
○ Oracle 소프트웨어 설치를 위해 Oracle Linux 7 운영 체제를 구성합니다.
○ Oracle Universal Installer를 사용하여 독립형 서버용 Oracle Grid Infrastructure (12.1)를 설치합니다.
○ 황금 이미지를 사용하여 독립 서버용 Oracle Grid Infrastructure (12.2)를 설치합니다.
○ ASMLIB를 구성하고 ASM 디스크 그룹을 작성합니다.
○ Oracle Universal Installer를 사용하여 Oracle Database 소프트웨어 (12.1)를 설치합니다.
○ 자동 설치를 사용하여 Oracle Database 소프트웨어 (12.2)를 설치합니다.
○ 패치 세트 업데이트를 Oracle 소프트웨어에 적용합니다.
○ Oracle Restart를 사용하여 구성 요소를 관리합니다오.
○ 기존 Oracle Database를 Oracle Database 12c Release 2 (12.2.0.0.3)로 업그레이드합니다.
○ 컨테이너 데이터베이스를 만들고 플러그 가능한 데이터베이스를 프로비저닝합니다.

○ Upgrade database to Oracle Database 12c Release 2
○ Create a container database
○ Install Oracle Grid Infrastructure for a Standalone Server
○ Configure ASMLIB and create ASM disk groups
○ Apply the latest patch set updates to the Grid Infrastructure software
○ Install Oracle Database 12c Release 2 software
○ Use Oracle Restart to manage components
○ Prepare the Linux operating system for Oracle software installation
○ Install Oracle Grid Infrastructure for an Independent Server
○ Install Oracle Database 12c software
○ Create an Oracle Database using DBCA
○ Install the latest patch set updates to the Oracle database software

Technical Administrator/Data Warehouse Administrator/Database Administrators/Support Engineer

□ Course Topics

 

○ Oracle Database 12c R2: Overview
- Oracle Database Innovation
- Oracle Database Server Architecture: Overview
- Process Architecture
- Database Storage Architecture
- Oracle Database Memory Structures
- Objectives
- Oracle Database Instance Configurations
- Connecting to the Database Instance

 

○ Oracle Software Installation Basics
- Operating System Groups and Users
- Environment Variables
- Configuring the Oracle Software Owner Environment
- Planning Your Installation
- Using Oracle Universal Installer (OUI)
- Installation Option: Silent Mode
- Configuring Oracle Linux with Oracle RDBMS Pre-Install RPM

 

○ Installing Oracle Grid Infrastructure for a Standalone Server
- Post Patch steps using Datapatch
- Determining the latest patch sets available using Oracle Support
- Patching Using OPatch
- Upgrading OPatch
- Patching Using OPlan
- Patching Using opatchauto
- Overview of Patching
- Types of patches

 

○ Installing Oracle Database Software
- Creating Operating System Groups and Users
- Types of Installations
- Oracle Database Installation: System Requirements

 

○ Creating an Oracle Database by Using DBCA
- Creating a Container Database by Using DBCA
- Planning the Database
- Using the DBCA to Create a Database
- Creating a Database Design Template
- Choosing the Appropriate Character Set
- Understanding How Character Sets Are Used
- Setting the NLS_LANG Initialization Parameter
- Types of Databases

 

○ Oracle Restart
- Controlling Oracle Restart
- Obtaining Help for the SRVCTL Utility
- Using the SRVCTL Utility

 

○ Introduction to Upgrading to Oracle Database 12c
- Upgrade Paths
- Upgrade Method Limitations
- Database Upgrade Assistant: Advantages and Disadvantages
- Upgrading to a New Release of Oracle Database
- Defining Upgrade and Data Migration
- Upgrade Methods
- Manual Upgrade: Advantages and Disadvantages
- Migration Methods

 

○ Preparing to Upgrade to Oracle Database 12c
- Requirements for Databases Using Oracle Label Security or Oracle Database Vault
- Performance Testing
- Developing a Test Plan
- Planning the Upgrade
- Requirement for Databases Using Oracle Warehouse Builder
- Using the Pre-Upgrade Information Tool
- Backing Up the Database
- Preparing to Upgrade

 

○ Upgrading to Oracle Database 12c
- Manually Upgrading to Oracle Database 12c
- Upgrading by Using the Database Upgrade Assistant (DBUA)
- Plugging a Non-CDB Database into a CDB
- Key DBUA Features
- Migrating a Pre-12.1 or 12.1 Non-CDB to CDB

 

○ Performing Post-Upgrade Tasks
- Understanding Auditing Implementation
- Recommended Tasks After Database Upgrade
- Enabling Unified Auditing
- Required Tasks After Database Upgrade
- Administering the Roles Required for Auditing

 

○ Migrating Data by Using Oracle Data Pump
- Creating a New PDB from PDB$SEED
- Exporting from a Non-CDB and Importing into a PDB
- Oracle Data Pump: Overview
- Importing by Using a Network Link
- Migrating by Using Oracle Data Pump
- Creating a Container Database by Using DBCA
- Data Pump Utility: Interfaces and Modes
- Data Pump Export and Import Clients: Overview