Oracle Database 11g RAC On Oracle Linux 6

Using VirtualBox

 

 

 

东莞Xiaohua 2014/8/05  QQ:54645433

 

所用的软件:

Ｏracle Linux 6 Update 3(64 位)

 

VirtualBox 4.2.0

Ｏracle 11g database 11.2.0.4.0 64位

 Oracle 11g Grid 11.2.0.4 64位

硬件网络图：

 

IP:

#public

192.168.0.201 rac01

192.168.0.202 rac02

#private

192.168.1.1 rac01-prv

192.168.1.2 rac02-prv

#vip

192.168.0.203 rac01-vip

192.168.0.204 rac02-vip

#scan

192.168.0.205 rac-scan

 

具体步骤：

1. 安装虚拟机VirtualBox
2. 在虚拟机上安装Linux 6.3 (硬盘设置３０G,内存4G)，建立节点１,

３.导出虚拟机，

4. 建立节点２,用汇入的方式，再修改下IP,电脑名即可。

５.新增加共享硬盘。

6. 安装Grid.

7.安装Oracle 11g.

 

 

1.安装虚拟机。

1. 

 

 

 

 

 

 

设置二网卡。均设置为桥接的方式。

 

设置ISO文件启动。

2.安装Linux

 

 

 

直至安装完成，

2.1关闭防火墙

 

 

点Disable

点apply

确定

再进去一次确认。

 

2.2关掉selinux & NTP

 

 

将SELINUX=disabled 补上。

 

 

关闭NTP

[root@rac02 rpm]# /sbin/service ntpd status

[root@rac02 rpm]# mv /etc/ntp.conf /etc/ntp.conf.org

ntpd is stopped

2.３修改/etc/hosts

 

vi /etc/hosts

 

192.168.0.201 rac01

192.168.0.202 rac02

192.169.0.1 rac01-prv

192.169.0.2 rac02-prv

192.168.0.203 rac01-vip

192.168.0.204 rac02-vip

192.168.0.205 rac-scan

 

127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4

::1         localhost localhost.localdomain localhost6 localhost6.localdomain6

 

2.４.安装包（用yum）

[root@rac01 ~]# cd /etc/yum.repos.d/

[root@rac01 yum.repos.d]# ll

total 4

-rw-r--r--. 1 root root 1707 Jun 25  2012 public-yum-ol6.repo

[root@rac01 yum.repos.d]# mv public-yum-ol6.repo public-yum-ol6.repo.bak

[root@rac01 yum.repos.d]# vi public-yum-ol6.repo

 

[oel6]

name = Enterprise Linux 6.3 DVD

baseurl=file:///media/OL6.3\ x86_64\ Disc\ 1\ 20120626/Server/

gpgcheck=0

enabled=1

 

 

cd /media/OL6.3\ x86_64\ Disc\ 1\ 20120626/Server/

[root@rac01 Server]# cd Packages/

[root@rac01 Packages]# yum install oracle-rdbms-server-11gR2-preinstall-1.0-6.el6.x86_64.rpm

 

Loaded plugins: refresh-packagekit, security

oel6                                                     | 3.7 kB     00:00 ...

oel6/primary_db                                          | 2.9 MB     00:00 ...

Setting up Install Process

Examining oracle-rdbms-server-11gR2-preinstall-1.0-6.el6.x86_64.rpm: oracle-rdbms-server-11gR2-preinstall-1.0-6.el6.x86_64

Marking oracle-rdbms-server-11gR2-preinstall-1.0-6.el6.x86_64.rpm to be installed

Resolving Dependencies

--> Running transaction check

---> Package oracle-rdbms-server-11gR2-preinstall.x86_64 0:1.0-6.el6 will be installed

--> Processing Dependency: compat-libcap1 for package: oracle-rdbms-server-11gR2-preinstall-1.0-6.el6.x86_64

