怎样在RedHat/CentOS Linux上使用oracle-validated包

怎样在RedHat Linux上使用oracle-validated包

首先，参考官方文档：http://docs.oracle.com/cd/B28359_01/install.111/b32002/install_overview.htm

If you are not a ULN customer, and you are running Red Hat Enterprise Linux or Oracle Linux, then you can obtain the Oracle Validated RPM at the following URLs:

Oracle Linux 4:

http://oss.oracle.com/el4/oracle-validated/

Oracle Linux 5:

http://oss.oracle.com/el5/oracle-validated/

1.下载 oracle-validated package

[root@ora10g ~]# cd /tmp
[root@ora10g tmp]# wget https://oss.oracle.com/el5/oracle-validated/oracle-validated-1.0.0-18.el5.x86_64.rpm
--2013-05-29 22:01:42--  https://oss.oracle.com/el5/oracle-validated/oracle-validated-1.0.0-18.el5.x86_64.rpm
Resolving oss.oracle.com... 137.254.17.12
Connecting to oss.oracle.com|137.254.17.12|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 15224 (15K) [application/x-rpm]
Saving to: `oracle-validated-1.0.0-18.el5.x86_64.rpm'
100%[========================================>] 15,224      66.6K/s   in 0.2s    
2013-05-29 22:01:58 (66.6 KB/s) - `oracle-validated-1.0.0-18.el5.x86_64.rpm' saved [15224/15224]

2.安装package:

[root@ora10g tmp]# yum install oracle-validated-1.0.0-18.el5.x86_64.rpm 

可能需要导入RPM GPG KEY：

rpm --import http://oss.oracle.com/el5/RPM-GPG-KEY-oracle

包安装完毕后，参数已修改：

[root@ora10g tmp]# ls -l /etc/sysctl.conf*
-rw-r--r-- 1 root root 1465 May 29 22:02 /etc/sysctl.conf
-rw-r--r-- 1 root root  996 May 29 21:59 /etc/sysctl.conf.orabackup
[root@ora10g tmp]# dff /etc/sysctl.conf /etc/sysctl.conf.orabackup 
-bash: dff: command not found
[root@ora10g tmp]# diff /etc/sysctl.conf /etc/sysctl.conf.orabackup 
16c16
< kernel.sysrq = 1
---
> kernel.sysrq = 0
29c29
< kernel.msgmax = 8192
---
> kernel.msgmax = 65536
32c32
< kernel.shmmax = 4398046511104
---
> kernel.shmmax = 68719476736
35,48c35
< kernel.shmall = 1073741824
< fs.file-max = 327679
< kernel.msgmni = 2878
< kernel.sem = 250 32000 100 142
< kernel.shmmni = 4096
< net.core.rmem_default = 262144
< net.core.rmem_max = 4194304
< net.core.wmem_default = 262144
< net.core.wmem_max = 262144
< fs.aio-max-nr = 3145728
< net.ipv4.ip_local_port_range = 1024 65000
< # For 11g recommended value for net.core.rmem_max is 4194304
< # For 10g uncomment the following line, comment other entries for this parameter and re-run sysctl -p
< # net.core.rmem_max=2097152
---
> kernel.shmall = 4294967296

/etc/security/limits.conf：

[root@ora10g tmp]# ls -l /etc/security/limits.conf*
-rw-r--r-- 1 root root 2059 May 29 22:02 /etc/security/limits.conf
-rw-r--r-- 1 root root 1789 May 29 21:59 /etc/security/limits.conf.orabackup
[root@ora10g tmp]# diff /etc/security/limits.conf /etc/security/limits.conf.orabackup
44,51d43
< oracle   soft   nofile    131072
< oracle   hard   nofile    131072
< oracle   soft   nproc    131072
< oracle   hard   nproc    131072
< oracle   soft   core    unlimited
< oracle   hard   core    unlimited
< oracle   soft   memlock    50000000
< oracle   hard   memlock    50000000

 

附上本地yum配置：/etc/yum.repos.d/local.repo

[local_yum_source]
name=my_local_source
baseurl=file:///media/disk/Server
gpgcheck=0
enable=1
gpgkey=file:///etc/yum.repos.d/RPM-GPG-KEY-oracle

 感谢 http://perumal.org/prepare-your-linux-server-to-install-oracle-database-using-oracle-validated-rpm/

 

