oracle 11g rac installation

Oracle 11g RAC (Real Application Cluster) is a high-availability and scalable database solution that can automatically manage database instances and data files in a cluster environment, thereby improving database availability and performance. This article will introduce the installation process of Oracle 11g RAC, including preparations, environment configuration, software installation and cluster settings.

1. Preparation work

1. Confirm hardware and operating system requirements: Oracle 11g RAC requires that the server configuration meets certain hardware requirements, and an appropriate version of the operating system also needs to be installed. Before installation, you need to carefully review the hardware and operating system requirements and ensure that the server meets the requirements.
2. Install the required software: Installing Oracle 11g RAC requires preparing the Oracle installation package, Oracle Clusterware, Oracle Grid Infrastructure and other components. Before downloading these software packages, you need to register an Oracle account first, and then log in to the Oracle official website to download the required software.
3. Configuring the network: In a cluster environment, network configuration is very important. It is necessary to configure an independent IP address for each node and create a virtual IP address to access the entire cluster.

2. Environment configuration

1. Node name setting: In order to avoid node name conflicts, an independent name needs to be set for each node. At the same time, you need to add the corresponding relationship between the IP address and name of each node in the /etc/hosts file.
2. User and group settings: Create the oracle user and oinstall group on all nodes, and ensure that the uid and gid of these users and groups are the same on all nodes.
3. Kernel parameter settings: Modify the /etc/sysctl.conf file and add the following parameters:

net.core.rmem_max = 4194304
net.core.wmem_max = 4194304
fs.file-max = 6815744
kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
kernel.shmall = 1073741824
kernel.shmmax = 4398046511104

Execute the following command on each node to make the parameters take effect:

/sbin/sysctl -p

4. Resource limit settings: edit the /etc/security/limits.conf file , add the following content:

oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536

三、Software installation

1. Install Oracle Clusterware: Execute the following command on all nodes:

./runInstaller -silent -responseFile /u01/clusterware/response/grid_install.rsp

During the installation process, you need to select the "Cluster installation" option and specify the name and IP address of each node.

2. Install Oracle Grid Infrastructure: Execute the following command on all nodes:

./runInstaller -silent -responseFile /u01/grid/response/grid_install.rsp

During the installation process, you need to select the "Enterprise Edition install" option and specify the location of the shared storage and the Oracle Inventory (oinstall group) path.

3. Install Oracle Database software: Execute the following command on a node:

./runInstaller -silent -responseFile /u01/database/response/db_install.rsp

During the installation process, you need to select the "Oracle Real Application Clusters database installation" option, specify the location of the shared storage and the Oracle Inventory path, and specify the names of the components and instances to be installed.

4. Cluster settings

1. Create CRS resources: Use crsctl to create CRS resources on any node, for example:

crsctl create resource ora. db -type ora.database.type -file /u01/clusterware/db/db.xml

2. Create an ASM instance: Use srvctl to create an ASM instance on any node, for example:

srvctl add asm -diskstring ' DATA' -asmpassword password

3. Create a database instance: Use dbca to create a database instance on any node. During the creation process, you need to specify the instance name, cluster name, shared storage location and other information.

At this point, the installation and configuration of Oracle 11g RAC is completed. Before starting the entire cluster, you need to ensure that each node can start Oracle Clusterware and Oracle Grid Infrastructure normally. If you find that startup fails or nodes cannot communicate, you need to check whether the network and environment configuration are correct. At the same time, you need to use tools such as crsctl and srvctl to manage the resources and instances of the entire cluster.

The above is the detailed content of oracle 11g rac installation. For more information, please follow other related articles on the PHP Chinese website!