--> Processing Dependency: compat-libstdc++-33 for package: oracle-rdbms-server-11gR2-preinstall-1.0-6.el6.x86_64

--> Processing Dependency: gcc for package: oracle-rdbms-server-11gR2-preinstall-1.0-6.el6.x86_64

--> Processing Dependency: gcc-c++ for package: oracle-rdbms-server-11gR2-preinstall-1.0-6.el6.x86_64

--> Processing Dependency: glibc-devel for package: oracle-rdbms-server-11gR2-preinstall-1.0-6.el6.x86_64

--> Processing Dependency: ksh for package: oracle-rdbms-server-11gR2-preinstall-1.0-6.el6.x86_64

--> Processing Dependency: libaio-devel for package: oracle-rdbms-server-11gR2-preinstall-1.0-6.el6.x86_64

--> Processing Dependency: libstdc++-devel for package: oracle-rdbms-server-11gR2-preinstall-1.0-6.el6.x86_64

--> Running transaction check

---> Package compat-libcap1.x86_64 0:1.10-1 will be installed

---> Package compat-libstdc++-33.x86_64 0:3.2.3-69.el6 will be installed

---> Package gcc.x86_64 0:4.4.6-4.el6 will be installed

--> Processing Dependency: cpp = 4.4.6-4.el6 for package: gcc-4.4.6-4.el6.x86_64

--> Processing Dependency: cloog-ppl >= 0.15 for package: gcc-4.4.6-4.el6.x86_64

---> Package gcc-c++.x86_64 0:4.4.6-4.el6 will be installed

--> Processing Dependency: libmpfr.so.1()(64bit) for package: gcc-c++-4.4.6-4.el6.x86_64

---> Package glibc-devel.x86_64 0:2.12-1.80.el6 will be installed

--> Processing Dependency: glibc-headers = 2.12-1.80.el6 for package: glibc-devel-2.12-1.80.el6.x86_64

--> Processing Dependency: glibc-headers for package: glibc-devel-2.12-1.80.el6.x86_64

---> Package ksh.x86_64 0:20100621-16.el6 will be installed

---> Package libaio-devel.x86_64 0:0.3.107-10.el6 will be installed

---> Package libstdc++-devel.x86_64 0:4.4.6-4.el6 will be installed

--> Running transaction check

---> Package cloog-ppl.x86_64 0:0.15.7-1.2.el6 will be installed

--> Processing Dependency: libppl.so.7()(64bit) for package: cloog-ppl-0.15.7-1.2.el6.x86_64

--> Processing Dependency: libppl_c.so.2()(64bit) for package: cloog-ppl-0.15.7-1.2.el6.x86_64

---> Package cpp.x86_64 0:4.4.6-4.el6 will be installed

---> Package glibc-headers.x86_64 0:2.12-1.80.el6 will be installed

--> Processing Dependency: kernel-headers >= 2.2.1 for package: glibc-headers-2.12-1.80.el6.x86_64

--> Processing Dependency: kernel-headers for package: glibc-headers-2.12-1.80.el6.x86_64

---> Package mpfr.x86_64 0:2.4.1-6.el6 will be installed

--> Running transaction check

---> Package kernel-headers.x86_64 0:2.6.32-279.el6 will be installed

---> Package ppl.x86_64 0:0.10.2-11.el6 will be installed

--> Finished Dependency Resolution

 

Dependencies Resolved

================================================================================

 Package                              Arch   Version         Repository    Size

================================================================================

Installing:

 oracle-rdbms-server-11gR2-preinstall x86_64 1.0-6.el6       /oracle-rdbms-server-11gR2-preinstall-1.0-6.el6.x86_64

                                                                           32 k

