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

 

 

 

 

New: Modern Oracle

Concepts here also apply to Oracle 19c/21c/23ai unless a version note says otherwise. See the homepage for what's changed.