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; NAME OPEN_MODE --------- -------------------- TEST1 READ WRITE SQL> show parameter instance_name NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ instance_name string test1 Check default datafiles created : SQL> select name from v$datafile; NAME -------------------------------------------------------------------------------- D:\ORACLE\ORADATA\TEST1\SYSTEM01.DBF D:\ORACLE\ORADATA\TEST1\SYSAUX01.DBF D:\ORACLE\ORADATA\TEST1\UNDOTBS01.DBF D:\ORACLE\ORADATA\TEST1\USERS01.DBF
Check tempfile :
SQL> select name from v$tempfile; NAME -------------------------------------------------------------------------------- D:\ORACLE\ORADATA\TEST1\TEMP01.DBF
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
