multitenantarchitecture
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| multitenantarchitecture [2015/08/19 13:49] – z0hpvk | multitenantarchitecture [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 ==== | ==== Creating a CDB ==== | ||
| Create spfile setting parameter ENABLE_PLUGGABLE_DATABASES = TRUE\\ | Create spfile setting parameter ENABLE_PLUGGABLE_DATABASES = TRUE\\ | ||
| Create instance by specifying STARTUP NOMOUNT\\ | Create instance by specifying STARTUP NOMOUNT\\ | ||
| Create database using CREATE DATABASE command, adding new clause ENABLE_PLUGGABLE_DATABASES. \\ | 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 \\ | + | 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\\ | Connect to root and run scripts to create data dictionary\\ | ||
multitenantarchitecture.1439992190.txt.gz · Last modified: 2025/03/08 22:23 (external edit)