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 Oracle 12c Container Database Example

Creating a Container Database using DBCA

For Creating a Container Database using SQL Statements Please click here

Let’s us create a container database by name ICA and one pluggable database PDB1.

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

Step 1: Make directories

$mkdir /u02/oracle/ica
$cd /u02/oracle/ica
$mkdir pdb1

Step 2. Start DBCA

Grant access to X-Windows by typing following command as root

#xhost +

Start DBCA as Oracle User

$ dbca

Choose "Create Database" option and click "Next" button

Oracle database details

 

 

 

 

 

Enter or edit the given options like Files Location, Administrative Password etc and click Next

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