Global Vendors Training

Home > > 전체교육일정

Oracle

Oracle Database 12c R2: Install and Upgrade Workshop

교육일정
교육기간
2일
교육금액
833,910원(부가세포함)
Oracle전체일정보기 수강신청

교육개요

* 09:30 ~ 17:00 (30시간 / 5일) (점심시간이 1시간 30분)

이 과정은 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



선수과목

없음



강의내용

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

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

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

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

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

6. Oracle Restart
- Controlling Oracle Restart
- Obtaining Help for the SRVCTL Utility
- Using the SRVCTL Utility

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

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

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

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

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



기타

교육비는 부가세 포함