Monday, October 23, 2017

Creating a Real Application Cluster(RAC) 12c database using DBCA

After installing Oracle RAC, next step is to create a RAC database. Following is the process of creating a RAC database using dbca. Same method works on Windows or Unix based platforms.To invoke dbca, open a command line and run command “dbca”. On Windows, DBCA can also be invoked from Program Menu..

Click next.

Select “Advanced configuration” so that we can make all selections according to our requirement, while creating a database.

Select database type as “Oracle Real Application Cluster (RAC) database”. Also select template for your database. If you select “Custom Database”, you have control over a configuration of database during the wizard. In case or “General Purpose or Transaction Processing” and “Data Warehouse”, DBCA just copies the datafiles with default configurations.

Select the nodes where you want instances to be created. You can create a RAC database with instances running on all nodes, or some nodes, or even only on one node. Current node where DBCA is invoked will always be selected.

Provide the details for global database name and SID. If you want it to be a container database, click “Create as Container database” option and also select if you want to create a PDB initially, or want to create an empty container database initially. Click next.

Select the storage type. For ASM, provide an already created ASM diskgroup. Click next.

Click check box if you want to enable archiving.

Select the components you want to install. For this example, I am not selecting any of these, except JVM. More components you select, more it will take time to create the database.

On this screen, you see different tabs. From “Memory” tab, you provide the memory allocation to the instances of database. From “Sizing” tab you select database block size and also value for parameter PROCESSES. From “Character sets” tab you select character set and national character set for the database. From “Connection Mode” tab you select whether you want dedicated servers or shared servers connection mode for your database. Last tab lets you select if you want to install sample schemas. Click next.

Select if you want to configure Enterprise Manager database express, and configure CVU to run in the background. You can also configure OEM Database Express manually later. Click next.

Provide administrative accounts passwords. Click next.

Click next. You can also save current settings for database as template or save database creation scripts to be used later, on the same server, or on any other server by copying template on that server. Moreover, you can also create database creation scripts to be used late on the same server, or on other servers.

Prerequisite checks will be executed by dbca. Correct if you find any issue, or ignore if warning is ignore-able. In my case, I see warnings because I don’t have DNS configured in my virtual environment and SCAN is also configured for only one IP because of absence of DNS server. I am just ignoring the warning.

Click on finish to start database creation process.

Monitor the progress of database creation.

After the database creation completes, click “close” to close the dbca. A RAC database with 2 instances has been created and registered with the crs.

No comments:

Popular Posts - All Times