User Tools

Site Tools


multitenantarchitecture

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
multitenantarchitecture [2015/07/28 10:51] – [Plugging In an Unplugged PDB] z0hpvkmultitenantarchitecture [2025/03/08 22:24] (current) – external edit 127.0.0.1
Line 1: Line 1:
 ===== Multitenant Architecture ===== ===== Multitenant Architecture =====
 +==== Advantages ====
 +  * Database Consolidation
 +  * Reduced Costs
 +  * Rapid Implementation
 +  * Simplified Management
 +  * Separation of Duties
 +  * Simplified Tuning
 +  * Simplified Patching
 +
 +==== Creating a CDB ====
 +Create spfile setting parameter ENABLE_PLUGGABLE_DATABASES = TRUE\\
 +Create instance by specifying STARTUP NOMOUNT\\
 +Create database using CREATE DATABASE command, adding new clause ENABLE_PLUGGABLE_DATABASES. \\
 + If you are not using OMF you must either ... \\
 + Use the SEED FILE_NAME_CONVERT option or set PDB_FILE_NAME_CONVERT in spfile \\
 +Connect to root and run scripts to create data dictionary\\
 +
 ==== Opening / Closing Pluggable Databases ==== ==== Opening / Closing Pluggable Databases ====
 <code>SQL> alter session set container = pdb2; <code>SQL> alter session set container = pdb2;
multitenantarchitecture.1438080688.txt.gz · Last modified: 2025/03/08 22:23 (external edit)