Tuesday, January 15, 2013

Using Database Configuration Assistant to Create Additional Databases

During Oracle Database installation, if you choose to create a starter database (see also [1]), Oracle Universal Installer automatically runs Database Configuration Assistant (DBCA) after software installation is complete. DBCA then guides you through the steps to create the database.

If you do not create a starter database and later want to create one, or if you want to create additional databases, then you use DBCA.  The Database Configuration Assistant enables you to
  • Create a database
  • Configure database options in an existing database
  • Delete a database
  • Manage database templates

There may be situations in which you want to create more than one Oracle database on the same host 
computer. When you do this with DBCA, the new databases typically  use the same Oracle home directory as the first database, but store database data files separately from those of the first database.

In [1], we describe the steps that we used to install a starter database with a Global Database Name (GDNSTAGE7.  In this article, we will show how to add a new database (GDN: ATGOID) in the same Oracle home directory.


Here are our steps to create a new database named ATGOID using DBCA.  Note that highlighted options are our selections.  For more detailed descriptions, read [2].
  1. Welcome
  2. Operations
    • Select the operation that you want to perform:
      • Create a Database
      • Configure Database Options
      • Delete a Database
      • Manage Tempaltes
    • ASM configuration operations must be performed using Automatic Storage Management Configuration Assistant (ASMCA) from Oracle Grid Infrastructure home.
  3. Database Templates
    • Select template to use for creation
      • General Purpose or Transaction Processing
      • Custom Database
      • Data Warehouse
  4. Database Identification
    • See Figure 1 (note that we didn't specify domain name here)
    • Global Database Name: ATGOID
  5. Management Options
    • Uncheck "Configure Enterprise Manager"
    • We don't need this option for our benchmark
  6. Database Credentials
    • Specify passwords for the following user accounts in the new database:
      • SYS
      • SYSTEM
  7. Network Configuration
    • Select the listeners for which you want to register this database:
      • Register this database with all the listeners
      • Register this database with selected listeners only
    • Note that we have created a new listener ATGOID using Net Configuration Assistant[3]
  8. Database File Locations
    • Specify storage type and locations for database files:
      • Storage Type: File System
      • Storage Locations:
        • Use Database File Locations from Template
        • Use Common Location for All Database Files
        • Use Oracle-Managed Files
  9. Recovery Configuration
    • Specify Fast Recovery Area (Default)
  10. Database Content
    • Default
  11. Initialization Parameters
    • Typical (Default)
  12. Database Storage
    • You can specify storage parameters for database creation.  (Default)
  13. Creation Options
    • Select the database creation options
      • Create Database
      • Save as a Database Template
      • Generate Database Creation Scripts
    • Generate Database Creation Scripts

Log File Location

Log files for the current operation are located at:
  • $ORACLE_BASE/cfgtools/dbca/ATGOID

What to Expect?

After the creation of a new database, you should find the following information:
Database Information:
Global Database Name: ATGOID
System Identifier(SID): ATGOID
Server Parameter File name:  $ORACLE_HOME/dbs/spfileATGOID.ora

If you look into initATGOID.ora, you can also find the following two entries:
Note that the domain name is an empty string because we didn't provide domain name at step 4.


  1. Installing Oracle Database 11g Release 2
  2. Oracle® Database 2 Day DBA 11g Release 1 (11.1)
  3. Using Net Configuration Assistant to Configure a Listener


Blogger said...

BlueHost is ultimately the best web-hosting provider for any hosting plans you might require.

Blogger said...

Quantum Binary Signals

Get professional trading signals delivered to your cell phone daily.

Follow our signals NOW and gain up to 270% per day.