Installing for dependencies:

 cloog-ppl                            x86_64 0.15.7-1.2.el6  oel6          93 k

 compat-libcap1                       x86_64 1.10-1          oel6          17 k

 compat-libstdc++-33                  x86_64 3.2.3-69.el6    oel6         183 k

 cpp                                  x86_64 4.4.6-4.el6     oel6         3.7 M

 gcc                                  x86_64 4.4.6-4.el6     oel6          10 M

 gcc-c++                              x86_64 4.4.6-4.el6     oel6         4.7 M

 glibc-devel                          x86_64 2.12-1.80.el6   oel6         969 k

 glibc-headers                        x86_64 2.12-1.80.el6   oel6         600 k

 kernel-headers                       x86_64 2.6.32-279.el6  oel6         1.9 M

 ksh                                  x86_64 20100621-16.el6 oel6         684 k

 libaio-devel                         x86_64 0.3.107-10.el6  oel6          13 k

 libstdc++-devel                      x86_64 4.4.6-4.el6     oel6         1.5 M

 mpfr                                 x86_64 2.4.1-6.el6     oel6         156 k

 ppl                                  x86_64 0.10.2-11.el6   oel6         1.3 M

 

Transaction Summary

================================================================================

Install      15 Package(s)

 

Total size: 26 M

Total download size: 26 M

Installed size: 61 M

Is this ok [y/N]: y

Downloading Packages:

--------------------------------------------------------------------------------

Total                                           8.1 MB/s |  26 MB     00:03    

Running rpm_check_debug

Running Transaction Test

Transaction Test Succeeded

Running Transaction

  Installing : mpfr-2.4.1-6.el6.x86_64                                     1/15

  Installing : libstdc++-devel-4.4.6-4.el6.x86_64                          2/15

  Installing : cpp-4.4.6-4.el6.x86_64                                      3/15

  Installing : ppl-0.10.2-11.el6.x86_64                                    4/15

  Installing : cloog-ppl-0.15.7-1.2.el6.x86_64                             5/15

  Installing : compat-libstdc++-33-3.2.3-69.el6.x86_64                     6/15

  Installing : libaio-devel-0.3.107-10.el6.x86_64                          7/15

  Installing : kernel-headers-2.6.32-279.el6.x86_64                        8/15

  Installing : glibc-headers-2.12-1.80.el6.x86_64                          9/15

  Installing : glibc-devel-2.12-1.80.el6.x86_64                           10/15

  Installing : gcc-4.4.6-4.el6.x86_64                                     11/15

  Installing : gcc-c++-4.4.6-4.el6.x86_64                                 12/15

  Installing : ksh-20100621-16.el6.x86_64                                 13/15

  Installing : compat-libcap1-1.10-1.x86_64                               14/15

  Installing : oracle-rdbms-server-11gR2-preinstall-1.0-6.el6.x86_64      15/15

  Verifying  : compat-libcap1-1.10-1.x86_64                                1/15

  Verifying  : ksh-20100621-16.el6.x86_64                                  2/15

  Verifying  : kernel-headers-2.6.32-279.el6.x86_64                        3/15

  Verifying  : glibc-devel-2.12-1.80.el6.x86_64                            4/15

  Verifying  : libaio-devel-0.3.107-10.el6.x86_64                          5/15

  Verifying  : gcc-4.4.6-4.el6.x86_64                                      6/15

  Verifying  : oracle-rdbms-server-11gR2-preinstall-1.0-6.el6.x86_64       7/15

  Verifying  : gcc-c++-4.4.6-4.el6.x86_64                                  8/15

  Verifying  : libstdc++-devel-4.4.6-4.el6.x86_64                          9/15

  Verifying  : compat-libstdc++-33-3.2.3-69.el6.x86_64                    10/15

  Verifying  : glibc-headers-2.12-1.80.el6.x86_64                         11/15

  Verifying  : mpfr-2.4.1-6.el6.x86_64                                    12/15

  Verifying  : cpp-4.4.6-4.el6.x86_64                                     13/15

  Verifying  : ppl-0.10.2-11.el6.x86_64                                   14/15

  Verifying  : cloog-ppl-0.15.7-1.2.el6.x86_64                            15/15

 