Preparing a Linux server to install oracle has been made easy with the help of oracle-validated rpm package. Install of oracle-validated automates the download and install of all required RPMs including dependencies, setup of Linux kernel parameters, creation of oracle user (Linux user) and dba, oinstall groups

I have been thinking of trying out oracle-validated for a while – Today, I downloaded the RPM from http://oss.oracle.com/el5/oracle-validated/ and performed a test install on CentOS Linux 5.2 server.

• Releases prior to oracle-validated-1.0.0-18.el5.i386.rpm had a dependency check on enterprise-release.

1 2 3

$ grep "enterprise-release" oracle-validated.spec        - Removed enterprise-release package dependency and added /etc/redhat-release file dependency to support RHEL        - Added enterprise-release dependency to fix el4/5 cross install issue

• Download oracle-validated RPM

1 2 3 4 5

[root@dblx132 ~]# cd /tmp [root@dblx132 tmp]# wget http://oss.oracle.com/el5/oracle-validated/oracle-validated-1.0.0-18.el5.i386.rpm --23:33:44--  http://oss.oracle.com/el5/oracle-validated/oracle-validated-1.0.0-18.el5.i386.rpm .............. 23:33:44 (130 KB/s) - `oracle-validated-1.0.0-18.el5.i386.rpm' saved [14889/14889]

If you do not import the RPM GPG key supplied by Oracle then your RPM install will terminate with an error.

1	rpm --import http://oss.oracle.com/el5/RPM-GPG-KEY-oracle

• Install oracle-validated RPM

001 002 003 004 005 006 007 008 009 010 011 012 013 014 015 016 017 018 019 020 021 022 023 024 025 026 027 028 029 030 031 032 033 034 035 036 037 038 039 040 041 042 043 044 045 046 047 048 049 050 051 052 053 054 055 056 057 058 059 060 061 062 063 064 065 066 067 068 069 070 071 072 073 074 075 076 077 078 079 080 081 082 083 084 085 086 087 088 089 090 091 092 093 094 095 096 097 098 099 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180

