Using the DBCA
The DBCA is a fairly simple and versatile tool for creating, copying, reconfiguring, and deleting databases. It's also very easy to automate most of these operations.
Creating a Database with the DBCA
When using the DBCA to create a database as part of an initial Oracle install, you must use a response file in conjunction with a database template. Response files can be used in other contexts, but aren't needed. The response file format is very similar to the formats of both the Oracle Universal Installer (OUI) and the Network Configuration Assistant (NetCA) files.
Using a response file is very simple, and very similar to how it's done with OUI. The basic UNIX command is:
dbca -silent -responseFile /fully/qualified/filename.rsp ...
Get Oracle® DBA Automation Quick Reference 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.
