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 live online training, plus books, videos, and digital content from nearly 200 publishers.