Oracle Linux 6 下 Oracle RDBMS Server 11gR2 Preinstall RPM 包說明

 

在Oracle Linux 5中，我們可以使用使用Oracle validated Configuration 來加速部署Oracle 環境，關於Validated Configurations參考：

OracleValidated Configurations 安裝使用 說明

http://blog.csdn.net/tianlesoftware/article/details/7061684

 

       在Oracle Linux 6中，沒有推出oracle validate包，而是推出了oracle-rdbms-server-11gR2-preinstall包。

 

一．官網說明

Oracle RDBMS Server 11gR2 Pre-Install RPMfor Oracle Linux 6 has been released

https://blogs.oracle.com/linux/entry/oracle_rdbms_server_11gr2_pre

 

Now that the certificationof the Oracle Database 11g R2 with Oracle Linux 6 and the UnbreakableEnterprise Kernelhasbeen announced, we are glad to announce theavailability of oracle-rdbms-server-11gR2-preinstall, the Oracle RDBMSServer 11gR2 Pre-install RPM package (formerly known as oracle-validated).Designed specifically for Oracle Linux 6, this RPM aids in the installation ofthe Oracle Database.

 

In order toinstall the Oracle Database 11g R2 on Oracle Linux 6, your system needs to meeta few prerequisites, as outlined in the LinuxInstallation Guides. Using the Oracle RDBMS Server 11gR2 Pre-install RPM,you can complete most of the pre-installation configuration tasks. which is nowavailable from the Unbreakable LinuxNetwork, or via the Oracle publicyum repository.

--在Oracle Linux 6下安裝Oracle 11gR2之前，需要做一些檢查，而Pre-install 包可以協助我們完成大部分的配置工作。

 

The pre-install package is available forx86_64 only. Specifically, the package:

--在OracleLinux 6下，oracle-rdbms-server-11gR2-preinstall包只有64位版本，使用這個包可以實現如下功能：

(1)    Causes the download andinstallation of various software packages and specific versions needed fordatabase installation, with package dependencies resolved via yum

--下載和安裝各種依賴包

(2)    Creates theuser oracle and the groups oinstall and dba, which arethe defaults used during database installation

--建立Oracle 使用者和group。

(3)    Modifies kernel parametersin /etc/sysctl.conf to change settings for shared memory, semaphores,the maximum number of file descriptors, and so on

--修改/etc/sysctl.conf 核心參數。

(4)    Sets hard and soft shellresource limits in /etc/security/limits.conf, such as the number of openfiles, the number of processes, and stack size to the minimum required based onthe Oracle Database 11g Release 2 Server installation requirements

--設定/etc/security/limits.conf檔案。

(5)    Sets numa=off in thekernel boot parameters for x86_64 machines

--在64位機裡設定numa=off

 

 

二. 安裝oracle-rdbms-server-11gR2-preinstall 包

 

2.1 進入yum 配置目錄

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

 

2.2 下載yum 配置

[root@rac1 yum.repos.d]# wget http://public-yum.oracle.com/public-yum-ol6.repo

--2012-04-12 20:48:00-- http://public-yum.oracle.com/public-yum-ol6.repo

Resolving public-yum.oracle.com...141.146.44.34

Connecting topublic-yum.oracle.com|141.146.44.34|:80... connected.

HTTP request sent, awaiting response... 200OK

Length: 1461 (1.4K) [text/plain]

Saving to: “public-yum-ol6.repo”

 

100%[======================================>]1,461       --.-K/s   in 0s      

 

2012-04-12 20:48:01 (30.8 MB/s) -“public-yum-ol6.repo” saved [1461/1461]

 

2.3 查看yum 配置

[root@rac1 yum.repos.d]# cat public-yum-ol6.repo

[ol6_latest]

name=Oracle Linux $releasever Latest($basearch)

baseurl=http://public-yum.oracle.com/repo/OracleLinux/OL6/latest/$basearch/

gpgkey=http://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol6

gpgcheck=1

enabled=1

 

[ol6_ga_base]

name=Oracle Linux $releasever GAinstallation media copy ($basearch)

baseurl=http://public-yum.oracle.com/repo/OracleLinux/OL6/0/base/$basearch/

gpgkey=http://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol6

gpgcheck=1

enabled=0

 

[ol6_u1_base]

name=Oracle Linux $releasever Update 1installation media copy ($basearch)

baseurl=http://public-yum.oracle.com/repo/OracleLinux/OL6/1/base/$basearch/

gpgkey=http://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol6

gpgcheck=1

enabled=0

 

[ol6_u2_base]

name=Oracle Linux $releasever Update 2installation media copy ($basearch)

