RHEL 5.3 installation of Oracle 11g RAC on the Single Node

Starting to test Oracle 11g RAC, the current performance is limited, so a single node RAC is installed. The procedure is as follows:

Nic binding

Modify ifcfg-bond * ifcfg-eth * in/etc/modprobe. conf and/etc/sysconfig/network-scripts *

I will not talk more here

Configure xmanager connection

VI/usr/share/TPD/defaults. conf

Change enable = false under [XDMCP] to enable = true.

Change allowremoteroot = false to allowremoteroot = true

Make it take effect:

TPD-Restart

Check whether the required package is installed in the system.

List of packages to be installed:

 

Binutils-2.15.92.0.2
Compat-libstdc ++-33-3.2.3
Compat-libstdc ++-33-3.2.3 (32 bit)
Elfutils-libelf-0.97
Elfutils-libelf-devel-0.97
Expat-1.95.7
Gcc-3.4.6
Gcc-C ++-3.4.6
Glibc-2.3.4-2.41
Glibc-2.3.4-2.41 (32 bits)
Glibc-common-2.3.4
Glibc-devel-2.3.4
Glibc-headers-2.3.4
Libaio-0.3.105
Libaio-0.3.105 (32 bits)
Libaio-devel-0.3.105
Libaio-devel-0.3.105 (32 bits)
Libgcc-3.4.6
Libgcc-3.4.6 (32-bits)
Libstdc ++-3.4.6
Libstdc ++-3.4.6 (32 bit)
Libstdc ++-devel 3.4.6
Make-3.80
Pdksh-5.2.14
Sysstat-5.0.5
UnixODBC-2.2.11
UnixODBC-2.2.11 (32 bits)
UnixODBC-devel-2.2.11
UnixODBC-devel-2.2.11 (32 bits)

 

Rpm-Q -- qf' % {name}-% {version}-% {release} (% {arch}) \ n' binutils \
Compat-libstdc ++-33 \
Elfutils-libelf \
Elfutils-libelf-devel \
GCC \
Gcc-C ++ \
Glibc \
Glibc-common \
Glibc-devel \
Glibc-headers \
Ksh \
Libaio \
Libaio-devel \
Libgcc \
Libstdc ++ \
Libstdc ++-devel \
Make \
Sysstat \
Unixodbc \
Unixodbc-devel

Create several user groups

Groupadd-G 1000 oinstall

Groupadd-G 1020 asmadmin

Groupadd-G 1021 asmdba

Groupadd-G 1031 DBA

Groupadd-G 1022 asmoper

 

Create user

Useradd-u 1100-G oinstall-G asmadmin, asmdba Grid

Useradd-u 1101-G oinstall-G dBA, asmdba Oracle

 

Passwd Oracle

Passwd Grid

 

Modify Environment Variables

 

cat>>/home/grid/.bashrc<<EOFif [ -t 0 ]; thenstty intr ^Cfiexport ORACLE_BASE=/opt/app/oracleexport ORACLE_HOME=/opt/app/11.2.0/gridexport ORACLE_SID=+ASM1export PATH=\$ORACLE_HOME/bin:\$PATHumask 022EOF

cat>>/home/oracle/.bashrc<<EOFif [ -t 0 ]; thenstty intr ^Cfiexport ORACLE_BASE=/opt/app/oracleexport ORACLE_HOME=/opt/app/oracle/product/11.2.0/db_1export ORACLE_SID=oradb1export PATH=\$ORACLE_HOME/bin:\$PATHumask 022EOF

cat>>/root/.bashrc<<EOFexport PATH=/opt/app/11.2.0/grid/bin:/opt/app/oracle/product/11.2.0/db_1/bin:\$PATHEOF

Configure the network to modify the/etc/hosts file (according to the actual situation)

cat>/etc/hosts<<EOF# Do not remove the following line, or various programs# that require network functionality will fail.127.0.0.1       localhost.localdomain   localhost# Public Network - (eth0,eth1---bond0)192.168.77.241  rac  rac.wildwave.com# Private Interconnect - (eth2,eth3-bond1)10.10.10.241    rac-priv# Public Virtual IP (VIP) addresses for - (eth0,eth1---bond0)192.168.77.243  rac-vipEOF

Configure DNS server configuration modification/etc/named. conf file

