Create multiple Oracle databases

Create Oracle databases using the Oracle Database Configuration Assistant (DBCA). If have only one database instance, we can skip this task. When you create multiple database instances, install the databases on each instance. If we use the database wizard to install the databases, prepare and run the database wizard once for each instance.

Create multiple Oracle databases on AIX and Linux

Each database is a database instance. To create Oracle databases on AIX and Linux, use the Oracle Database Configuration Assistant (DBCA) to complete these steps:

1. To open the DBCA tool:

   1. Log on as user "oracle" and run...
      export [[ORACLE_HOME]]=...
      export PATH=$PATH:$ORACLE_HOME/bin
      export DISPLAY=hostname:displaynumber.screennumber
      dbca &

      ...where hostname:displaynumber.screennumber represents the client system, monitor number, and window number. For example: localhost:0.0

2. On the Operations page, accept the default option to...
   Create a database

3. On the Database Templates page, accept the option...
   General Purpose

4. On the Database Identification page, enter LSCONN in the Global Database Name and SID fields

5. On the Management Options page, accept the default option to...
   Configure the database with Enterprise Manager

6. On the Database Credentials page, enter the database password

7. On the Storage Options page, accept the option...
   File System storage

8. On the Database File Locations page, accept the option...
   Database File Locations from Template

9. On the Recovery Configuration page, accept the option...
   Specify Flash Recovery Area

10. On the Database Content page, accept the defaults

11. On the Initialization Parameters page, click the tab...
    Character Sets

    ...and select the option...

    Use Unicode (AL32UTF8)

12. On the Database Content page, accept the defaults

13. On the Creation Options page, accept the option...
    Create Database

Create multiple Oracle databases on Windows

Complete these steps for each instance to create:

1. Create a new user and add it to the Administrators group.

2. Remove the user account from the Users group.

3. Grant rights to the new user:

   1. Click...
      Start | Run

      ...and enter...

      secpol.msc

   2. Expand...
      Local Policies | User Rights Assignment

      ...open each of the following rights. Click Add User or Group and add the new user:

      • Act as part of the operating system
      • Adjust memory quotas|Increase quotas for a process
      • Create a token object
      • Debug programs
      • Lock pages in memory
      • Log on as a service
      • Replace a process level token

The new account uses the local system as the domain.

Each database is a database instance. To create Oracle databases on Windows, use the Oracle Database Configuration Assistant (DBCA) to complete these steps:

1. To open the DBCA tool, click Start. Select Oracle > Oracle_home_name > Configuration and Migration Tools > Database Configuration Assistantwhere Oracle_home_name is the Oracle home on the system. For example: OraDB10g_Home1.

2. On the Operations page, accept the default option to Create a database, and click Next.

3. On the Database Templates page, accept the General Purpose default option and click Next.

4. On the Database Identification page, enter LSCONN in the Global Database Name and SID fields and click Next.

5. On the Management Options page, accept the default option to Configure the database with Enterprise Manager and click Next.

6. On the Database Credentials page, enter the database password and click Next.

7. On the Storage Options page, accept the File System storage option and click Next.

8. On the Database File Locations page, accept the Database File Locations from Template default option and click Next.

9. On the Recovery Configuration page, accept the Specify Flash Recovery Area default option and click Next.

10. On the Database Content page, accept the defaults and click Next.

11. On the Initialization Parameters page, click the Character Sets tab and select the Use Unicode (AL32UTF8) option. Click Next.

12. On the Database Content page, accept the defaults and click Next.

13. On the Creation Options page, accept the Create Database default option and click Next.

Parent topic:
Create multiple database instances

Related reference:

DB2 Information Center: Instance creation