Oracle 11g RAC Workshop 2: Learn How to Manage and Troubleshoot Oracle RAC One Node
Oracle Real Application Clusters (RAC) is a technology that allows multiple servers to run Oracle database software simultaneously while accessing a single database. Oracle RAC provides high availability, scalability and performance for your database applications.
Oracle RAC One Node is a single instance of Oracle RAC running on a single node in a cluster. It offers many benefits such as server consolidation, workload management flexibility, improved online maintenance and easy migration to Oracle RAC.
In this workshop, you will learn how to install, configure, manage and troubleshoot Oracle RAC One Node. You will also learn how to use Oracle Clusterware and Automatic Storage Management (ASM) to support your Oracle RAC One Node database.
By the end of this workshop, you will be able to:
Install and manage Oracle Grid Infrastructure
Create an Oracle RAC One Node database using Database Configuration Assistant (DBCA)
Perform live instance migration using Omotion
Apply rolling patches using Online Database Relocation
Control CPU consumption using Resource Manager instance caging
Scale Oracle RAC One Node to Oracle RAC
Troubleshoot Oracle RAC One Node issues
Follow best practices for deploying Oracle RAC One Node
This workshop is designed for database administrators who have prior knowledge of Oracle Database and want to learn more about Oracle RAC One Node. It is based on Oracle Database 11g Release 2 and requires a computer with minimum i5 processor, 16 GB RAM and 300 GB free disk space. You will also need to install Oracle Enterprise Linux 6.5 on two nodes of RAC and configure shared storage, public and private network for them.
If you are interested in this workshop, please visit this link for more details and registration.
In this section, we will walk you through the steps of installing Oracle Grid Infrastructure on two nodes of RAC. Oracle Grid Infrastructure consists of Oracle Clusterware and ASM, which are essential components for Oracle RAC One Node.
Before installing Oracle Grid Infrastructure, you need to perform some pre-requisites on both nodes, such as setting up the hostnames, configuring the network interfaces, creating the OS groups and users, setting the kernel parameters and disabling the firewall and SELinux.
After completing the pre-requisites, you can download the Oracle Grid Infrastructure software from this link and unzip it to a staging directory. Then, you can run the runInstaller script from the grid directory to launch the Oracle Universal Installer (OUI).
OUI will guide you through the installation process, where you need to provide some information such as:
The installation option: choose \"Install and Configure Oracle Grid Infrastructure for a Cluster\"
The cluster configuration: choose \"Advanced Installation\"
The cluster name and scan name: choose a unique name for your cluster and a single name to access any node in the cluster
The network interfaces: choose the public and private network interfaces for your cluster
The storage option: choose \"Use ASM\" to store your database files
The ASM disk groups: create a disk group for your database files and another disk group for your voting disks and OCR files
The OS groups and users: choose the OS groups and users that you created earlier for grid and asm administration
The root scripts execution: choose \"Automatically run configuration scripts\" to run the root scripts on both nodes automatically
After providing all the information, OUI will perform some checks and then start the installation. You can monitor the progress and status of the installation on OUI. Once the installation is completed, you can verify that Oracle Grid Infrastructure is up and running on both nodes by using commands such as crsctl, srvctl and asmcmd. ec8f644aee