callicon +1 210-504-8191
whatsAppIcon +1 210-504-8191
emailIcon info@koenig-solutions.com
koenig-logo
logo-30-years
Login
koenig-logo
whatsAppIcon +1 210-504-8191
phoneIcon +1 210-504-8191

Oracle Database 12c R2: Install and Upgrade Workshop Ed 2 Course Overview

Oracle Database 12c R2: Install and Upgrade Workshop Ed 2 Course Overview

The Oracle Database 12c R2: Install and Upgrade Workshop Ed 2 course is designed to provide database administrators with the knowledge and skills necessary to install and upgrade Oracle Database 12c R2. Through a series of modules, participants learn about the database's architecture, including memory and process structures, and how to manage both container and pluggable databases. The course covers the installation of Oracle Grid Infrastructure for a standalone server, setting up Oracle Automatic Storage Management (ASM), and using the Oracle Universal Installer.

Additionally, learners are guided through creating databases with the Database Configuration Assistant (DBCA) and managing databases with Oracle Restart. The workshop places a strong emphasis on upgrading strategies, preparing for upgrades, and executing the upgrade process to Oracle Database 12c. Post-upgrade tasks and data migration using Oracle Data Pump are also crucial components of the curriculum. This course ensures that learners are well-equipped to maintain up-to-date and efficient Oracle database environments, enhancing their database management capabilities.

This is a Rare Course and it can be take up to 3 weeks to arrange the training.

4.6 Ratings

Koenig's Unique Offerings

images-1-1

1-on-1 Training

Schedule personalized sessions based upon your availability.

images-1-1

Customized Training

Tailor your learning experience. Dive deeper in topics of greater interest to you.

images-1-1

4-Hour Sessions

Optimize learning with Koenig's 4-hour sessions, balancing knowledge retention and time constraints.

images-1-1

Free Demo Class

Join our training with confidence. Attend a free demo class to experience our expert trainers and get all your queries answered.

Purchase This Course

Fee On Request

♱

  • Live Online Training (Duration : 16 Hours)
  • Per Participant
  • Guaranteed-to-Run (GTR)
  • date-img
  • date-img

♱ Excluding VAT/GST

Classroom Training price is on request

  • Live Online Training (Duration : 16 Hours)
  • Per Participant

♱ Excluding VAT/GST

Classroom Training price is on request

Request More Information

Email:  WhatsApp:

Course Prerequisites

To ensure a successful learning experience in the Oracle Database 12c R2: Install and Upgrade Workshop Ed 2 course, participants should have the following minimum required knowledge and skills:


  • Basic understanding of database concepts, including relational databases and SQL (Structured Query Language).
  • Familiarity with the use and administration of at least one operating system (such as Linux, Unix, or Windows).
  • Knowledge of general computing concepts such as file system structure and configuration files.
  • Some experience with command-line interfaces and scripting is beneficial, as the course may involve executing commands in a terminal or command prompt.
  • Prior exposure to Oracle Database technologies is advantageous but not mandatory.

These prerequisites are designed to provide a foundation for the course material. The course will build upon this baseline to expand your skills and understanding of Oracle Database 12c R2 installation, upgrade, and management.


Target Audience for Oracle Database 12c R2: Install and Upgrade Workshop Ed 2

The Oracle Database 12c R2 course is designed for IT professionals managing database systems and seeking to upgrade their skills.


  • Database Administrators (DBAs)
  • IT Specialists involved in database installation, configuration, or upgrade
  • System Administrators managing database environments
  • Technical Consultants providing strategic guidance for database infrastructure
  • Oracle Developers looking to understand the underlying architecture and installation processes
  • Data Architects planning and designing database structures
  • Database Analysts involved in performance tuning and optimization
  • IT Managers overseeing database operations or migration projects
  • Technical Support Engineers assisting clients with Oracle Database issues
  • IT professionals aspiring to become Oracle Certified Professionals (OCP)


Learning Objectives - What you will Learn in this Oracle Database 12c R2: Install and Upgrade Workshop Ed 2?

Introduction to Learning Outcomes

Gain in-depth knowledge of Oracle Database 12c R2 installation, upgrade processes, and data migration with hands-on experience in configuring and managing the database environment.

Learning Objectives and Outcomes

  • Understand the core architectural components of Oracle Database 12c, including memory structures and process architecture.
  • Learn the installation requirements and process for Oracle Grid Infrastructure for a standalone server, including ASM configuration.
  • Master Oracle Database software installation, including system requirements, environment preparation, and silent mode installation techniques.
  • Create and manage Oracle Databases using the Database Configuration Assistant (DBCA), with a focus on database storage structures and character set selection.
  • Utilize Oracle Restart to manage process startup and understand how to control and configure it using SRVCTL utility.
  • Explore various upgrade methods and data migration strategies for upgrading to Oracle Database 12c.
  • Prepare for database upgrades by developing test plans, performing backups, and using pre-upgrade information tools.
  • Conduct upgrades using the Database Upgrade Assistant (DBUA) and perform manual upgrades, including migrating non-CDB to CDB.
  • Execute post-upgrade tasks, including migration to Unified Auditing and completing tasks following a manual upgrade.
  • Use Oracle Data Pump for efficient data migration, and understand how to import using a network link.