Oracle Database 19c: Multitenant Architecture cover image

Oracle Database 19c: Multitenant Architecture

Duration: 4 Days

SGD 1,650.00

Oracle Database 19c: Multitenant Architecture is a feature introduced in Oracle Database that allows a single database instance, known as a Container Database (CDB), to host multiple separate databases, called Pluggable Databases (PDBs).  This architecture provides a way to consolidate multiple databases on a single hardware resource, making it easier to manage, administer, and optimize resources.
Introduction

  • Overview to the multitenant architecture
  • Benefits of multitenant architecture
  • Components: container database (CDB) and pluggable databases (PDBs)

Multitenant Architecture Components

  • Understanding container database (CDB)
  • Understanding pluggable databases (PDBs)
  • Differences between non-CDB and CDB architectures

Installing and Configuring Multitenant Architecture

  • Installation of Oracle Database 19c with multitenant option
  • Configuration of a multitenant environment
  • Creating a CDB

Creating and Managing PDBs

  • Creating PDBs using SQL, DBCA, and PDB seed
  • Managing PDBs: start, stop, and clone
  • PDB administration

Security in Multitenant Environment

  • User security in CDB and PDBs
  • Managing roles and privileges
  • Implementing transparent data encryption (TDE) in PDBs

Backup and Recovery of Multitenant Databases

  • Backup strategies for CDB and PDBs
  • Recovery scenarios in a multitenant environment
  • Using RMAN with a multitenant architecture

Performance Tuning in Multitenant Architecture

  • Resource management in a multitenant environment
  • Tuning PDBs for optimal performance
  • Monitoring performance using Enterprise Manager

Managing Data in PDBs

  • Moving data between PDBs
  • Importing and exporting data in PDBs
  • Using Oracle Data Pump in a multitenant architecture

Patching and Upgrading in a Multitenant Environment

  • Patching strategies for CDBs and PDBs
  • Upgrading PDBs: best practices
  • Downtime minimization techniques

High Availability and Disaster Recovery

  • Configuring Data Guard with multitenant databases
  • Failover and switchover scenarios in a multitenant environment
  • Implementing Oracle RAC with a multitenant architecture

Troubleshooting Multitenant Databases

  • Common issues in multitenant architecture
  • Diagnostic tools and techniques
  • Troubleshooting techniques for PDBs

Best Practices for Multitenant Architecture

  • Security best practices
  • Backup and recovery best practices
  • Performance tuning best practices

*Course fee/person - Subject to minimum 4 registrations. (Public/Private schedule)

Oracle Database 19c: Multitenant Architecture Oracle certification Oracle certification courses Oracle training online Oracle database certification Oracle cloud certification Oracle SQL certification Oracle Java certification Oracle certification cost Oracle certification training institute Oracle certification exam preparation Oracle certification online course Oracle certification for beginners Oracle certification syllabus Oracle certification classes Oracle certification Singapore Oracle training Singapore Oracle certification course Singapore Oracle cloud certification Singapore Oracle classes in Singapore Oracle certification fees Singapore Oracle certification Malaysia Oracle training Malaysia Oracle database course Malaysia Oracle certification institute Malaysia Oracle certification Kuala Lumpur Oracle certification Myanmar Oracle training Myanmar Oracle course Yangon Oracle certification classes Myanmar Oracle online training Myanmar Oracle certification Cambodia Oracle training Phnom Penh Oracle database course Cambodia Oracle certification online Cambodia Oracle certification Thailand Oracle training Bangkok Oracle certification course Thailand Oracle cloud certification Thailand Oracle certification USA Oracle certification online USA Oracle database certification USA Oracle cloud certification USA Oracle certification cost USA Oracle certification training institutes USA Oracle certification UK Oracle training London Oracle certification course UK Oracle cloud certification UK Oracle certification fees UK Oracle certification UAE Oracle certification Dubai Oracle training Dubai Oracle certification course UAE Oracle classes Dubai Oracle cloud certification UAE best Oracle certification training in Singapore Oracle DBA certification training in Dubai Oracle cloud certification cost in UK Oracle certification for beginners in Thailand Oracle SQL certification course in Cambodia Oracle certification training institute in Myanmar Oracle certification exam preparation online USA top Oracle certification centers in UAE
The logos are used for illustrative purposes only, with no intended endorsement.