Creating multiple Oracle databases

Create Oracle databases using the Oracle Database Configuration Assistant (DBCA). If you need to have only one database instance, you can skip this task.

About this task

When you create multiple database instances, you must install the databases on each instance. If you use the database wizard to install the databases, prepare and run the database wizard once for each instance. If you use the scripts to install the databases, run the scripts once for each instance.
Complete steps for your operating system:
Parent topic: Creating Oracle databases
Related reference:
DB2 Information Center: Instance creation

Creating multiple Oracle databases on AIX and Linux

Procedure

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. Change login user to oracle
    2. $ export [[ORACLE_HOME]]=...
    3. $ export PATH=$PATH:$ORACLE_HOME/bin
    4. $ export DISPLAY=hostname:displaynumber.screennumber
      Note: where hostname:displaynumber.screennumber represents the client system, monitor number, and window number. For example: localhost:0.0
    5. $ dbca &
  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.

Creating multiple Oracle databases on Windows

Before you begin

Complete these steps for each instance that you plan 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 and click User Rights Assignment.
    3. Open each of the following rights, click Add User or Groupand 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
Tip: The new account uses the local system as the domain.

Procedure

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 your 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.