cd /var/named/chroot/etccat> named.conf<<EOFoptions {        listen-on port 53 { any; };        listen-on-v6 port 53 { ::1; };        directory       "/var/named";        dump-file       "/var/named/data/cache_dump.db";        statistics-file "/var/named/data/named_stats.txt";        memstatistics-file "/var/named/data/named_mem_stats.txt";         // Those options should be used carefully because they disable port        // randomization        // query-source    port 53;        // query-source-v6 port 53;         allow-query     { 192.168.77.0/24; };        };logging {        channel default_debug {                file "data/named.run";                severity dynamic;        };};view localhost_resolver {        match-clients      { 192.168.77.0/24; };        match-destinations { any; };        recursion yes;        include "/etc/named.rfc1912.zones";};controls {      inet 127.0.0.1 allow { localhost; } keys { "rndckey"; };};include "/etc/rndc.key";EOFcat> named.rfc1912.zones<<EOFzone "." IN {        type hint;        file "named.ca";};zone "wildwave.com" IN {        type master;        file "wildwave.zone";        allow-update { none; };}; zone "77.168.192.in-addr.arpa" IN {        type master;        file "named.wildwave";        allow-update { none; };};EOF

Modify files under/var/named/

cd /var/named/chroot/var/named/cat>named.ca<<EOF;       This file holds the information on root name servers needed to;       initialize cache of Internet domain name servers;       (e.g. reference this file in the "cache  .  <file>";       configuration file of BIND domain name servers).;;       This file is made available by InterNIC ;       under anonymous FTP as;           file                /domain/named.cache;           on server           FTP.INTERNIC.NET;       -OR-                    RS.INTERNIC.NET;;       last update:    Jun 17, 2010;       related version of root zone:   2010061700;; formerly NS.INTERNIC.NET;.                        3600000  IN  NS    A.ROOT-SERVERS.NET.A.ROOT-SERVERS.NET.      3600000      A     198.41.0.4A.ROOT-SERVERS.NET.      3600000      AAAA  2001:503:BA3E::2:30;; FORMERLY NS1.ISI.EDU;.                        3600000      NS    B.ROOT-SERVERS.NET.B.ROOT-SERVERS.NET.      3600000      A     192.228.79.201;; FORMERLY C.PSI.NET;.                        3600000      NS    C.ROOT-SERVERS.NET.C.ROOT-SERVERS.NET.      3600000      A     192.33.4.12;; FORMERLY TERP.UMD.EDU;.                        3600000      NS    D.ROOT-SERVERS.NET.D.ROOT-SERVERS.NET.      3600000      A     128.8.10.90;; FORMERLY NS.NASA.GOV;.                        3600000      NS    E.ROOT-SERVERS.NET.E.ROOT-SERVERS.NET.      3600000      A     192.203.230.10;; FORMERLY NS.ISC.ORG;.                        3600000      NS    F.ROOT-SERVERS.NET.F.ROOT-SERVERS.NET.      3600000      A     192.5.5.241F.ROOT-SERVERS.NET.      3600000      AAAA  2001:500:2F::F;; FORMERLY NS.NIC.DDN.MIL;.                        3600000      NS    G.ROOT-SERVERS.NET.G.ROOT-SERVERS.NET.      3600000      A     192.112.36.4;; FORMERLY AOS.ARL.ARMY.MIL;.                        3600000      NS    H.ROOT-SERVERS.NET.H.ROOT-SERVERS.NET.      3600000      A     128.63.2.53H.ROOT-SERVERS.NET.      3600000      AAAA  2001:500:1::803F:235;; FORMERLY NIC.NORDU.NET;.                        3600000      NS    I.ROOT-SERVERS.NET.I.ROOT-SERVERS.NET.      3600000      A     192.36.148.17I.ROOT-SERVERS.NET.      3600000      AAAA  2001:7FE::53;; OPERATED BY VERISIGN, INC.;.                        3600000      NS    J.ROOT-SERVERS.NET.J.ROOT-SERVERS.NET.      3600000      A     192.58.128.30J.ROOT-SERVERS.NET.      3600000      AAAA  2001:503:C27::2:30;; OPERATED BY RIPE NCC;.                        3600000      NS    K.ROOT-SERVERS.NET.K.ROOT-SERVERS.NET.      3600000      A     193.0.14.129K.ROOT-SERVERS.NET.      3600000      AAAA  2001:7FD::1;; OPERATED BY ICANN;.                        3600000      NS    L.ROOT-SERVERS.NET.L.ROOT-SERVERS.NET.      3600000      A     199.7.83.42L.ROOT-SERVERS.NET.      3600000      AAAA  2001:500:3::42;; OPERATED BY WIDE;.                        3600000      NS    M.ROOT-SERVERS.NET.M.ROOT-SERVERS.NET.      3600000      A     202.12.27.33M.ROOT-SERVERS.NET.      3600000      AAAA  2001:DC3::35; End of FileEOF

Forward parsing:

cd /var/named/chroot/var/named/cat>wildwave.zone<<EOF\$TTL    86400@       IN  SOA  rac.wildwave.com.       root.wildwave.com. (                                        2010022101    ; serial (d. adams)                                        3H           ; refresh                                        15M          ; retry                                        1W           ; expiry                                        1D )          ; minimum @               IN NS        rac.wildwave.com.rac             IN A         192.168.77.241rac-vip          IN A         192.168.77.243rac-scan          IN A         192.168.77.245rac-scan          IN A         192.168.77.246rac-scan          IN A         192.168.77.247EOF

Reverse Resolution:

cd /var/named/chroot/var/named/cat>named.wildwave<<EOF\$TTL    86400@      IN      SOA     rac.wildwave.com.   root.wildwave.com.  (                                      2010022101 ; Serial                                      28800           ; Refresh                                      14400           ; Retry                                      3600000       ; Expire                                      86400 )         ; Minimum@       IN     NS      rac.wildwave.com.241     IN     PTR      rac.wildwave.com.243     IN     PTR      rac-vip.wildwave.com.245     IN     PTR      rac-scan.wildwave.com.246     IN     PTR      rac-scan.wildwave.com.247     IN     PTR      rac-scan.wildwave.com.EOF

Chkconfig named on

Service named restart

Client Configuration

Cat>/etc/resolv. conf <EOF

Nameserver 192.168.77.241

EOF

 

VI/etc/nsswitch. conf

Hosts: Files DNS

Order changed

Hosts: DNS files

Ctss for Time Synchronization

In this experiment, we use ctss

 

Stop NTP Time Synchronization

 

/Etc/init. d/ntpd stop

 

Chkconfig ntpd off

MV/etc/NTP. CONF/etc/ntp.conf.org

 

 

 

Use NTP

 

Chkconfig ntpd on

 

VI/etc/sysconfig/ntpd

 

# Drop root to ID 'ntp: NTP 'by default.

Options = "-X-u NTP: NTP-P/var/run/ntpd. PID"

# Set to 'yes' to sync HW clock aftersuccessful ntpdate

Sync_hwclock = No

# Additional options for ntpdate

Ntpdate_options = ""

Then, restart the NTP service.

/Sbin/service ntpd restart

Configure Kernel Parameters

cat>>/etc/sysctl.conf <<EOFkernel.shmmax = 4294967295 kernel.shmall = 2097152kernel.shmmni = 4096kernel.sem = 250 32000 100 128fs.file-max = 6815744net.ipv4.ip_local_port_range = 9000 65500net.core.rmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048576fs.aio-max-nr=1048576EOF

Modify resource limits

cat>>/etc/security/limits.conf<<EOFgrid soft nproc 2047grid hard nproc 16384grid soft nofile 1024grid hard nofile 65536oracle soft nproc 2047oracle hard nproc 16384oracle soft nofile 1024oracle hard nofile 65536EOFecho "session required pam_limits.so">>/etc/pam.d/logincat>>/etc/profile<<EOF if [ \$USER = \"oracle\" ] || [ $USER = \"grid\" ]; thenif [ \$SHELL = \"/bin/ksh\" ]; thenulimit -p 16384ulimit -n 65536elseulimit -u 16384 -n 65536fiumask 022fiEOF

Create related directories

mkdir -p /opt/app/oraInventorychown -R grid:oinstall /opt/app/oraInventorychmod -R 775 /opt/app/oraInventorymkdir -p /opt/app/11.2.0/gridchown -R grid:oinstall /opt/app/11.2.0/gridchmod -R 775 /opt/app/11.2.0/gridmkdir -p /opt/app/oraclemkdir /opt/app/oracle/cfgtoollogs chown -R oracle:oinstall /opt/app/oraclechmod -R 775 /opt/app/oraclemkdir -p /opt/app/oracle/product/11.2.0/db_1chown -R oracle:oinstall /opt/app/oracle/product/11.2.0/db_1chmod -R 775 /opt/app/oracle/product/11.2.0/db_1

Install and configure asmlib

Rpm-IVH oracleasm-support-2.1.7-1.el5.i386.rpm \
Oracleasmlib-2.0.4-1.el5.i386.rpm \
Oracleasm-2.6.18-128.el5-2.0.5-1.el5.i686.rpm

/Etc/init. d/oracleasm configure

 

Default User to own the driver interface []:
Grid
Default group to own the driver interface []:
Asmadmin
Start Oracle ASM library driver on boot (y/n) [N]: Y
Scan for Oracle ASM disks on boot (y/n) [y]: Y
Writing Oracle ASM library driverconfiguration: Done
Initializing the Oracle asmlib DRIVER: [OK]
Scanning the system for Oracle asmlibdisks: [OK]
 

Add asmdisk

/Usr/sbin/oracleasm createdisk disk1/dev/sdc1

/Usr/sbin/oracleasm createdisk disk2/dev/sdc2

/Usr/sbin/oracleasm createdisk disk3/dev/sdc3

/Usr/sbin/oracleasm createdisk disk4/dev/sdc4

/Usr/sbin/oracleasm scandisks

/Usr/sbin/oracleasm listdisks

Install the cvuqdisk package

 

Install this package under rpm in the grid installation directory

 

[Root @ rac rpm] #Rpm-IVH cvuqdisk-1.0.9-1.rpm

Preparing... ######################################## ### [100%]

Using default group oinstall to installpackage

1: cvuqdisk ####################################### #### [100%]

If the owner of cvuqdisk is not oinstall, you must set the value of the environment variable cvuqdisk_grp to this user group.

Install grid infrastructure

Log on to the grid user and run runinstaller to install

Add the cluster name and scan name to the name of the scan IP address configured on the DNS server.

Creates an ASM disk group for storing OCR and vote. The redundancy is normal three times, and high is five times.

Install RDBMS

Create a database