Oracle 12c RAC Database Creation Using DBCA

By
Advertisement

Content:

Introduction:


This article explains the step by step procedure to create an Oracle 12c RAC database by using Database Configuration Assistant (DBCA).


Verifying Requirements for DBCA:

1. Please make sure that all cluster nodes are up and running and check the status of cluster.

2. To use Database Configuration Assistant to change the database configuration, use Cluster Verification Utility (CVU) to verify that your system is prepared for configuration changes by using the following command.
$Grid_home/bin/cluvfy stage -pre dbcfg -fixup -n {node_list} -d {Oracle_home_path} -verbose

3. The above command will verify the Node Reachability, User Equivalence, Node Connectivity, Administrative Privileges and Oracle Clusterware Integrity. If the summary indicates that the cluster verification check fails, then review and correct the relevant system configurations, and run it again.

Creating Database with DBCA:


4. Go the oracle home bin location and run dbca (database configuration assistance ) as below.

[ oracle@racnode1 ~] $ cd /u01/app/oracle/product/12.1.0.2/bin
[ oracle@racnode1 ~] $ ./dbca

Database Operation

5. The database creation window will be displayed as shown below. Select Create Database and click on Next button.

Creation Mode

6. Now, select Advanced mode in this screen and click on Next button. If you want to go with custom configuration, then select Create a database with default configuration and enter the  requested parameters for configuration.

Database template

7. Choose the Database type as Real Application Cluster Database.  Choose Configuration Type as Admin-Managed. Accept the default General purpose or Transaction processing and click on Next button.

Database Identification

8. Enter the Global Database Name and SID for database. Click on Next button. If you want to create a container database also check the box below and enter the required parameters.

Database Placement

9. Select the nodes on which you wants to create a database and go with Next.

Management Options

10. Here you can either configure Enterprise Manager Database Express or Register Enterprise Manager Cloud Control for your database. If you are not interested, uncheck the box for Configure Enterprise Manager and click on Next button.

Database Credentials

11. Now you will be presented with below screen. Enter the database administrative passwords and click on Next button. You can use same password for all users or different password for each administrative users.

Storage Locations

12. Specify the Database files Storage Type and make the required the changes like specifying Fast Recovery Area and Enabling Archive log. Once you are done click on Next button.

Database Options

13. In this window you can optionally create Sample Schemas and select a script to run after database creation.

14. In this Database Vault and Label Security window you can optionally configure Database Vault and Label Security for the database by entering the requested fields. After Making changes as per your requirement and click on Next button

Initialization Parameters

15. Now you will be presented with a below Initialization screen.
Memory:
Select the Memory management options here. You can use Typical setting or Custom setting for your database by specifying size of memory.
Sizing:
Specify the number of user processes to connect the database.
Character Sets:
Select the required database character set, language and territory in this window.
Connection Mode:
Accept the default connection mode as Dedicated Server Mode and click on Next button.

Creation Options

16. Select Create Database and click on Next to proceed with database creation.

Prerequisites Checks

17. The installation wizard will perform prerequisite checks and display the summary screen.

Summary

18. The summary screen will show as below. Click on Finish button to start the database creation. If you have any warnings or errors in the summary screen please resolve before proceeding.

Progress Page

19. The database creation will process as in below screen.

Finish

20. The successful database creation shows the below screen. Click on Close button to exit installer.

This completes the Oracle 12c RAC Database creation using dbca.

0 comments:

Post a Comment