Creating and configuring Oracle database and listener on the first node

Perform the following steps to create and configure Oracle database and listener on the first node in the cluster. Do not perform these steps on the failover nodes yet. Steps for failover nodes are described later in the flow.

To create and configure an Oracle database and a listener

  1. Ensure that the volumes or LUNs created for the Oracle database, control files, log files, bdump, cdump, udump files, flash recovery area, and archive location are mounted on the node.
  2. Bring the temporary service group online on the node. This is the service group that you created while installing Oracle earlier. This service group contains an IP resource which is the virtual IP address for the databases and the listeners.
  3. Create a Listener service.

  4. Configure the listener to use the virtual IP address.

  5. Use the Oracle Database Configuration Assistant (DBCA) to create the database.

    Complete the following steps to create the database:

    • Start the Database Configuration Assistant from Start > All Programs > Oracle-Oracle_Home > Configuration and Migration Tools > Database Configuration Assistant or, on Windows 2012 operating systems, from the Apps menu in the Start screen. This launches the database installer.

    • On the Welcome panel, click Next.

    • On the Operation panel, click Create a database and click Next.

    • On the Database Templates panel, click Custom Database and click Next.

    • On the Management Options panel (Step 4 of 12), choose Use Grid Control for Database Management.

    • Click Next. Follow the installer instructions and select other options as per your desired database configuration.

  6. Configure the database on the shared virtual disk. Review the procedure.

  7. Configure the Oracle and listener services.

    Follow all the steps given in the procedure with one exception. In step 2, bullet 6, choose Local System Account instead of This Account.

More Information

Creating the listener service

Configuring the listeners to use the virtual IP address

Creating the Oracle database on shared disks

Configuring the Oracle database

Configuring the Oracle and listener services