oracle sql and dba tutorial logo

Oracle DBA

Learn Oracle 11g / 12c Database Admin step by step



Oracle SQL

Tutorial for Oracle SQL

 

Oracle DBA Interview Questions

Most asked Oracle DBA Interview Questions.

60 Technical Questions
42 Backup & Recovery Questions

Unix For Oracle DBA 20 Questions


Download Oracle 11g / 12 c Software

Links to Download Oracle 12c / 11g for Linux, Windows etc.



Creating Multitenant Database in Oracle 12c Using SQL Statements

Creating a Container Database Using SQL Commands

Let’s us create a container database (CDB) by name ICACDB and one pluggable database ICAPDB1.

We will place all datafiles, logfiles, controlfile of CDB in /u02/oracle/icacdb directory and place seed database pdbseed database datafiles in ‘/u02/oracle/icacdb/pdbseed’ directory and pluggable database PDB1 files /u02/oracle/icacdb/icapdb1 directory

Step 1: Make directories

$mkdir /u02/oracle/icacdb

$cd /u02/oracle/icacdb
$mkdir icapdb1
$mkdir fast_recovery_area
$mkdir pdbseed

Create directory for storing audit files

$mkdir $ORACLE_BASE/admin/icacdb
$cd $ORACLE_BASE/admin/icacdb
$mkdir adump

Create directory for diagnostic destination

$cd /u02/oracle/icacdb
$mkdir diag

Step 2:- Create Parameter File by copying Template

$cd $ORACLE_HOME/dbs
$cp init.ora initicacdb.ora

Now open the PFile in vi editor and edit the require parameters. After editing it should look like as shown below

db_name='icacdb'
memory_target=500M
processes = 150
audit_file_dest=/opt/oracle/product/admin/icacdb/adump
audit_trail ='db'
db_block_size=8192
db_domain=''
db_recovery_file_dest='/u02/oracle/icacdb/fast_recovery_area'
db_recovery_file_dest_size=2G
diagnostic_dest=/u02/oracle/icacdb/diag
dispatchers='(PROTOCOL=TCP) (SERVICE=ICACDBXDB)'
open_cursors=300
remote_login_passwordfile='EXCLUSIVE'
undo_tablespace='UNDOTBS1'
control_files = '/u02/oracle/icacdb/control01.ora'
compatible ='12.1.0'
enable_pluggable_database=TRUE

 

Next Page

 

 

 


HomeContact Us

Data Loader

Data Loader is a simple yet powerful tool to
export and import Data between many common database formats


Forms Data Loader

Tool to load data into Oracle E-Business Suite R12 / Oracle Apps using Macros and Forms Record and Playback

Interface Computers Academy © 2007-2017 All Rights Reserved