使用UDEV在Oracle Linux 6上安装Oracle 11g RAC(11.2.0.3) (二)

来源:互联网 发布:mac的appstore打不开 编辑:程序博客网 时间:2024/04/26 16:56

使用UDEV在Oracle Linux 6上安装Oracle 11g RAC(11.2.0.3) (一)


在所有node上创建oracle,grid用户,创建相关目录

  1. [root@node2 ~]# groupadd -g 1000 oinstall   
  2. [root@node2 ~]# groupadd -g 1200 asmadmin  
  3. [root@node2 ~]# groupadd -g 1201 asmdba   
  4. [root@node2 ~]# groupadd -g 1202 asmoper   
  5. [root@node2 ~]# useradd -m -u 1100 -g oinstall -G asmadmin,asmdba,asmoper -d /home/grid -s /bin/bash -c "Grid Infrastructure Owner" grid  
  6. [root@node2 ~]# groupadd -g 1300 dba  
  7. [root@node2 ~]# groupadd -g 1301 oper  
  8. [root@node2 ~]# useradd -m -u 1101 -g oinstall -G dba,oper,asmdba -d /home/oracle -s /bin/bash -c "Oracle Software Owner" oracle  
  9. [root@node2 ~]# mkdir -p /u01/app/grid  
  10. [root@node2 ~]# mkdir -p /u01/app/11.2.0/grid  
  11. [root@node2 ~]# chown -R grid:oinstall /u01  
  12. [root@node2 ~]# mkdir -p /u01/app/oracle  
  13. [root@node2 ~]# chown oracle:oinstall /u01/app/oracle  
  14. [root@node2 ~]# chmod -R 775 /u01  
  15. [root@node2 ~]# passwd oracle  
  16. Changing password for user oracle.  
  17. New password:   
  18. BAD PASSWORD: it is based on a dictionary word  
  19. BAD PASSWORD: is too simple  
  20. Retype new password:   
  21. passwd: all authentication tokens updated successfully.  
  22. [root@node2 ~]# passwd grid  
  23. Changing password for user grid.  
  24. New password:   
  25. BAD PASSWORD: it is too short  
  26. BAD PASSWORD: is too simple  
  27. Retype new password:   
  28. passwd: all authentication tokens updated successfully.  
  29. [root@node2 ~]# id oracle -a  
  30. uid=1101(oracle) gid=1000(oinstall) groups=1000(oinstall),1201(asmdba),1300(dba),1301(oper)  
  31. [root@node2 ~]# id grid -a  
  32. uid=1100(grid) gid=1000(oinstall) groups=1000(oinstall),1200(asmadmin),1201(asmdba),1202(asmoper)  


