Examinations Examinations
This course will aid the delegate in their preparation for the following exam:
- Oracle Database 12cR2: Advanced Administration: 1Z0-073
Oracle Database 12cR2: Advanced Administration: 1Z0-073 Oracle Database 12cR2: Advanced Administration: 1Z0-073
Attending this course will help delegates gain many of the skills and product knowledge requirements as outlined in the exam objectives. Studying this course and its associated reference materials can form part of the preparation to achieve certification. Experience, practice, self-study and aptitude are also key requirements for exam success.
Before taking any exam, ensure you have the recommended experience. The Oracle website lists all exam requirements and these are updated regularly.
Exams are not included as part of the course.
Course Contents
View Course Contents - DAY 1
...more Oracle Database 12cR2 Install & Upgrade Training Course
Course Introduction
- Administration and Course Materials
- Course Structure and Agenda
- Delegate and Trainer Introductions
Session 1: OVERVIEW OF ORACLE DATABASE 12cR2
- Overview of the Oracle Database 12cR2
- Overview of Oracle Database 12cR2 architecture
- Oracle Database instance configuration
- Database storage architecture
- Database logical and physical structures
- Overview of container and pluggable database
Session 2: INSTALL ORACLE GRID INFRASTRUCTURE ON A STANDALONE SERVER
- Overview of Grid Infrastructure for a standalone server
- System requirements and prerequisites
- Install Grid Infrastructure for a standalone server
- Upgrade Grid Infrastructure for a standalone server
Session 3: INSTALL THE ORACLE DATABASE SOFTWARE
- Plan an installation
- System requirements and operating system prerequisites
- Carry out pre-installation checks
- Set environment variables
- Install the Oracle Database software with the Oracle Universal Installer
- Silent mode installation
Session 4: CREATE A DATABASE WITH THE DATABASE CONFIGURATION ASSISTANT (DBCA)
- Selecting a database storage method
- Select a CDB or non-CDB database
- Select a database type based on workload
- Select a character set for the database
- Set the NLS_LANG initialization parameter
- Create a database with the DBCA
- Create a database design template
Session 5: ORACLE RESTART
- Overview of Oracle Restart
- Configuration of Oracle Restart
- Control Oracle Restart
- The srvctl utility
- Use srvctl help
- Use the srvctl utility to start and stop and manage components
View Course Contents - DAY 2
Session 6: PREPARATION FOR UPGRADE TO ORACLE DATABASE 12cR2
- Methods used to perform upgrade
- Methods of data migration
- Direct upgrade supported releases
- Upgrade process overview
- Upgrade a CDB
- Create an upgrade test plan
- Carry out performance testing
- Run the Pre-Upgrade Information tool
- Backup the database
- Install the Oracle Database 12cR2 software
- Create the new Oracle home
Session 7: PERFORM AN UPGRADE TO ORACLE DATABASE 12cR2
- Upgrade a database with the Database Upgrade Assistant (DBUA)
- Upgrade a database manually
- Migrate a non-CDB to a CDB
- Migrate a pre 12.1 or 12.1 non CDB database into a PDB
- Plug in a non CDB database into a CDB
Session 8: POST UPGRADE TASKS
- Carry out post upgrade tasks after a manual upgrade
- Enable Unified Auditing
- Administer the roles required for unified Auditing
Session 9: MIGRATE DATA WITH DATA PUMP
- Migrate data with Data Pump
- Import data using a Data Pump network link
- Create a Container Database using the DBCA
- Create a New PDB from PDB$SEED
- Export from a non-CDB database and Import into a PDB
Course Contents View Course Contents - DAY 1
...more Oracle Database 12cR2 Install & Upgrade Training Course
Oracle Database 12cR2 Install & Upgrade Training Course Oracle Database 12cR2 Install & Upgrade Training Course
Use the srvctl utility to start and stop and manage components View Course Contents - DAY 2