[root@dblx132 tmp]# yum install ./oracle-validated-1.0.0-18.el5.i386.rpm Loading "fastestmirror" plugin Loading mirror speeds from cached hostfile   * base: www.cyberuse.com   * updates: www.cyberuse.com   * addons: pubmirrors.reflected.net   * extras: mirrors.unbornmedia.com Setting up Install Process Parsing package install arguments Examining ./oracle-validated-1.0.0-18.el5.i386.rpm: oracle-validated - 1.0.0-18.el5.i386 Marking ./oracle-validated-1.0.0-18.el5.i386.rpm to be installed Resolving Dependencies --> Running transaction check ---> Package oracle-validated.i386 0:1.0.0-18.el5 set to be updated --> Processing Dependency: compat-db for package: oracle-validated --> Processing Dependency: compat-gcc-34 for package: oracle-validated --> Processing Dependency: compat-gcc-34-c++ for package: oracle-validated --> Processing Dependency: compat-libstdc++-33 for package: oracle-validated --> Processing Dependency: elfutils-libelf-devel for package: oracle-validated --> Processing Dependency: gcc for package: oracle-validated --> Processing Dependency: gcc-c++ for package: oracle-validated --> Processing Dependency: gdb for package: oracle-validated --> Processing Dependency: glibc-devel for package: oracle-validated --> Processing Dependency: glibc-headers for package: oracle-validated --> Processing Dependency: kernel-headers for package: oracle-validated --> Processing Dependency: libXp for package: oracle-validated --> Processing Dependency: libaio-devel for package: oracle-validated --> Processing Dependency: libstdc++-devel for package: oracle-validated --> Processing Dependency: sysstat for package: oracle-validated --> Processing Dependency: unixODBC for package: oracle-validated --> Processing Dependency: unixODBC-devel for package: oracle-validated --> Running transaction check ---> Package libaio-devel.i386 0:0.3.106-3.2 set to be updated ---> Package unixODBC-devel.i386 0:2.2.11-7.1 set to be updated ---> Package gdb.i386 0:6.8-27.el5 set to be updated ---> Package libstdc++-devel.i386 0:4.1.2-44.el5 set to be updated --> Processing Dependency: libstdc++ = 4.1.2-44.el5 for package: libstdc++-devel ---> Package glibc-devel.i386 0:2.5-34 set to be updated --> Processing Dependency: glibc = 2.5-34 for package: glibc-devel ---> Package glibc-headers.i386 0:2.5-34 set to be updated ---> Package gcc-c++.i386 0:4.1.2-44.el5 set to be updated ---> Package kernel-headers.i386 0:2.6.18-128.1.10.el5 set to be updated ---> Package elfutils-libelf-devel.i386 0:0.137-3.el5 set to be updated --> Processing Dependency: elfutils-libelf-devel-static-i386 = 0.137-3.el5 for package: elfutils-libelf-devel --> Processing Dependency: elfutils-libelf-i386 = 0.137-3.el5 for package: elfutils-libelf-devel ---> Package compat-gcc-34.i386 0:3.4.6-4 set to be updated ---> Package compat-gcc-34-c++.i386 0:3.4.6-4 set to be updated ---> Package compat-libstdc++-33.i386 0:3.2.3-61 set to be updated ---> Package compat-db.i386 0:4.2.52-5.1 set to be updated ---> Package gcc.i386 0:4.1.2-44.el5 set to be updated --> Processing Dependency: libgomp >= 4.1.2-44.el5 for package: gcc --> Processing Dependency: libgcc >= 4.1.2-44.el5 for package: gcc --> Processing Dependency: cpp = 4.1.2-44.el5 for package: gcc ---> Package libXp.i386 0:1.0.0-8.1.el5 set to be updated ---> Package sysstat.i386 0:7.0.2-3.el5 set to be updated ---> Package unixODBC.i386 0:2.2.11-7.1 set to be updated --> Running transaction check ---> Package cpp.i386 0:4.1.2-44.el5 set to be updated ---> Package libgcc.i386 0:4.1.2-44.el5 set to be updated ---> Package elfutils-libelf-devel-static.i386 0:0.137-3.el5 set to be updated ---> Package glibc.i686 0:2.5-34 set to be updated --> Processing Dependency: glibc-common = 2.5-34 for package: glibc ---> Package elfutils-libelf.i386 0:0.137-3.el5 set to be updated ---> Package libgomp.i386 0:4.3.2-7.el5 set to be updated ---> Package libstdc++.i386 0:4.1.2-44.el5 set to be updated --> Running transaction check ---> Package glibc-common.i386 0:2.5-34 set to be updated --> Finished Dependency Resolution   Dependencies Resolved   =============================================================================   Package                 Arch       Version          Repository        Size ============================================================================= Installing:   oracle-validated        i386       1.0.0-18.el5     ./oracle-validated-1.0.0-18.el5.i386.rpm   41 k Updating:   cpp                     i386       4.1.2-44.el5     base              2.7 M   elfutils-libelf         i386       0.137-3.el5      base               58 k   glibc                   i686       2.5-34           base              5.2 M   glibc-common            i386       2.5-34           base               16 M   libgcc                  i386       4.1.2-44.el5     base               94 k   libstdc++               i386       4.1.2-44.el5     base              363 k Installing for dependencies:   compat-db               i386       4.2.52-5.1       base              1.7 M   compat-gcc-34           i386       3.4.6-4          base              4.1 M   compat-gcc-34-c++       i386       3.4.6-4          base               11 M   compat-libstdc++-33     i386       3.2.3-61         base              232 k   elfutils-libelf-devel   i386       0.137-3.el5      base               24 k   elfutils-libelf-devel-static  i386       0.137-3.el5      base               66 k   gcc                     i386       4.1.2-44.el5     base              5.2 M   gcc-c++                 i386       4.1.2-44.el5     base              3.4 M   gdb                     i386       6.8-27.el5       base              3.3 M   glibc-devel             i386       2.5-34           base              2.0 M   glibc-headers           i386       2.5-34           base              598 k   kernel-headers          i386       2.6.18-128.1.10.el5  updates           917 k   libXp                   i386       1.0.0-8.1.el5    base               23 k   libaio-devel            i386       0.3.106-3.2      base               11 k   libgomp                 i386       4.3.2-7.el5      base               67 k   libstdc++-devel         i386       4.1.2-44.el5     base              2.9 M   sysstat                 i386       7.0.2-3.el5      base              169 k   unixODBC                i386       2.2.11-7.1       base              832 k   unixODBC-devel          i386       2.2.11-7.1       base              739 k   Transaction Summary ============================================================================= Install     20 Package(s) Update       6 Package(s) Remove       0 Package(s)           Total download size: 62 M Is this ok [y/N]: y Downloading Packages: (1/25): libXp-1.0.0-8.1.e 100% |=========================|  23 kB    00:00 (2/25): gcc-4.1.2-44.el5. 100% |=========================| 5.2 MB    00:16 (3/25): libstdc++-4.1.2-4 100% |=========================| 363 kB    00:01 (4/25): libaio-devel-0.3. 100% |=========================|  11 kB    00:00 (5/25): gcc-c++-4.1.2-44. 100% |=========================| 3.4 MB    00:09 (6/25): kernel-headers-2. 100% |=========================| 917 kB    00:02 (7/25): unixODBC-2.2.11-7 100% |=========================| 832 kB    00:02 (8/25): compat-db-4.2.52- 100% |=========================| 1.7 MB    00:05 (9/25): compat-libstdc++- 100% |=========================| 232 kB    00:00 (10/25): elfutils-libelf- 100% |=========================|  24 kB    00:00 (11/25): libgomp-4.3.2-7. 100% |=========================|  67 kB    00:00 (12/25): glibc-devel-2.5- 100% |=========================| 2.0 MB    00:06 (13/25): unixODBC-devel-2 100% |=========================| 739 kB    00:02 (14/25): elfutils-libelf- 100% |=========================|  58 kB    00:00 (15/25): gdb-6.8-27.el5.i 100% |=========================| 3.3 MB    00:10 (16/25): compat-gcc-34-3. 100% |=========================| 4.1 MB    00:13 (17/25): glibc-2.5-34.i68 100% |=========================| 5.2 MB    00:18 (18/25): sysstat-7.0.2-3. 100% |=========================| 169 kB    00:00 (19/25): elfutils-libelf- 100% |=========================|  66 kB    00:00 (20/25): libstdc++-devel- 100% |=========================| 2.9 MB    00:09 (21/25): libgcc-4.1.2-44. 100% |=========================|  94 kB    00:00 (22/25): glibc-common-2.5 100% |=========================|  16 MB    00:51 (23/25): compat-gcc-34-c+ 100% |=========================|  11 MB    00:39 (24/25): cpp-4.1.2-44.el5 100% |=========================| 2.7 MB    00:10 (25/25): glibc-headers-2. 100% |=========================| 598 kB    00:01 Running rpm_check_debug Running Transaction Test Finished Transaction Test Transaction Test Succeeded Running Transaction    Updating  : libgcc                       ####################### [ 1/32]    Updating  : glibc-common                 ####################### [ 2/32]    Updating  : glibc                        ####################### [ 3/32]    Updating  : libstdc++                    ####################### [ 4/32]    Installing: libstdc++-devel              ####################### [ 5/32]    Updating  : elfutils-libelf              ####################### [ 6/32]    Installing: unixODBC                     ####################### [ 7/32]    Installing: kernel-headers               ####################### [ 8/32]    Installing: glibc-headers                ####################### [ 9/32]    Installing: glibc-devel                  ####################### [10/32]    Installing: compat-gcc-34                ####################### [11/32]    Installing: compat-gcc-34-c++            ####################### [12/32]    Installing: unixODBC-devel               ####################### [13/32]    Installing: compat-db                    ####################### [14/32]    Updating  : cpp                          ####################### [15/32]    Installing: sysstat                      ####################### [16/32]    Installing: gdb                          ####################### [17/32]    Installing: libgomp                      ####################### [18/32]    Installing: gcc                          ####################### [19/32]    Installing: gcc-c++                      ####################### [20/32]    Installing: compat-libstdc++-33          ####################### [21/32]    Installing: libXp                        ####################### [22/32]    Installing: libaio-devel                 ####################### [23/32]    Installing: elfutils-libelf-devel        ####################### [24/32]    Installing: elfutils-libelf-devel-static ####################### [25/32]    Installing: oracle-validated             ####################### [26/32]    Cleanup   : cpp                          ####################### [27/32]    Cleanup   : glibc-common                 ####################### [28/32]    Cleanup   : libgcc                       ####################### [29/32]    Cleanup   : glibc                        ####################### [30/32]    Cleanup   : elfutils-libelf              ####################### [31/32]    Cleanup   : libstdc++                    ####################### [32/32]   Installed: oracle-validated.i386 0:1.0.0-18.el5 Dependency Installed: compat-db.i386 0:4.2.52-5.1 compat-gcc-34.i386 0:3.4.6-4 compat-gcc-34-c++.i386 0:3.4.6-4 compat-libstdc++-33.i386 0:3.2.3-61 elfutils-libelf-devel.i386 0:0.137-3.el5 elfutils-libelf-devel-static.i386 0:0.137-3.el5 gcc.i386 0:4.1.2-44.el5 gcc-c++.i386 0:4.1.2-44.el5 gdb.i386 0:6.8-27.el5 glibc-devel.i386 0:2.5-34 glibc-headers.i386 0:2.5-34 kernel-headers.i386 0:2.6.18-128.1.10.el5 libXp.i386 0:1.0.0-8.1.el5 libaio-devel.i386 0:0.3.106-3.2 libgomp.i386 0:4.3.2-7.el5 libstdc++-devel.i386 0:4.1.2-44.el5 sysstat.i386 0:7.0.2-3.el5 unixODBC.i386 0:2.2.11-7.1 unixODBC-devel.i386 0:2.2.11-7.1 Updated: cpp.i386 0:4.1.2-44.el5 elfutils-libelf.i386 0:0.137-3.el5 glibc.i686 0:2.5-34 glibc-common.i386 0:2.5-34 libgcc.i386 0:4.1.2-44.el5 libstdc++.i386 0:4.1.2-44.el5 Complete!