安装相关rpm包,配置系统内核参数,这里我使用的是OL6提供的oracle-rdbms-server-11gR2-preinstall

  1. [root@node2 ~]# yum -y install oracle-rdbms-server-11gR2-preinstall  
  2. Loaded plugins: refresh-packagekit, security  
  3. ol6_UEK_latest                                                                                                                                  | 1.2 kB     00:00       
  4. ol6_UEK_latest/primary                                                                                                                          | 5.0 MB     00:14       
  5. ol6_UEK_latest                                                                                                                                                 120/120  
  6. ol6_latest                                                                                                                                      | 1.4 kB     00:00       
  7. ol6_latest/primary                                                                                                                              |  24 MB     01:07       
  8. ol6_latest                                                                                                                                                 18391/18391  
  9. Setting up Install Process  
  10. Resolving Dependencies  
  11. --> Running transaction check  
  12. ---> Package oracle-rdbms-server-11gR2-preinstall.x86_64 0:1.0-6.el6 will be installed  
  13. --> Processing Dependency: gcc-c++ for package: oracle-rdbms-server-11gR2-preinstall-1.0-6.el6.x86_64  
  14. --> Processing Dependency: gcc for package: oracle-rdbms-server-11gR2-preinstall-1.0-6.el6.x86_64  
  15. --> Processing Dependency: libaio-devel for package: oracle-rdbms-server-11gR2-preinstall-1.0-6.el6.x86_64  
  16. --> Processing Dependency: libstdc++-devel for package: oracle-rdbms-server-11gR2-preinstall-1.0-6.el6.x86_64  
  17. --> Processing Dependency: glibc-devel for package: oracle-rdbms-server-11gR2-preinstall-1.0-6.el6.x86_64  
  18. --> Processing Dependency: compat-libstdc++-33 for package: oracle-rdbms-server-11gR2-preinstall-1.0-6.el6.x86_64  
  19. --> Processing Dependency: ksh for package: oracle-rdbms-server-11gR2-preinstall-1.0-6.el6.x86_64  
  20. --> Processing Dependency: compat-libcap1 for package: oracle-rdbms-server-11gR2-preinstall-1.0-6.el6.x86_64  
  21. --> Running transaction check  
  22. ---> Package compat-libcap1.x86_64 0:1.10-1 will be installed  
  23. ---> Package compat-libstdc++-33.x86_64 0:3.2.3-69.el6 will be installed  
  24. ---> Package gcc.x86_64 0:4.4.6-4.el6 will be installed  
  25. --> Processing Dependency: cpp = 4.4.6-4.el6 for package: gcc-4.4.6-4.el6.x86_64  
  26. --> Processing Dependency: cloog-ppl >= 0.15 for package: gcc-4.4.6-4.el6.x86_64  
  27. ---> Package gcc-c++.x86_64 0:4.4.6-4.el6 will be installed  
  28. --> Processing Dependency: libmpfr.so.1()(64bit) for package: gcc-c++-4.4.6-4.el6.x86_64  
  29. ---> Package glibc-devel.x86_64 0:2.12-1.80.el6_3.6 will be installed  
  30. --> Processing Dependency: glibc-headers = 2.12-1.80.el6_3.6 for package: glibc-devel-2.12-1.80.el6_3.6.x86_64  
  31. --> Processing Dependency: glibc = 2.12-1.80.el6_3.6 for package: glibc-devel-2.12-1.80.el6_3.6.x86_64  
  32. --> Processing Dependency: glibc-headers for package: glibc-devel-2.12-1.80.el6_3.6.x86_64  
  33. ---> Package ksh.x86_64 0:20100621-16.el6 will be installed  
  34. ---> Package libaio-devel.x86_64 0:0.3.107-10.el6 will be installed  
  35. ---> Package libstdc++-devel.x86_64 0:4.4.6-4.el6 will be installed  
  36. --> Running transaction check  
  37. ---> Package cloog-ppl.x86_64 0:0.15.7-1.2.el6 will be installed  
  38. --> Processing Dependency: libppl_c.so.2()(64bit) for package: cloog-ppl-0.15.7-1.2.el6.x86_64  
  39. --> Processing Dependency: libppl.so.7()(64bit) for package: cloog-ppl-0.15.7-1.2.el6.x86_64  
  40. ---> Package cpp.x86_64 0:4.4.6-4.el6 will be installed  
  41. ---> Package glibc.x86_64 0:2.12-1.80.el6 will be updated  
  42. --> Processing Dependency: glibc = 2.12-1.80.el6 for package: glibc-common-2.12-1.80.el6.x86_64  
  43. ---> Package glibc.x86_64 0:2.12-1.80.el6_3.6 will be an update  
  44. ---> Package glibc-headers.x86_64 0:2.12-1.80.el6_3.6 will be installed  
  45. --> Processing Dependency: kernel-headers >= 2.2.1 for package: glibc-headers-2.12-1.80.el6_3.6.x86_64  
  46. --> Processing Dependency: kernel-headers for package: glibc-headers-2.12-1.80.el6_3.6.x86_64  
  47. ---> Package mpfr.x86_64 0:2.4.1-6.el6 will be installed  
  48. --> Running transaction check  
  49. ---> Package glibc-common.x86_64 0:2.12-1.80.el6 will be updated  
  50. ---> Package glibc-common.x86_64 0:2.12-1.80.el6_3.6 will be an update  
  51. ---> Package kernel-uek-headers.x86_64 0:2.6.32-300.39.2.el6uek will be installed  
  52. ---> Package ppl.x86_64 0:0.10.2-11.el6 will be installed  
  53. --> Finished Dependency Resolution  
  54.   
  55. Dependencies Resolved  
  56.   
  57. =======================================================================================================================================================================  
  58.  Package                                                  Arch                       Version                                      Repository                      Size  
  59. =======================================================================================================================================================================  
  60. Installing:  
  61.  oracle-rdbms-server-11gR2-preinstall                     x86_64                     1.0-6.el6                                    ol6_latest                      15 k  
  62. Installing for dependencies:  
  63.  cloog-ppl                                                x86_64                     0.15.7-1.2.el6                               ol6_latest                      93 k  
  64.  compat-libcap1                                           x86_64                     1.10-1                                       ol6_latest                      17 k  
  65.  compat-libstdc++-33                                      x86_64                     3.2.3-69.el6                                 ol6_latest                     183 k  
  66.  cpp                                                      x86_64                     4.4.6-4.el6                                  ol6_latest                     3.7 M  
  67.  gcc                                                      x86_64                     4.4.6-4.el6                                  ol6_latest                      10 M  
  68.  gcc-c++                                                  x86_64                     4.4.6-4.el6                                  ol6_latest                     4.7 M  
  69.  glibc-devel                                              x86_64                     2.12-1.80.el6_3.6                            ol6_latest                     970 k  
  70.  glibc-headers                                            x86_64                     2.12-1.80.el6_3.6                            ol6_latest                     600 k  
  71.  kernel-uek-headers                                       x86_64                     2.6.32-300.39.2.el6uek                       ol6_latest                     716 k  
  72.  ksh                                                      x86_64                     20100621-16.el6                              ol6_latest                     684 k  
  73.  libaio-devel                                             x86_64                     0.3.107-10.el6                               ol6_latest                      13 k  
  74.  libstdc++-devel                                          x86_64                     4.4.6-4.el6                                  ol6_latest                     1.5 M  
  75.  mpfr                                                     x86_64                     2.4.1-6.el6                                  ol6_latest                     156 k  
  76.  ppl                                                      x86_64                     0.10.2-11.el6                                ol6_latest                     1.3 M  
  77. Updating for dependencies:  
  78.  glibc                                                    x86_64                     2.12-1.80.el6_3.6                            ol6_latest                     3.8 M  
  79.  glibc-common                                             x86_64                     2.12-1.80.el6_3.6                            ol6_latest                      14 M  
  80.   
  81. Transaction Summary  
  82. =======================================================================================================================================================================  
  83. Install      15 Package(s)  
  84. Upgrade       2 Package(s)  
  85.   
  86. Total download size: 43 M  
  87. Downloading Packages:  
  88. (1/17): cloog-ppl-0.15.7-1.2.el6.x86_64.rpm                                                                                                     |  93 kB     00:00       
  89. (2/17): compat-libcap1-1.10-1.x86_64.rpm                                                                                                        |  17 kB     00:00       
  90. (3/17): compat-libstdc++-33-3.2.3-69.el6.x86_64.rpm                                                                                             | 183 kB     00:00       
  91. (4/17): cpp-4.4.6-4.el6.x86_64.rpm                                                                                                              | 3.7 MB     00:12       
  92. (5/17): gcc-4.4.6-4.el6.x86_64.rpm                                                                                                              |  10 MB     00:28       
  93. (6/17): gcc-c++-4.4.6-4.el6.x86_64.rpm                                                                                                          | 4.7 MB     00:13       
  94. (7/17): glibc-2.12-1.80.el6_3.6.x86_64.rpm                                                                                                      | 3.8 MB     00:10       
  95. (8/17): glibc-common-2.12-1.80.el6_3.6.x86_64.rpm                                                                                               |  14 MB     00:40       
  96. (9/17): glibc-devel-2.12-1.80.el6_3.6.x86_64.rpm                                                                                                | 970 kB     00:02       
  97. (10/17): glibc-headers-2.12-1.80.el6_3.6.x86_64.rpm                                                                                             | 600 kB     00:02       
  98. (11/17): kernel-uek-headers-2.6.32-300.39.2.el6uek.x86_64.rpm                                                                                   | 716 kB     00:02       
  99. (12/17): ksh-20100621-16.el6.x86_64.rpm                                                                                                         | 684 kB     00:02       
  100. (13/17): libaio-devel-0.3.107-10.el6.x86_64.rpm                                                                                                 |  13 kB     00:00       
  101. (14/17): libstdc++-devel-4.4.6-4.el6.x86_64.rpm                                                                                                 | 1.5 MB     00:04       
  102. (15/17): mpfr-2.4.1-6.el6.x86_64.rpm                                                                                                            | 156 kB     00:00       
  103. (16/17): oracle-rdbms-server-11gR2-preinstall-1.0-6.el6.x86_64.rpm                                                                              |  15 kB     00:00       
  104. (17/17): ppl-0.10.2-11.el6.x86_64.rpm                                                                                                           | 1.3 MB     00:03       
  105. -----------------------------------------------------------------------------------------------------------------------------------------------------------------------  
  106. Total                                                                                                                                  329 kB/s |  43 MB     02:12       
  107. warning: rpmts_HdrFromFdno: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY  
  108. Retrieving key from http://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol6  
  109. Importing GPG key 0xEC551F03:  
  110.  Userid: "Oracle OSS group (Open Source Software group) <build@oss.oracle.com>"  
  111.  From  : http://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol6  
  112. Running rpm_check_debug  
  113. Running Transaction Test  
  114. Transaction Test Succeeded  
  115. Running Transaction  
  116.   Installing : libstdc++-devel-4.4.6-4.el6.x86_64                                                                                                                 1/19   
  117.   Updating   : glibc-2.12-1.80.el6_3.6.x86_64                                                                                                                     2/19   
  118.   Updating   : glibc-common-2.12-1.80.el6_3.6.x86_64                                                                                                              3/19   
  119.   Installing : mpfr-2.4.1-6.el6.x86_64                                                                                                                            4/19   
  120.   Installing : cpp-4.4.6-4.el6.x86_64                                                                                                                             5/19   
  121.   Installing : compat-libcap1-1.10-1.x86_64                                                                                                                       6/19   
  122.   Installing : ksh-20100621-16.el6.x86_64                                                                                                                         7/19   
  123.   Installing : compat-libstdc++-33-3.2.3-69.el6.x86_64                                                                                                            8/19   
  124.   Installing : ppl-0.10.2-11.el6.x86_64                                                                                                                           9/19   
  125.   Installing : cloog-ppl-0.15.7-1.2.el6.x86_64                                                                                                                   10/19   
  126.   Installing : kernel-uek-headers-2.6.32-300.39.2.el6uek.x86_64                                                                                                  11/19   
  127.   Installing : glibc-headers-2.12-1.80.el6_3.6.x86_64                                                                                                            12/19   
  128.   Installing : glibc-devel-2.12-1.80.el6_3.6.x86_64                                                                                                              13/19   
  129.   Installing : gcc-4.4.6-4.el6.x86_64                                                                                                                            14/19   
  130.   Installing : gcc-c++-4.4.6-4.el6.x86_64                                                                                                                        15/19   
  131.   Installing : libaio-devel-0.3.107-10.el6.x86_64                                                                                                                16/19   
  132.   Installing : oracle-rdbms-server-11gR2-preinstall-1.0-6.el6.x86_64                                                                                             17/19   
  133.   Cleanup    : glibc-2.12-1.80.el6.x86_64                                                                                                                        18/19   
  134.   Cleanup    : glibc-common-2.12-1.80.el6.x86_64                                                                                                                 19/19   
  135.   Verifying  : compat-libcap1-1.10-1.x86_64                                                                                                                       1/19   
  136.   Verifying  : ksh-20100621-16.el6.x86_64                                                                                                                         2/19   
  137.   Verifying  : glibc-common-2.12-1.80.el6_3.6.x86_64                                                                                                              3/19   
  138.   Verifying  : gcc-4.4.6-4.el6.x86_64                                                                                                                             4/19   
  139.   Verifying  : libaio-devel-0.3.107-10.el6.x86_64                                                                                                                 5/19   
  140.   Verifying  : oracle-rdbms-server-11gR2-preinstall-1.0-6.el6.x86_64                                                                                              6/19   
  141.   Verifying  : gcc-c++-4.4.6-4.el6.x86_64                                                                                                                         7/19   
  142.   Verifying  : glibc-headers-2.12-1.80.el6_3.6.x86_64                                                                                                             8/19   
  143.   Verifying  : libstdc++-devel-4.4.6-4.el6.x86_64                                                                                                                 9/19   
  144.   Verifying  : compat-libstdc++-33-3.2.3-69.el6.x86_64                                                                                                           10/19   
  145.   Verifying  : glibc-2.12-1.80.el6_3.6.x86_64                                                                                                                    11/19   
  146.   Verifying  : mpfr-2.4.1-6.el6.x86_64                                                                                                                           12/19   
  147.   Verifying  : kernel-uek-headers-2.6.32-300.39.2.el6uek.x86_64                                                                                                  13/19   
  148.   Verifying  : cpp-4.4.6-4.el6.x86_64                                                                                                                            14/19   
  149.   Verifying  : glibc-devel-2.12-1.80.el6_3.6.x86_64                                                                                                              15/19   
  150.   Verifying  : ppl-0.10.2-11.el6.x86_64                                                                                                                          16/19   
  151.   Verifying  : cloog-ppl-0.15.7-1.2.el6.x86_64                                                                                                                   17/19   
  152.   Verifying  : glibc-2.12-1.80.el6.x86_64                                                                                                                        18/19   
  153.   Verifying  : glibc-common-2.12-1.80.el6.x86_64                                                                                                                 19/19   
  154.   
  155. Installed:  
  156.   oracle-rdbms-server-11gR2-preinstall.x86_64 0:1.0-6.el6                                                                                                                
  157.   
  158. Dependency Installed:  
  159.   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                  
  160.   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_3.6    glibc-headers.x86_64 0:2.12-1.80.el6_3.6  
  161.   kernel-uek-headers.x86_64 0:2.6.32-300.39.2.el6uek 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      
  162.   mpfr.x86_64 0:2.4.1-6.el6                          ppl.x86_64 0:0.10.2-11.el6      
  163.   
  164. Dependency Updated:  
  165.   glibc.x86_64 0:2.12-1.80.el6_3.6                                               glibc-common.x86_64 0:2.12-1.80.el6_3.6                                                
  166.   
  167. Complete!  


