Differences

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

--- multitenantarchitecture [2015/07/28 10:37] – z0hpvk
+++ multitenantarchitecture [2025/03/08 22:24] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
 ===== 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 ====
 <code>SQL> alter session set container = pdb2;
@@ Line 76: / Line 93: @@
 Pluggable database dropped.</code>
+==== Plugging In an Unplugged PDB ====
+For this example I will simply plug back in the database that was dropped from above.\\
+If I was moving the PDB to a new location on the server I would need to use the 'copy' parameter at the end of the command.
+<code>SQL> create pluggable database pdb3 using '/home/oracle/pdb2.xml';
+Pluggable database created.</code>
+The database is in MOUNTED mode and must be opened after it has been created.\\
+The Service Name was created automatically when the PDB was plugged in.