baseurl=http://public-yum.oracle.com/repo/OracleLinux/OL6/2/base/$basearch/

gpgkey=http://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol6

gpgcheck=1

enabled=0

 

[ol6_UEK_latest]

name=Latest Unbreakable Enterprise Kernelfor Oracle Linux $releasever ($basearch)

baseurl=http://public-yum.oracle.com/repo/OracleLinux/OL6/UEK/latest/$basearch/

gpgkey=http://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol6

gpgcheck=1

enabled=0

 

[ol6_UEK_base]

name=Unbreakable Enterprise Kernel forOracle Linux $releasever ($basearch)

baseurl=http://public-yum.oracle.com/repo/OracleLinux/OL6/UEK/base/$basearch/

gpgkey=http://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol6

gpgcheck=1

enabled=0

[root@rac1 yum.repos.d]#

 

2.4 安裝oracle-rdbms-server-11gR2-preinstall包

 

[root@rac1 ~]# yum install oracle-rdbms-server-11gR2-preinstall

Loaded plugins: refresh-packagekit

file:///media/disk/Server/repodata/repomd.xml:[Errno 14] Could not open/read file:///media/disk/Server/repodata/repomd.xml

Trying other mirror.

google-chrome                                           |  951 B     00:00    

google-chrome/primary                                    | 1.4 kB     00:00    

google-chrome                                                              3/3

ol6_latest                                              | 1.1 kB     00:00    

ol6_latest/primary                                       | 15 MB     17:50    

ol6_latest                                                         14782/14782

Setting up Install Process

Resolving Dependencies

--> Running transaction check

---> Packageoracle-rdbms-server-11gR2-preinstall.x86_64 0:1.0-3.el6 will be installed

--> Finished Dependency Resolution

 

Dependencies Resolved

 

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

 Package                                Arch     Version    Repository    Size

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

Installing:

 oracle-rdbms-server-11gR2-preinstall   x86_64  1.0-3.el6   ol6_latest    15 k

 

Transaction Summary

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

Install       1 Package(s)

 

Total download size: 15 k

Installed size: 31 k

Is this ok [y/N]: y

Downloading Packages:

oracle-rdbms-server-11gR2-preinstall-1.0-3.el6.x86_64.rp|  15 kB     00:05    

warning: rpmts_HdrFromFdno: Header V3RSA/SHA256 Signature, key ID ec551f03: NOKEY

Retrieving key fromhttp://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol6

Importing GPG key 0xEC551F03:

 Userid: "Oracle OSS group (Open SourceSoftware group) <build@oss.oracle.com>"

 From  :http://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol6

Is this ok [y/N]: y

Running rpm_check_debug

Running Transaction Test

Transaction Test Succeeded

Running Transaction

 Installing : oracle-rdbms-server-11gR2-preinstall-1.0-3.el6.x86_64        1/1

 

Installed:

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

 

Complete!

You have new mail in /var/spool/mail/root

[root@rac1 ~]#

安裝Preinstall 包時，會自動檢查並修改各種配置和需求，具體修改的內容，在第一部分有說明。

 

三．驗證

安裝完後就完成了我們的配置工作，就可以進行下一步的安裝配置了。檢查一下Preinstall 包做的修改。

 

3.1 /etc/sysctl.conf 檔案

[root@rac1 ~]# cat /etc/sysctl.conf

# Kernel sysctl configuration file for RedHat Linux

#

# For binary values, 0 is disabled, 1 isenabled.  See sysctl(8) and

# sysctl.conf(5) for more details.

 

# Controls IP packet forwarding

net.ipv4.ip_forward = 0

 

# Controls source route verification

net.ipv4.conf.default.rp_filter = 1

 

# Do not accept source routing

net.ipv4.conf.default.accept_source_route =0

 

# Controls the System Request debuggingfunctionality of the kernel

kernel.sysrq = 0

 

# Controls whether core dumps will appendthe PID to the core filename.

# Useful for debugging multi-threadedapplications.

kernel.core_uses_pid = 1

 

# Controls the use of TCP syncookies

net.ipv4.tcp_syncookies = 1

 

# Disable netfilter on bridges.

net.bridge.bridge-nf-call-ip6tables = 0

net.bridge.bridge-nf-call-iptables = 0

net.bridge.bridge-nf-call-arptables = 0

 

# Controls the maximum size of a message,in bytes

kernel.msgmnb = 65536

 

# Controls the default maxmimum size of amesage queue

kernel.msgmax = 65536

 

# Controls the maximum shared segment size,in bytes

 

# Controls the maximum number of sharedmemory segments, in pages

 