sysctl.conf
  1. [root@node2 ~]# cat /etc/sysctl.conf  
  2. # Kernel sysctl configuration file for Red Hat Linux  
  3. #  
  4. # For binary values, 0 is disabled, 1 is enabled.  See sysctl(8) and  
  5. # sysctl.conf(5) for more details.  
  6.   
  7. # Controls IP packet forwarding  
  8. net.ipv4.ip_forward = 0  
  9.   
  10. # Controls source route verification  
  11. net.ipv4.conf.default.rp_filter = 1  
  12.   
  13. # Do not accept source routing  
  14. net.ipv4.conf.default.accept_source_route = 0  
  15.   
  16. # Controls the System Request debugging functionality of the kernel  
  17. kernel.sysrq = 0  
  18.   
  19. # Controls whether core dumps will append the PID to the core filename.  
  20. # Useful for debugging multi-threaded applications.  
  21. kernel.core_uses_pid = 1  
  22.   
  23. # Controls the use of TCP syncookies  
  24. net.ipv4.tcp_syncookies = 1  
  25.   
  26. # Disable netfilter on bridges.  
  27. net.bridge.bridge-nf-call-ip6tables = 0  
  28. net.bridge.bridge-nf-call-iptables = 0  
  29. net.bridge.bridge-nf-call-arptables = 0  
  30.   
  31. # Controls the default maxmimum size of a mesage queue  
  32. kernel.msgmnb = 65536  
  33.   
  34. # Controls the maximum size of a message, in bytes  
  35. kernel.msgmax = 65536  
  36.   
  37. # Controls the maximum shared segment size, in bytes  
  38.   
  39. # Controls the maximum number of shared memory segments, in pages  
  40.   
  41. # oracle-rdbms-server-11gR2-preinstall setting for fs.file-max is 6815744  
  42. fs.file-max = 6815744  
  43.   
  44. # oracle-rdbms-server-11gR2-preinstall setting for kernel.sem is '250 32000 100 128'  
  45. kernel.sem = 250 32000 100 128  
  46.   
  47. # oracle-rdbms-server-11gR2-preinstall setting for kernel.shmmni is 4096  
  48. kernel.shmmni = 4096  
  49.   
  50. # oracle-rdbms-server-11gR2-preinstall setting for kernel.shmall is 1073741824 on x86_64  
  51. # oracle-rdbms-server-11gR2-preinstall setting for kernel.shmall is 2097152 on i386  
  52. kernel.shmall = 1073741824  
  53.   
  54. # oracle-rdbms-server-11gR2-preinstall setting for kernel.shmmax is 4398046511104 on x86_64  
  55. # oracle-rdbms-server-11gR2-preinstall setting for kernel.shmmax is 4294967295 on i386  
  56. kernel.shmmax = 4398046511104  
  57.   
  58. # oracle-rdbms-server-11gR2-preinstall setting for net.core.rmem_default is 262144  
  59. net.core.rmem_default = 262144  
  60.   
  61. # oracle-rdbms-server-11gR2-preinstall setting for net.core.rmem_max is 4194304  
  62. net.core.rmem_max = 4194304  
  63.   
  64. # oracle-rdbms-server-11gR2-preinstall setting for net.core.wmem_default is 262144  
  65. net.core.wmem_default = 262144  
  66.   
  67. # oracle-rdbms-server-11gR2-preinstall setting for net.core.wmem_max is 1048576  
  68. net.core.wmem_max = 1048576  
  69.   
  70. # oracle-rdbms-server-11gR2-preinstall setting for fs.aio-max-nr is 1048576  
  71. fs.aio-max-nr = 1048576  
  72.   
  73. # oracle-rdbms-server-11gR2-preinstall setting for net.ipv4.ip_local_port_range is 9000 65500  
  74. net.ipv4.ip_local_port_range = 9000 65500  


