There are a lot of new powerful features in the 12c database but don’t forget about the little features that can make a DBA happier on the day to day basis 🙂
One of my favourites is a new approach to use a DBCA command line interface to create a database in silent mode:
oracle@ryba:~$ dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbName rico -sid rico -createAsContainerDatabase false -sysPassword Oracle123 -systemPassword Oracle123 -emConfiguration DBEXPRESS -datafileDestination /u01/app/oracle/oradata -storageType FS -characterSet AL32UTF8 -nationalCharacterSet AL16UTF16 -listeners LISTENER -sampleSchema true -automaticMemoryManagement false -totalMemory 4096 -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
60% complete
61% complete
62% complete
65% complete
Completing Database Creation
69% complete
73% complete
76% complete
88% complete
91% complete
100% complete
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/rico/rico.log" for further details.
26 LINESTEXT / UTF-8
Nice, isn’t it?