Article How to Create an Oracle 18c RAC Database Step by Step Guide

YouTube video

In this article, we will guide you through the step-by-step process of creating an Oracle 18c RAC Database. This guide assumes that you have already set up your server with the Oracle software and are logged in as the Oracle user. Let’s dive in and get started!

Step 1: Accessing the Oracle Home Bin Directory

To begin the process, login to your system’s node 1 as the Oracle user and navigate to the Oracle Home Bin directory. Once you are in the directory, execute the dbca command.

Step 2: Configuring Database Creation

Once you have executed the dbca command, set the display environment variable if required and start the dbca to create the database. Choose the “Create Database” option and select the “Advanced Configuration” mode.

Step 3: Selecting Nodes

In the configuration options, ensure that both nodes are selected for the database creation. This ensures that the RAC database is created on both nodes, maximizing availability.

Step 4: Naming the Database

Next, determine the global database name. You can either continue with the default name or choose a custom name. It is recommended to use a logical and meaningful name for your database.

Step 5: Storage Management

For storage management, opt for the automatic storage management (ASM) option. This allows for optimized data file location and utilization. Additionally, choose the location for the database files and enable Oracle-managed files.

Step 6: Fast Recovery Area

In this step, enable the fast recovery area. This provides important recovery capabilities in case of any data loss or corruption. Choose the automatic storage management option for the fast recovery area disk group.

Step 7: Optional: Enabling Archiving

You have the option to enable archiving, depending on your requirements. Archiving allows you to store historical data and is useful in scenarios where point-in-time recovery is needed.

Step 8: Memory Allocation

Configure the memory allocation for the database. Consider the resources available on your system and allocate an appropriate size for the database. In this example, reduce the size to around 1500 MB.

Step 9: Management Options

You can choose to keep the default management options or customize them based on your needs. If you do not require any specific management features, it is safe to keep the default options.

Step 10: Passwords for Admin User Accounts

Choose the passwords for the admin user accounts. You can either provide different passwords for each account or use the same password. It is important to choose strong passwords to ensure the security of your database.

Step 11: Confirmation and Summary

Review all the selected options on the summary page. If everything looks correct, you can proceed with the creation of the database. If any changes are needed, you can go back to the respective screens and correct them before proceeding.

Step 12: Creating the Database

Once you are satisfied with the configuration, click the “Create” button to initiate the database creation process. This may take some time to complete, so be patient.

Step 13: Verifying the Database Instance

After the database creation process is completed, you have the option to verify the database instance. Access the respective nodes and ensure that the database instances are running as expected.

Step 14: Completing the Process

Congratulations! You have successfully created an Oracle 18c RAC Database. Your database is now fully set up and ready to be used. In addition, we have also installed the mandatory patch required for upgrading to the 19c version.

Conclusion

In this article, we have provided a comprehensive step-by-step guide for creating an Oracle 18c RAC Database. Following these instructions, you can easily set up a reliable and high-performance database environment. Remember to review each step carefully and adapt the configurations as per your specific requirements. Enjoy the benefits of your newly created Oracle 18c RAC Database and stay tuned for our next session on upgrading to the 19c version of Oracle.