x86_64 修改了numa=off
  1. [root@node2 ~]# cat /etc/grub.conf   
  2. # grub.conf generated by anaconda  
  3. #  
  4. # Note that you do not have to rerun grub after making changes to this file  
  5. # NOTICE:  You have a /boot partition.  This means that  
  6. #          all kernel and initrd paths are relative to /boot/, eg.  
  7. #          root (hd0,0)  
  8. #          kernel /vmlinuz-version ro root=/dev/sda3  
  9. #          initrd /initrd-[generic-]version.img  
  10. #boot=/dev/sda  
  11. default=0  
  12. timeout=5  
  13. splashimage=(hd0,0)/grub/splash.xpm.gz  
  14. hiddenmenu  
  15. title Oracle Linux Server-uek (2.6.39-200.24.1.el6uek.x86_64)  
  16.     root (hd0,0)  
  17.     kernel /vmlinuz-2.6.39-200.24.1.el6uek.x86_64 ro root=UUID=8adc03e5-e7c8-42c9-a1e8-aae4bc1d2647 rd_NO_LUKS rd_NO_LVM LANG=en_US.UTF-8 rd_NO_MD SYSFONT=latarcyrheb-sun16   KEYBOARDTYPE=pc KEYTABLE=us rd_NO_DM rhgb quiet numa=off  
  18.     initrd /initramfs-2.6.39-200.24.1.el6uek.x86_64.img  
  19. title Oracle Linux Server (2.6.32-279.el6.x86_64)  
  20.     root (hd0,0)  
  21.     kernel /vmlinuz-2.6.32-279.el6.x86_64 ro root=UUID=8adc03e5-e7c8-42c9-a1e8-aae4bc1d2647 rd_NO_LUKS rd_NO_LVM LANG=en_US.UTF-8 rd_NO_MD SYSFONT=latarcyrheb-sun16 crashkernel=auto  KEYBOARDTYPE=pc KEYTABLE=us rd_NO_DM rhgb quiet numa=off  
  22.     initrd /initramfs-2.6.32-279.el6.x86_64.img  

