Entire Process of Oracle10g RAC for Linux Configuration

This document is about installing and configuring Oracle10g RAC on RedHat Advance Server 3.0. It is not only an installation test, but also an actual layout process of the production system. Therefore, it includes RAC installation, local listening configuration, JDBC connection string writing, CRS service re-installation, VIP address modification, and so on, I believe it is more useful than general installation tutorials.

1. installation environment
Hardware Platform: Two HP 380 PC servers.
Host Hostname ip vip name
Node 1 dbtest1 192.168.100.201 10.96.100.103 db-vip01
Node2 dbtest2 192.168.100.203 10.96.100.104 db-vip02

Operating System: RedHat Enterprise Linux 3.0 Update 5.
Disk Array: HP ms1000.
Database: Oracle10g 10.1.0.3.
2. install Linux
Required kernel:
2.4.21-4.EL or later
Verify the kernel version:
# Uname-r
2.4.21-32. ELsmp
Version of other required packages (or later ):
Make-3.79
Binutils-2.11.90.0.8-12
Gcc-3.2.3-2
Compat-db-4.0.14.5
Compat-gcc-7.3-2.96.122
Compat-gcc-c ++-7.3-2.96.122
Compat-libstdc ++-7.3-2.96.122
Compat-libstdc ++ devel-7.3-2.96.122
Openmotif21-2.1.30-8
Setarch-1.3-1
Verify the installed package:
# Rpm-qa make binutils gcc compat-db compat-gcc-c ++ compat-libstdc ++
Compat-libstdc ++-devel openmotif setarch
Make-3.79.1-17
Binutils-2.14.90.0.4-26
Gcc-3.2.3-20
Compat-db-4.0.14-5
Compat-gcc-7.3-2.96.122
Compat-gcc-c ++-7.3-2.96.122
Compat-libstdc ++-7.3-2.96.122
Compat-libstdc ++ devel-7.3-2.96.122
Openmotif-2.2.2-16
Setarch-1.3-1
3. Configure Linux for Oracle
Create an Oracle group and User Account
Next, we will create a Linux Group and user account for installing and maintaining the Oracle 10g software. The User Account Name Is 'oracle ', and the group is 'osinstall' and 'dba '. Run the following command as the root user on drpdb01:
/Usr/sbin/groupadd oinstall
/Usr/sbin/groupadd dba
/Usr/sbin/useradd-m-g oinstall-G dba oracle
Id oracle
Uid = 500 (oracle) gid = 500 (oinstall) groups = 500 (oinstall), 501 (dba)
The user ID and group ID must be the same on all cluster hosts. Create an oracle group and user account on drpdb02 using the information obtained from the id Oracle command:
/Usr/sbin/groupadd-g 500 oinstall
/Usr/sbin/groupadd-g 501 dba
/Usr/sbin/useradd-m-u 500-g oinstall-G dba oracle
Id oracle
Uid = 500 (oracle) gid = 500 (oinstall) groups = 500 (oinstall), 501 (dba)
Set the password for the oracle account:
# Passwd oracle
Changing password for user oracle.
New password:
Retype new password:
Passwd: all authentication tokens updated successfully.
Create a mount point

Now create a mount point that stores the Oracle 10g software.
Run the following command as the root user:
# Mkdir-p/u01/app/oracle
# Chown-R oracle: oinstall/u01/app/oracle
# Chmod-R 775/u01/app/oracle
Configure Kernel Parameters

Log on as a root user and configure Linux Kernel Parameters on each host.
Cat>/etc/sysctl. conf> EOF
Kernel. shmall = 2097152
Kernel. shmmax = 2147483648
Kernel. shmmni = 4096
Kernel. sem = 250 32000 100 128
Kernel. threads-max = 131072
Fs. file-max = 131072
Net. ipv4.ip _ local_port_range = 1024 65000
Net. core. rmem_default = 262144
Net. core. wmem_default = 262144
Net. core. rmem_max = 262144
Net. core. wmem_max = 262144
EOF
/Sbin/sysctl-p
Set Shell restrictions for oracle users

We recommend that you set a limit on the number of processes that each Linux Account can use and the number of files opened.

Cat>/etc/security/limits. conf> EOF
Oracle soft nproc 2047
Hard nproc 16384
Oracle soft nofile 1024
Oracle hard nofile 65536
EOF

Cat>/etc/pam. d/login> EOF
Session required/lib/security/pam_limits.so
EOF

Cat>/etc/profile> EOF
If [$ USER = "oracle"]; then
If [$ SHELL = "/bin/ksh"]; then
Ulimit-p 16384
Ulimit-n 65536
Else
Ulimit-u 16384-n 65536
Fi
Umask 022
Fi
EOF

Cat>/etc/csh. login> EOF
If ($ USER = "oracle") then
Limit maxproc 16384
Limit descriptors 65536
Umask 022
Endif
EOF
Configure the Hangcheck Timer
Modprobe hangcheck-timer hangcheck_tick = 30 hangcheck_margin = 180
Cat>/etc/rc. d/rc. local> EOF
Modprobe hangcheck-timer hangcheck_tick = 30 hangcheck_margin = 180
EOF
Configure/etc/hosts
In some Linux distributions, the host name is associated with the return address (127.0.0.1. In this case, the host name is deleted from the return address. This installation has been modified.
The/etc/hosts file used in this Guide:
127.0.0.1 localhost. localdomain localhost
192.168.100.201 dbtest1 dbtest1
192.168.100.203 dbtest2 dbtest2
192.168.200.1 dbtest1-priv dbtest1-priv
192.168.200.2 dbtest2-priv dbtest2-priv
192.168.100.202 dbtest1-vip dbtest1-vip
192.168.100.204 dbtest2-vip dbtest2-vip
~ Configure SSH for user equivalence
During Oracle RAC 10g installation, OUI needs to copy files to other hosts in the cluster and execute programs on them. To allow OUI to complete this task, you must configure SSH to enable user equivalence. Using SSH to establish user equivalence provides a safe way to copy files and execute programs on other hosts in the cluster without requiring a password prompt.
The first step is to generate the SSH public key and private key. The SSH protocol has two versions. Version 1 uses RSA and Version 2 uses DSA, so we will create these two types of keys to ensure that SSH can use any version. The ssh-keygen program generates any type of public key and private key based on the parameters passed to it.

1 2 3 4 5 6 Next Page