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:
1 | 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 |
2 | Copying database files |
3 | 1% complete |
4 | 3% complete |
5 | 11% complete |
6 | 18% complete |
7 | 26% complete |
8 | 37% complete |
9 | Creating and starting Oracle instance |
10 | 40% complete |
11 | 45% complete |
12 | 50% complete |
13 | 55% complete |
14 | 60% complete |
15 | 61% complete |
16 | 62% complete |
17 | 65% complete |
18 | Completing Database Creation |
19 | 69% complete |
20 | 73% complete |
21 | 76% complete |
22 | 88% complete |
23 | 91% complete |
24 | 100% complete |
25 | Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/rico/rico.log" for further details. |
Nice, isn’t it?