grid用户的配置需要自行加上,复制oracle用户的即可

  1. [root@node2 ~]# tail -40 /etc/security/limits.conf  
  2. #@faculty        hard    nproc           50  
  3. #ftp             hard    nproc           0  
  4. #@student        -       maxlogins       4  
  5. # End of file  
  6.   
  7. # oracle-rdbms-server-11gR2-preinstall setting for nofile soft limit is 1024  
  8. oracle   soft   nofile    1024  
  9.   
  10. # oracle-rdbms-server-11gR2-preinstall setting for nofile hard limit is 65536  
  11. oracle   hard   nofile    65536  
  12.   
  13. # oracle-rdbms-server-11gR2-preinstall setting for nproc soft limit is 2047  
  14. oracle   soft   nproc    2047  
  15.   
  16. # oracle-rdbms-server-11gR2-preinstall setting for nproc hard limit is 16384  
  17. oracle   hard   nproc    16384  
  18.   
  19. # oracle-rdbms-server-11gR2-preinstall setting for stack soft limit is 10240KB  
  20. oracle   soft   stack    10240  
  21.   
  22. # oracle-rdbms-server-11gR2-preinstall setting for stack hard limit is 32768KB  
  23. oracle   hard   stack    32768  
  24.   
  25. # oracle-rdbms-server-11gR2-preinstall setting for nofile soft limit is 1024  
  26. grid   soft   nofile    1024  
  27.   
  28. # oracle-rdbms-server-11gR2-preinstall setting for nofile hard limit is 65536  
  29. grid   hard   nofile    65536  
  30.   
  31. # oracle-rdbms-server-11gR2-preinstall setting for nproc soft limit is 2047  
  32. grid   soft   nproc    2047  
  33.   
  34. # oracle-rdbms-server-11gR2-preinstall setting for nproc hard limit is 16384  
  35. grid   hard   nproc    16384  
  36.   
  37. # oracle-rdbms-server-11gR2-preinstall setting for stack soft limit is 10240KB  
  38. grid   soft   stack    10240  
  39.   
  40. # oracle-rdbms-server-11gR2-preinstall setting for stack hard limit is 32768KB  
  41. grid   hard   stack    32768  