The validated install automatically makes a copy of sysctl.conf to /etc/sysctl.conf.orabackup before making any changes. As you see below, Linux Kernel Parameters have been added to sysctl.conf. Lines starting with < symbol denotes that it has been added or updated.

01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30

[root@dblx132 tmp]# ls -l /etc/sysctl.conf* -rw-r–r– 1 root root 1462 May 12 23:57 /etc/sysctl.conf -rw-r–r– 1 root root  994 May 12 23:57 /etc/sysctl.conf.orabackup [root@dblx132 tmp]# diff /etc/sysctl.conf /etc/sysctl.conf.orabackup 16c16 < kernel.sysrq = 1 — > kernel.sysrq = 0 29c29 < kernel.msgmax = 8192 — > kernel.msgmax = 65536 35,48c35 < kernel.shmall = 1073741824 < fs.file-max = 327679 < kernel.msgmni = 2878 < kernel.sem = 250 32000 100 142 < kernel.shmmni = 4096 < net.core.rmem_default = 262144 < # For 11g recommended value for net.core.rmem_max is 4194304 < net.core.rmem_max = 4194304 < # For 10g uncomment the following line, comment other entries for this parameter and re-run sysctl -p < # net.core.rmem_max=2097152 < net.core.wmem_default = 262144 < net.core.wmem_max = 262144 < fs.aio-max-nr = 3145728 < net.ipv4.ip_local_port_range = 1024 65000 — > kernel.shmall = 268435456 [root@dblx132 tmp]#