Installed:

  oracle-rdbms-server-11gR2-preinstall.x86_64 0:1.0-6.el6                      

 

Dependency Installed:

  cloog-ppl.x86_64 0:0.15.7-1.2.el6                                            

  compat-libcap1.x86_64 0:1.10-1                                               

  compat-libstdc++-33.x86_64 0:3.2.3-69.el6                                    

  cpp.x86_64 0:4.4.6-4.el6                                                     

  gcc.x86_64 0:4.4.6-4.el6                                                     

  gcc-c++.x86_64 0:4.4.6-4.el6                                                 

  glibc-devel.x86_64 0:2.12-1.80.el6                                           

  glibc-headers.x86_64 0:2.12-1.80.el6                                         

  kernel-headers.x86_64 0:2.6.32-279.el6                                       

  ksh.x86_64 0:20100621-16.el6                                                 

  libaio-devel.x86_64 0:0.3.107-10.el6                                          

  libstdc++-devel.x86_64 0:4.4.6-4.el6                                         

  mpfr.x86_64 0:2.4.1-6.el6                                                    

  ppl.x86_64 0:0.10.2-11.el6                                                    

 

Complete!

 

2.５.修改/etc/security/limits.conf、

[root@rac01 Packages]# vi /etc/security/limits.conf

 

# /etc/security/limits.conf

#

#Each line describes a limit for a user in the form:

#           

#Where:

# can be:

#        - an user name

#        - a group name, with @group syntax

#        - the wildcard *, for default entry

#        - the wildcard %, can be also used with %group syntax,

#                 for maxlogin limit

# can have the two values:

#        - "soft" for enforcing the soft limits

#        - "hard" for enforcing hard limits

# can be one of the following:

#        - core - limits the core file size (KB)

#        - data - max data size (KB)

#        - fsize - maximum filesize (KB)

#        - memlock - max locked-in-memory address space (KB)

#        - nofile - max number of open files

#        - rss - max resident set size (KB)

#        - stack - max stack size (KB)

#        - cpu - max CPU time (MIN)

#        - nproc - max number of processes

#        - as - address space limit (KB)

#        - maxlogins - max number of logins for this user

#        - maxsyslogins - max number of logins on the system

#        - priority - the priority to run user process with

#        - locks - max number of file locks the user can hold

#        - sigpending - max number of pending signals

#        - msgqueue - max memory used by POSIX message queues (bytes)

#        - nice - max nice priority allowed to raise to values: [-20, 19]

#        - rtprio - max realtime priority

#                

 

#*               soft    core            0

#*               hard    rss             10000

#@student        hard    nproc           20

#@faculty        soft    nproc           20

#@faculty        hard    nproc           50

#ftp             hard    nproc           0

#@student        -       maxlogins       4

# End of file

 

# oracle-rdbms-server-11gR2-preinstall setting for nofile soft limit is 1024

oracle   soft   nofile    1024

 

# oracle-rdbms-server-11gR2-preinstall setting for nofile hard limit is 65536

oracle   hard   nofile    65536

 

# oracle-rdbms-server-11gR2-preinstall setting for nproc soft limit is 2047

oracle   soft   nproc    2047

 

# oracle-rdbms-server-11gR2-preinstall setting for nproc hard limit is 16384

oracle   hard   nproc    16384

 

# oracle-rdbms-server-11gR2-preinstall setting for stack soft limit is 10240KB

oracle   soft   stack    10240

 

# oracle-rdbms-server-11gR2-preinstall setting for stack hard limit is 32768KB

oracle   hard   stack    32768

 

# grid

grid   soft   nofile    1024

grid   hard   nofile    65536

grid   soft   nproc    2047

grid   hard   nproc    1638

grid   soft   stack    10240

grid   hard   stack    32768

 

"/etc/security/limits.conf" 70L, 2652C written