Sunday, September 27, 2009

Create a test Database within 5 minute's

dbca -Silent -CreateDatabase -gdbName $you_oracle_db_name
-templateName $template_name [-characterSet]
[-nationalCharacterSet] [-datafileDestination]
[-databaseType] ....

-- This command should all be on ONE line!
C:\>%oracle_home%\bin\dbca -Silent -createDatabase -gdbName
myoracle -templateName %oracle_home%\assistants\dbca\templates\General_Purpose.dbc
-characterSet WE8MSWIN1252 -nationalCharacterSet ALU32UTF16
-datafileDestination c:\temp -databaseType MULTIPURPOSE

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.

No comments: