DBCA is great tool to create database using GUI , but sometimes when we don’t have access to GUI, we can still create database using DBCA silent mode creation where you need to pass silent option with dbca and some parameter values to create database.
In following example we have used template General_Purpose ,
                                                          gdbname[Global Database Name] test1,
                                                          sid[system id] test1,
                                                          CharacterSet WE8MSWIN1252,
                                                          memoryPercentage 40% – in my case my system’s total memory is 4G so database will have  1.6G
                                                          emConfiguration NONE
example  :
C:\Windows\system32>dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbname test1 -sid test1 -CharacterSet WE8MSWIN1252 -memoryPercentage 40 -emConfiguration NONE
Enter SYS user password:
Enter SYSTEM user password:
Copying database files
1% complete
3% complete
11% complete
18% complete
26% complete
37% complete
Creating and starting Oracle instance
40% complete
45% complete
50% complete
55% complete
56% complete
60% complete
62% complete
Completing Database Creation
66% complete
70% complete
73% complete
85% complete
96% complete
100% complete

Look at the log file “d:\oracle\cfgtoollogs\dbca\test1\test1.log” for further details. 

Check database details :
SQL> select name,open_mode from v$database;
--------- --------------------
SQL> show parameter instance_name
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
instance_name                        string      test1
Check default datafiles created :
SQL> select name from v$datafile;

Check tempfile  : 

SQL> select name from v$tempfile;

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

Anuradha’s LinkedIn: Anuradha’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.