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.


MySQL Tutorial

Learn MySQL step by step


 

 

 

 

 

 

 

 

 

Creating Oracle 12c Container Database Example Contd...


On clicking Next button you will be shown the Create Database summary page  where DBCA will show all the settings which you have specified in the previous screens and other settings.

oracle database creation summary

Click Finish

It will take some 10 to 15 minutes to complete the database creation and you will be shown a progress bar as shown in the picture below

database getting created

After some 10 to 15 minutes it will show a Completed Successfully message

database created successfully

And it will show the important information as shown below

database account details]

Click Exit and then Close. Database is now created. You can open the terminal window and verify the files created.

verify database files

Now let us connect to CDB database using SQLPlus.

First set the environment variable ORACLE_SID to ica

connecting to database using sqlplus

To view the current container give the “Show Con_name” command.

connecting to pluggable database using sqlplus

To connect to Pluggable database give the following command

alter session set container=pdb1

connecting to pluggable database

 

 

 

 

 

 


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