配置oracle和grid的ssh用户等效性,也可以在安装过程中配置

在node1和node2上使用oracle用户和grid执行以下操作,在家目录下生成.ssh目录

  1. [root@node1 ~]# su - oracle  
  2. [oracle@node1 ~]$ ssh-keygen -t rsa  
  3. Generating public/private rsa key pair.  
  4. Enter file in which to save the key (/home/oracle/.ssh/id_rsa):   
  5. Created directory '/home/oracle/.ssh'.  
  6. Enter passphrase (empty for no passphrase):   
  7. Enter same passphrase again:   
  8. Your identification has been saved in /home/oracle/.ssh/id_rsa.  
  9. Your public key has been saved in /home/oracle/.ssh/id_rsa.pub.  
  10. The key fingerprint is:  
  11. 38:4e:6f:b0:fc:7e:f2:c0:00:67:13:79:ef:2a:a5:e8 oracle@node1.localdomain  
  12. The key's randomart image is:  
  13. +--[ RSA 2048]----+  
  14. |      ..         |  
  15. |      ...        |  
  16. |    . +. .       |  
  17. |     + o  .      |  
  18. |      * S.       |  
  19. |     + B. .      |  
  20. |     .+o=.       |  
  21. |    . ooo..      |  
  22. |   .E  oo+.      |  
  23. +-----------------+  
  24. [oracle@node1 ~]$ ssh-keygen -t dsa  
  25. Generating public/private dsa key pair.  
  26. Enter file in which to save the key (/home/oracle/.ssh/id_dsa):   
  27. Enter passphrase (empty for no passphrase):   
  28. Enter same passphrase again:   
  29. Your identification has been saved in /home/oracle/.ssh/id_dsa.  
  30. Your public key has been saved in /home/oracle/.ssh/id_dsa.pub.  
  31. The key fingerprint is:  
  32. 42:77:1b:2e:24:1d:ec:cf:88:4a:3f:37:f0:b3:b2:cd oracle@node1.localdomain  
  33. The key's randomart image is:  
  34. +--[ DSA 1024]----+  
  35. |       ..        |  
  36. |       ...       |  
  37. |      o.+ o      |  
  38. |     . +.o o     |  
  39. |      ..S+o      |  
  40. |    . o...o      |  
  41. |   . o o         |  
  42. |    . +o=        |  
  43. |      .=E+       |  
  44. +-----------------+  
  45. [oracle@node1 ~]$ su - grid  
  46. Password:   
  47. [grid@node1 ~]$ ssh-keygen -t rsa  
  48. Generating public/private rsa key pair.  
  49. Enter file in which to save the key (/home/grid/.ssh/id_rsa):   
  50. Created directory '/home/grid/.ssh'.  
  51. Enter passphrase (empty for no passphrase):   
  52. Enter same passphrase again:   
  53. Your identification has been saved in /home/grid/.ssh/id_rsa.  
  54. Your public key has been saved in /home/grid/.ssh/id_rsa.pub.  
  55. The key fingerprint is:  
  56. c2:e6:ee:b5:b6:c5:14:1a:78:e9:96:97:d9:0b:a1:13 grid@node1.localdomain  
  57. The key's randomart image is:  
  58. +--[ RSA 2048]----+  
  59. |                 |  
  60. |       . .       |  
  61. |      . E o      |  
  62. |     . o * *     |  
  63. |      + S * .    |  
  64. |     o o = . .   |  
  65. |      . . o .    |  
  66. |     . ..o       |  
  67. |     .o.o.       |  
  68. +-----------------+  
  69. [grid@node1 ~]$ ssh-keygen -t dsa  
  70. Generating public/private dsa key pair.  
  71. Enter file in which to save the key (/home/grid/.ssh/id_dsa):   
  72. Enter passphrase (empty for no passphrase):   
  73. Enter same passphrase again:   
  74. Your identification has been saved in /home/grid/.ssh/id_dsa.  
  75. Your public key has been saved in /home/grid/.ssh/id_dsa.pub.  
  76. The key fingerprint is:  
  77. d3:36:e8:54:10:84:a8:c6:59:6d:24:5f:3d:90:48:9d grid@node1.localdomain  
  78. The key's randomart image is:  
  79. +--[ DSA 1024]----+  
  80. |    .=o=**       |  
  81. |    oo=.E.o      |  
  82. | . + ..   ..     |  
  83. |  =      +       |  
  84. | .      S +      |  
  85. |       o o .     |  
  86. |        .        |  
  87. |                 |  
  88. |                 |  
  89. +-----------------+  

