Monday, December 3, 2007

dbca -silent

Hi,
Today I fell with dbca ..... (database configuration assistant)

dbca -silent -createDatabase -templateName "New Database" -gdbName orcl -sid orcl -sysPassword "orcl" -systemPassword "orcl" -emConfiguration NONE -dbsnmpPassword "orcl" -sysmanPassword "orcl" -datafileDestination /u01/app/oracle/orcl/
Database is an invalid command line argument.
Database is an invalid command line argument.


Oracle stores .dbc files against templates. so go for those.......

[root@imran oracle]# find / -name *.dbc -print
/u01/app/oracle/product/10.2.0/db_1/assistants/dbca/templates/Data_Warehouse.dbc
/u01/app/oracle/product/10.2.0/db_1/assistants/dbca/templates/General_Purpose.dbc
/u01/app/oracle/product/10.2.0/db_1/assistants/dbca/templates/Transaction_Processing.dbc

[oracle@imran oracle]$ dbca -silent -createDatabase -templateName /u01/app/oracle/product/10.2.0/db_1/assistants/dbca/templates/Data_Warehouse.dbc -gdbName orcl -sid orcl -sysPassword "orcl" -systemPassword "orcl" -emConfiguration NONE -dbsnmpPassword "orcl" -sysmanPassword "orcl" -datafileDestination /u01/app/oracle/orcl/

Copying database files
1% complete
3% complete
11% complete
18% complete
26% complete
33% 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 "/u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/dbca/orcl/orcl.log" for further details.

This was a happy day for me :)

No comments: