Oracle Database 12c Multitenant: oracle 12c - Create and Configure a Container Database (CDB) and PDB USING DBCA

su - oracle
echo $ORACLE_HOME
/u01/app/oracle/product/12.1.0/dbhome_1/
echo $ORACLE_BASE
/u01/app/oracle
$dbca
create database
click advance mode
next
general purpose
nextt
global databse name:cdb1
sid cdb1
PDB name ==pdb
next
configure enterprize management database express
next
Database credentials
use same adminstrator password for all accounts
Networkconfiguration
select
next
uncheck and nexr
next
database option
check sample schemas
next
Installaation parameters
precheck
and
finish
========================================================================
https://www.youtube.com/watch?v=-zMNZrg_BqU&list=PLFIuxLy_v_CVZIDNyLYsO49TGZxcXANil

Oracle 12c DBCA Create CDB PDBs
install gridinfrastructue
and dbms software
cat /etc/oratab
ps -ef |grep -i smon
cd /u01/app/oracle/product/12.1.0/dbHome_1/bin/dbca &

1)create database
2)DATABASE TEMPLATE: custom database option
3)DATABASE IDENTIFICATION: Global database Name :cdb1
SID :cdb1
create container database
Number of PDB :2

PDB name prefix :pdb
Next
4)MANAGEMENT OPTIONS : configure enterprize Manager database express
5)DATABASE CREDENTIALS : Use the same administrative password for all accounts
6)NETWORK CONFIGURATION : LISTENER
7) STORAGE LOCATION :ASM
USE COMMON LOCATION :+DATA
USE OMF
FASTRECOVERY AREA :+FRA
10 CBYTES
ENABLE ARCHIVELOG
8)DATABASE OPTION :NEXT
9)DATABASE VAULT : UNCHECK K CONFIGURE DATABASE VAULT
UNCHECK LABEL SECURITY
10)INTITIALIZATION PARAMETER : TYPICAL SETTING
: ENABLE AUTOMATIC MEMORY MANAGENT
11)CREATION OPTION :GENERATE DATABASE CREATION SCRIPTS
:CREATE DATABASE
NEXT
FINISH

LOOOK AT ORATAB FILE
cdb1:/u01/app/oracle/product/12.1.0/dbhome_1:N
ps -ef|grep -i smon

. oraenv
cdb1
lsnrctl start
sqlplus / as sysdba
SQL>select instance_name ,version , status from v$instance;
SQL>select dbid,name,cdb,con_id, con_dbid from v$database;
SQL>select pdb_id,dbid, pdb_name,status from cdb_pdbs order pdb_id;

============================================================================================

Thursday, September 3, 2015

Installing Oracle Database 12c as Container Database with three Pluggable DatabasesInstalling Oracle Database 12c as Container Database with three Pluggable Databases

Installing Oracle Database 12c as Container Database with three Pluggable Databases

Here is a video recorded during the creation of the first database. Go on if you want to see all the screenshots.

So we have already installed the software of the Oracle Database 12c release 1 (have a look at this post) and now we want to create a database using dbca.
So let's run dbca from the oracle user.

view plainprint?
[oracle@vsi08devpom ~]$ dbca &  

Select the operation you want to perform using dbca. Because I've already created an Oracle Database all the options are available. Anyway I want to create another database so I'm going to select Create Database.

During the Creation Mode screen you have two options:
1. you can create a database with default configuration. It's possible to create it as Container Database and create also one Pluggable Database.

I'm not going to click the finish button right now. I want to use the second option to create a database.

2. So choose Advanced Mode in which you configure your own database structure. This option enables you to perform more complex installations, such as creating individual passwords for different accounts, creating specific types of starter databases (for example, for transaction processing or data warehouse systems), using different language groups, specifying email notifications, and so on.

During the Advanced Mode screens you can choose to create the database as Container Database.
Select the Create as Container database option to create the database as a multitenant container database (CDB) that can support one pluggable database (PDB). If you want Oracle Universal Installer to create a PDB when it creates the CDB, specify the PDB name in the Pluggable Database Name field. The PDB name must be unique. If you need to create more than one PDB you have to provide a PDB Name Prefix.

The next Advanced Mode screen asks you how you want to manage your database: configuring the EM Database Express or registering it with EM Cloud Control.

The next screen asks you to specify passwords for SYS, SYSTEM and PDBADMIN or use the same password for all accounts.

The next screen asks you to select a listener or create a new one.

The next screen asks you to specify the storage locations for database files (storage type: File System or Automatic Storage Management) and for recovery related files (you can specify a Fast Recovery Area and enable archiving)

The next screen shows you the several database components you are going to configure like Oracle Database Vault or Label Security.

The next screen asks you to configure Database Vault and Label Security (I didn't select them during this installation).

The next screen let you specify settings about memory, default database block size and the maximum number of operating system user processes simultaneously connected to the database, character sets and the connection mode (dedicated server mode or shared server mode).Select the Enable Automatic Memory Management option to allow the database to automatically distribute memory between SGA and PGA. If you do not select this option, then the SGA and PGA must be sized manually.

The next screen asks you to select the Creation Options for the database (create, save as database template, generate database creation scripts).

The pre requisite checks are all satisfied.

Creation of the database configuration summary.

Database configuration summary created. So click finish button to begin the installation process.

The database creation is in progress... still 36%.

The database is finally created as well as the EM Database Express. In my case I was running another EM Database Express so the next available port was used (5501 instead of the "already in use" 5500). If you want to change the port number of your EM Database Express have a look at this post.