Problems in Oracle RAC Configuration

As the most cluster product in Oracle, RAC has many articles on Oracle RAC configuration on the Internet. However, in some wonderful articles, RAC cannot be configured successfully. The following is a detailed description of the relevant content.

Because RAC is a very complex software, and most of these documents only describe how to do it, rather than how to handle errors.

Here, I will list common problems encountered during Engineering and training, hoping to help you. If you think it is good, please repeat it. Indicate the source for reprinting.

The following conditions apply to AIX, Solaris, HP-UX, and Linux. When an error occurs during Oracle RAC configuration, the error information is not clear. Generally, the error cause cannot be determined based on the error information. In this case, you can determine the cause based on the following conditions.

1. The time of each node in the cluster should be as consistent as possible

2. Do not specify private IP addresses such as 192. 168. * and 10. *. * for public NICs.

3. The public network must use the same Nic of each node.

4. Each node requires a VIP, which must be in the same subnet as the public network.

5. In some systems, such as Solaris), you need to specify the default gateway for the VIP.

6. Make sure that the partition information is visible on all nodes when partitioning a hard disk.

7. You must specify the correct permissions and owner for the OCR and vote devices.

8. Specify the host name for public IP, private IP, and VIP. The host name cannot contain uppercase letters and underscores (_), but can contain minus signs -)

9. If the configuration fails, delete all the configuration results and start from scratch.

10. When installing clusterware, you must set the environment variable ORACLE_HOME. When installing Oracle and RAC, you need to re-specify this variable, and the same directory cannot be specified.

11. Correctly configure the trust relationship between nodes

It takes about three steps to configure Oracle RAC:

Install clusterware

Install Oracle and RAC

Create a database under RAC

The first step is the most error-prone, and the above 10 cases are mainly aimed at the first step. The problems that need attention in the next two steps will be pasted in the future.