Database Creation using DBCA - Silent Mode.

We can create the database using dbca in silent mode to meet the below requirements.

DBname                 :  ramdb
SID                        :  ramdb
CharacterSet          :  AL32UTF8
datafileDestination  :  /export/home/oracle/oradg/oradg/oradata


bash $ dbca -silent -createDatabase -datafileDestination /export/home/oracle/oradg/oradg/oradata -templateName General_Purpose.dbc -gdbname ramdb -sid ramdb -responseFile NO_VALUE -characterSet AL32UTF8

Below o/p will be expected : 

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
57% 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 "c:\oracle\product\1020\cfgtoollogs\dbca\myoracle\myoracle0.log" for further details.

Now we can find the below values from database :

sql> select name,value from v$parameter where value like '%/%';

spfile                         /export/home/u01/app/oracle/product/10.0.2/db_1/dbs/spfileramdb.ora
control_files                  /export/home/oracle/oradg/oradg/oradata/ramdb/control01.ctl, /export/home/oracle/oradg/oradg/oradata/ramdb/control02.ctl, /export/home/oracle/oradg/oradg/oradata/ramdb/control03.ctl
standby_archive_dest           ?/dbs/arch
db_recovery_file_dest          /export/home/u01/app/oracle/flash_recovery_area
background_dump_dest           /export/home/u01/app/oracle/admin/ramdb/bdump
user_dump_dest                 /export/home/u01/app/oracle/admin/ramdb/udump
core_dump_dest                 /export/home/u01/app/oracle/admin/ramdb/cdump
audit_file_dest                /export/home/u01/app/oracle/admin/ramdb/adump
dg_broker_config_file1         /export/home/u01/app/oracle/product/10.0.2/db_1/dbs/dr1ramdb.dat
dg_broker_config_file2         /export/home/u01/app/oracle/product/10.0.2/db_1/dbs/dr2ramdb.dat


Below is the spfile created by dbca :

cat spfileramdb.ora
====================
ramdb.__java_pool_size=4194304
ramdb.__large_pool_size=4194304
ramdb.__shared_pool_size=79691776
ramdb.__streams_pool_size=0
*.audit_file_dest='/export/home/u01/app/oracle/admin/ramdb/adump'
*.background_dump_dest='/export/home/u01/app/oracle/admin/ramdb/bdump'
*.compatible='10.2.0.1.0'
*.control_files='/export/home/oracle/oradg/oradg/oradata/ramdb/control01.ctl','/export/home/oracle/oradg/oradg/oradata/ramdb/control02.ctl','/export/home/oracle/oradg/oradg/oradata/ramdb/control03.ctl'
*.core_dump_dest='/export/home/u01/app/oracle/admin/ramdb/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='ramdb'
*.db_recovery_file_dest='/export/home/u01/app/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(PROTOCOL=TCP) (SERVICE=ramdbXDB)'
*.job_queue_processes=10
*.open_cursors=300
*.pga_aggregate_target=96468992
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=290455552
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/export/home/u01/app/oracle/admin/ramdb/udump'

======= End of the post =========