在node1上配置

  1. [oracle@node1 ~]$ cd .ssh/  
  2. [oracle@node1 .ssh]$ cat id_dsa.pub  >> authorized_keys  
  3. [oracle@node1 .ssh]$ cat id_rsa.pub  >> authorized_keys  
  4. [oracle@node1 .ssh]$ ssh node2 cat ~/.ssh/id_dsa.pub >> authorized_keys  
  5. The authenticity of host 'node2 (192.168.1.52)' can't be established.  
  6. RSA key fingerprint is 09:78:b3:fd:8d:a5:9a:a4:d8:fc:98:bd:e3:5e:80:3b.  
  7. Are you sure you want to continue connecting (yes/no)? yes  
  8. Warning: Permanently added 'node2,192.168.1.52' (RSA) to the list of known hosts.  
  9. oracle@node2's password:   
  10. [oracle@node1 .ssh]$ ssh node2 cat ~/.ssh/id_rsa.pub >> authorized_keys   
  11. oracle@node2's password:   
  12. [oracle@node1 .ssh]$ scp authorized_keys node2:~/.ssh  
  13. oracle@node2's password:   
  14. authorized_keys                                                                                                                      100% 2040     2.0KB/s   00:00      
  15. [oracle@node1 .ssh]$ su - grid  
  16. Password:   
  17. [grid@node1 ~]$ cd .ssh/  
  18. [grid@node1 .ssh]$ cat id_dsa.pub  >> authorized_keys  
  19. [grid@node1 .ssh]$ cat id_rsa.pub  >> authorized_keys  
  20. [grid@node1 .ssh]$ ssh node2 cat ~/.ssh/id_dsa.pub >> authorized_keys  
  21. The authenticity of host 'node2 (192.168.1.52)' can't be established.  
  22. RSA key fingerprint is 09:78:b3:fd:8d:a5:9a:a4:d8:fc:98:bd:e3:5e:80:3b.  
  23. Are you sure you want to continue connecting (yes/no)? yes  
  24. Warning: Permanently added 'node2,192.168.1.52' (RSA) to the list of known hosts.  
  25. grid@node2's password:   
  26. [grid@node1 .ssh]$ ssh node2 cat ~/.ssh/id_rsa.pub >> authorized_keys  
  27. grid@node2's password:   
  28. [grid@node1 .ssh]$ scp authorized_keys node2:~/.ssh  
  29. grid@node2's password:   
  30. authorized_keys                                                                                                                      100% 2032     2.0KB/s   00:00      
  31. [grid@node1 .ssh]$   

在node1和node2上进行验证

  1. [oracle@node1 ~]$ ssh node1-priv date;ssh node2-priv date  
  2. Fri Dec 28 15:44:41 CST 2012  
  3. Fri Dec 28 15:44:41 CST 2012  
  4. [oracle@node1 ~]$ ssh node1 date;ssh node2 date  
  5. Fri Dec 28 15:44:43 CST 2012  
  6. Fri Dec 28 15:44:43 CST 2012  
  7. [oracle@node1 ~]$ su - grid  
  8. Password:   
  9. [grid@node1 ~]$ ssh node1 date;ssh node2 date  
  10. Fri Dec 28 15:44:48 CST 2012  
  11. Fri Dec 28 15:44:49 CST 2012  
  12. [grid@node1 ~]$ ssh node1-priv date;ssh node2-priv date  
  13. Fri Dec 28 15:44:50 CST 2012  
  14. Fri Dec 28 15:44:50 CST 2012  
  15. [grid@node1 ~]$   
  1. [oracle@node2 ~]$ ssh node1-priv date;ssh node2-priv date  
  2. Fri Dec 28 15:46:56 CST 2012  
  3. Fri Dec 28 15:46:56 CST 2012  
  4. [oracle@node2 ~]$ ssh node1 date;ssh node2 date  
  5. Fri Dec 28 15:46:58 CST 2012  
  6. Fri Dec 28 15:46:58 CST 2012  
  7. [oracle@node2 ~]$ su - grid  
  8. Password:   
  9. [grid@node2 ~]$ ssh node1 date;ssh node2 date  
  10. Fri Dec 28 15:47:02 CST 2012  
  11. Fri Dec 28 15:47:02 CST 2012  
  12. [grid@node2 ~]$ ssh node1-priv date;ssh node2-priv date  
  13. Fri Dec 28 15:47:03 CST 2012  
  14. Fri Dec 28 15:47:03 CST 2012  

配置oracle和grid用户的环境变量

