Automating Database Creation without the DBCA

Creating an Oracle database without the DBCA may seem daunting at first glance, but it's actually a very simple process. At a very high level, the process consists of the following steps:

1.
Create an initialization parameter file (init.ora).
2.
Set up the environment.

  1. On UNIX, set the ORACLE_SID environment variable to the new SID.

  2. On Windows, use the ORADIM command to initialize a new database service.

3.
Connect to the instance as sysdba.
4.
Issue the create database command.
5.
Create additional tablespaces, if any.
6.
Run data dictionary scripts.
7.
Run optional, additional dictionary scripts.

A Minimal init.ora

In Oracle 10g, a minimal init.ora is very brief. One of the major goals in this new version ...

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.

Start your free trial