# oracle-rdbms-server-11gR2-preinstall setting for fs.file-max is 6815744

fs.file-max = 6815744

 

# oracle-rdbms-server-11gR2-preinstall setting for kernel.sem is '250 32000 100 128'

kernel.sem = 250 32000 100 128

 

# oracle-rdbms-server-11gR2-preinstall setting for kernel.shmmni is 4096

kernel.shmmni = 4096

 

# oracle-rdbms-server-11gR2-preinstallsetting for kernel.shmall is 1073741824

kernel.shmall = 1073741824

 

# oracle-rdbms-server-11gR2-preinstallsetting for kernel.shmmax is 4398046511104 on x86_64

kernel.shmmax = 4398046511104

 

# oracle-rdbms-server-11gR2-preinstallsetting for net.core.rmem_default is 262144

net.core.rmem_default = 262144

 

# oracle-rdbms-server-11gR2-preinstallsetting for net.core.rmem_max is 4194304

net.core.rmem_max = 4194304

 

# oracle-rdbms-server-11gR2-preinstallsetting for net.core.wmem_default is 262144

net.core.wmem_default = 262144

 

# oracle-rdbms-server-11gR2-preinstallsetting for net.core.wmem_max is 1048576

net.core.wmem_max = 1048576

 

# oracle-rdbms-server-11gR2-preinstallsetting for fs.aio-max-nr is 1048576

fs.aio-max-nr = 1048576

 

# oracle-rdbms-server-11gR2-preinstallsetting for net.ipv4.ip_local_port_range is 9000 65500

net.ipv4.ip_local_port_range = 9000 65500

 

You have new mail in /var/spool/mail/root

[root@rac1 ~]#

 

3.2 /etc/security/limits.conf檔案

 

[root@rac1 ~]# cat/etc/security/limits.conf

# /etc/security/limits.conf

#

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

oracle  soft   nofile    1024

 

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

oracle  hard   nofile    65536

 

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

oracle  soft   nproc    2047

 

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

oracle  hard   nproc    16384

 

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

oracle  soft   stack    10240

 

# oracle-rdbms-server-11gR2-preinstallsetting for stack hard limit is 10240KB

oracle  hard   stack    32768

 

 

3.3 設定kernelboot 核心啟動參數numa=off ，關閉numa功能

[root@rac1 ~]# cat cat /boot/grub/grub.conf

default=0

timeout=5

splashimage=(hd0,0)/grub/splash.xpm.gz

hiddenmenu

title Oracle Linux Server-uek(2.6.32-100.34.1.el6uek.x86_64)

       root(hd0,0)

       kernel/vmlinuz-2.6.32-100.34.1.el6uek.x86_64 roroot=UUID=b1d2de8e-de31-4deb-b4e8-755c0ed01616 rd_NO_LUKS rd_NO_LVM rd_NO_MDrd_NO_DM LANG=en_US.UTF-8 SYSFONT=latarcyrheb-sun16 KEYBOARDTYPE=pcKEYTABLE=us  rhgb quiet numa=off

       initrd/initramfs-2.6.32-100.34.1.el6uek.x86_64.img

title Oracle Linux Server(2.6.32-131.0.15.el6.x86_64)

       root(hd0,0)

       kernel/vmlinuz-2.6.32-131.0.15.el6.x86_64 roroot=UUID=b1d2de8e-de31-4deb-b4e8-755c0ed01616 rd_NO_LUKS rd_NO_LVM rd_NO_MDrd_NO_DM LANG=en_US.UTF-8 SYSFONT=latarcyrheb-sun16 KEYBOARDTYPE=pc KEYTABLE=uscrashkernel=auto rhgb quiet numa=off

       initrd/initramfs-2.6.32-131.0.15.el6.x86_64.img

[root@rac1 ~]#

 

 

 

 

 

 

 

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

著作權，文章允許轉載，但必須以連結方式註明源地址，否則追究法律責任!

Skype: tianlesoftware

Email:   tianlesoftware@gmail.com

Blog:     http://www.tianlesoftware.com

Weibo: http://weibo.com/tianlesoftware

Twitter: http://twitter.com/tianlesoftware

Facebook: http://www.facebook.com/tianlesoftware

Linkedin: http://cn.linkedin.com/in/tianlesoftware

 

 

-------加群需要在備忘說明Oracle資料表空間和資料檔案的關係，否則拒絕申請----

DBA1 群：62697716(滿);   DBA2 群：62697977(滿)  DBA3 群：62697850(滿)  

DBA 超級群：63306533(滿);  DBA4 群：83829929   DBA5群： 142216823

DBA6 群：158654907    DBA7 群：172855474   DBA總群：104207940