Also, it updated shell limits and openfile descriptors - A back up copy of /etc/security/limits.conf was created before making changes

01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16

[rperumal@dblx132 ~]$ ls -l /etc/security/limits.conf* -rw-r--r-- 1 root root 2151 May 12 23:57 /etc/security/limits.conf -rw-r--r-- 1 root root 1789 May 12 23:57 /etc/security/limits.conf.orabackup [rperumal@dblx132 ~]$ diff /etc/security/limits.conf /etc/security/limits.conf.orabackup 44,53d43 < oracle   soft   nofile    131072 < oracle   hard   nofile    131072 < oracle   soft   nproc    131072 < oracle   hard   nproc    131072 < oracle   soft   core    unlimited < oracle   hard   core    unlimited < oracle   soft   memlock    3500000 < oracle   hard   memlock    3500000 < # Recommended stack hard limit 32MB for oracle installations < # oracle   hard   stack    32768 [rperumal@dblx132 ~]$

Additionally, it has added oracle user /etc/passwd file and dba, oinstall groups in /etc/group file.

1 2 3 4 5

[rperumal@dblx132 ~]$ grep oracle /etc/passwd | cut -d':' -f1 oracle [rperumal@dblx132 ~]$ grep -e dba -e oinstall /etc/group | cut -d':' -f1 dba oinstall

This package helps you prepare the Linux Server to install Oracle database and Grid Control.

Addenda

4/26/2010: This post has been translated to French by Khatib Mechentel, you can find it here.