Examining a manual database creation
There's no doubt that the DBCA can make the creation of a database significantly simpler. However, for our purposes as DBAs, there is a downside to using it. Although we've walked through the individual configuration steps, we don't know how DBCA actually did it. For instance, we mentioned earlier that DBCA created the physical files needed to store the database. However, we don't know the commands that were actually used.
Since it is important for us to understand steps like these, we need to dig deeper into the actual process. In truth, DBCA is only a frontend application that builds a set of scripts—the same ones we generated at the end of our DBCA session. Those scripts are then run, and the database is ...
Get OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