node1上oracle用户

  1. [oracle@node1 ~]$ cat .bash_profile   
  2. # .bash_profile  
  3.   
  4. # Get the aliases and functions  
  5. if [ -f ~/.bashrc ]; then  
  6.     . ~/.bashrc  
  7. fi  
  8.   
  9. # User specific environment and startup programs  
  10.   
  11. PATH=$PATH:$HOME/bin  
  12.   
  13. export PATH  
  14.   
  15. alias ls="ls -FA"  
  16.   
  17. ORACLE_SID=zhongwc1; export ORACLE_SID  
  18. ORACLE_UNQNAME=zhongwc; export ORACLE_UNQNAME  
  19. JAVA_HOME=/usr/local/java; export JAVA_HOME  
  20. ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE  
  21. ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1; export ORACLE_HOME  
  22. ORACLE_PATH=/u01/app/common/oracle/sql; export ORACLE_PATH  
  23. ORACLE_TERM=xterm; export ORACLE_TERM  
  24.   
  25. NLS_DATE_FORMAT="DD-MON-YYYY HH24:MI:SS"; export NLS_DATE_FORMAT  
  26. TNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMIN  
  27. ORA_NLS11=$ORACLE_HOME/nls/data; export ORA_NLS11  
  28. DISPLAY=192.168.2.224:0.0; export DISPLAY  
  29. NLS_LANG=AMERICAN_AMERICA.ZHS16GBK; export NLS_LANG  
  30.   
  31. PATH=.:${JAVA_HOME}/bin:${PATH}:$HOME/bin:$ORACLE_HOME/bin  
  32. PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin  
  33. PATH=${PATH}:/u01/app/common/oracle/bin  
  34. export PATH  
  35.   
  36. LD_LIBRARY_PATH=$ORACLE_HOME/lib  
  37. LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/lib  
  38. LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib  
  39. export LD_LIBRARY_PATH  
  40.   
  41. CLASSPATH=$ORACLE_HOME/JRE  
  42. CLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlib  
  43. CLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jlib  
  44. CLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlib  
  45. export CLASSPATH  
  46.   
  47. THREADS_FLAG=native; export THREADS_FLAG  
  48.   
  49. export TEMP=/tmp  
  50. export TMPDIR=/tmp  
  51.   
  52. umask 022  
  53.   
  54. alias sqlplus="rlwrap sqlplus"  
  55. alias rman="rlwrap rman"  
  56. alias ggsci="rlwrap ggsci"  
  57. alias logdump="rlwrap logdump"  
  58. alias asmcmd="rlwrap asmcmd"  
  59. alias base="cd $ORACLE_BASE"  
  60. alias home="cd $ORACLE_HOME"  

node1上grid用户

  1. [grid@node1 ~]$ cat .bash_profile   
  2. # .bash_profile  
  3.   
  4. # Get the aliases and functions  
  5. if [ -f ~/.bashrc ]; then  
  6.     . ~/.bashrc  
  7. fi  
  8.   
  9. # User specific environment and startup programs  
  10.   
  11. PATH=$PATH:$HOME/bin  
  12.   
  13. export PATH  
  14.   
  15. alias ls="ls -FA"  
  16.   
  17. ORACLE_SID=+ASM1; export ORACLE_SID  
  18. JAVA_HOME=/usr/local/java; export JAVA_HOME  
  19. ORACLE_BASE=/u01/app/grid; export ORACLE_BASE  
  20. ORACLE_HOME=/u01/app/11.2.0/grid; export ORACLE_HOME  
  21. ORACLE_PATH=/u01/app/oracle/common/oracle/sql; export ORACLE_PATH  
  22. ORACLE_TERM=xterm; export ORACLE_TERM  
  23.   
  24. NLS_DATE_FORMAT="DD-MON-YYYY HH24:MI:SS"; export NLS_DATE_FORMAT  
  25. TNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMIN  
  26. ORA_NLS11=$ORACLE_HOME/nls/data; export ORA_NLS11  
  27. DISPLAY=192.168.2.224:0.0; export DISPLAY  
  28. NLS_LANG=AMERICAN_AMERICA.ZHS16GBK; export NLS_LANG  
  29.   
  30. PATH=.:${JAVA_HOME}/bin:${PATH}:$HOME/bin:$ORACLE_HOME/bin  
  31. PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin  
  32. PATH=${PATH}:/u01/app/common/oracle/bin  
  33. export PATH  
  34.   
  35. LD_LIBRARY_PATH=$ORACLE_HOME/lib  
  36. LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/lib  
  37. LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib  
  38. export LD_LIBRARY_PATH  
  39.   
  40. CLASSPATH=$ORACLE_HOME/JRE  
  41. CLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlib  
  42. CLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jlib  
  43. CLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlib  
  44. export CLASSPATH  
  45.   
  46. THREADS_FLAG=native; export THREADS_FLAG  
  47.   
  48. export TEMP=/tmp  
  49. export TMPDIR=/tmp  
  50.   
  51. umask 022  
  52.   
  53. alias sqlplus="rlwrap sqlplus"  
  54. alias rman="rlwrap rman"  
  55. alias ggsci="rlwrap ggsci"  
  56. alias logdump="rlwrap logdump"  
  57. alias asmcmd="rlwrap asmcmd"  
  58. alias base="cd $ORACLE_BASE"  
  59. alias home="cd $ORACLE_HOME"  


在node2上需要将oracle用户的ORACLE_SID改为zhongwc2,grid用户的ORACLE_SID改为+ASM2