Description of Oracle RDBMS server 11gr2 preinstall RPM package in Oracle Linux 6

Source: Internet
Author: User
Tags change settings

 

In Oracle Linux 5, we can use ORACLE validated configuration to accelerate the deployment of the Oracle environment. For more information about validated deployments, see:

Oraclevalidated configurations installation instructions

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

 

In Oracle Linux 6, Oracle validate package was not launched, but a oracle-rdbms-server-11gR2-preinstall package was launched.

 

I. Official Website description

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 gglad 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.

-- Check before installing Oracle 11gr2 in Oracle Linux 6. The pre-install package can help us complete most of the configuration work.

 

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

-- In oraclelinux 6, the oracle-rdbms-server-11gR2-preinstall package is only 64-bit, use this package can implement the following functions:

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

-- Download and install various dependency packages

(2) creates theuser Oracle and the groups oinstall and DBA, Which areThe defaults used during Database Installation

-- Create an oracle user and a group.

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

-- Modify the kernel parameters of/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

-- Set the/etc/security/limits. conf file.

(5) sets NUMA = off in Thekernel boot parameters for x86_64 machines

-- Set NUMA = off on a 64-bit host

 

 

2. Install the oracle-rdbms-server-11gR2-preinstall package

 

2.1 go to the yum configuration directory

[Root @ Rac1 ~] # Cd/etc/yum. Repos. d/

 

2.2 download Yum Configuration

[Root @ Rac1 yum. Repos. d] # wget http://public-yum.oracle.com/public-yum-ol6.repo

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

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.4 K) [text/plain]

Saving to: "public-yum-ol6.repo"

 

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

 

20:48:01 (30.8 Mb/s)-"public-yum-ol6.repo" saved [1461/1461]

 

2.3 view Yum Configuration

# Cat public-yum-ol6.repo [root @ Rac1 yum. Repos. d] #

[Ol6_latest]

Name = Oracle Linux $ releasever latest ($ basearch)

Baseurl = http://public-yum.oracle.com/repo/?lelinux/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/?lelinux/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 1 installation media copy ($ basearch)

Baseurl = http://public-yum.oracle.com/repo/?lelinux/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 2 installation media copy ($ basearch)

Baseurl = http://public-yum.oracle.com/repo/?lelinux/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/?lelinux/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/?lelinux/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 install oracle-rdbms-server-11gR2-preinstall package

 

[Root @ Rac1 ~] # Yum install oracle-rdbms-server-11gR2-preinstall

Loaded plugins: refresh-packagekit

File: // media/Disk/Server/repodata/repomd. XML: [errno 14] cocould not open/Read File: // media/Disk/Server/repodata/repomd. XML

Trying other mirror.

Google-chrome | 951 B: 00

Google-Chrome/primary | 1.4 kb: 00

Google-Google Chrome 3/3

Ol6_latest | 1.1 kb: 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-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

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 ~] #

When the preinstall package is installed, various configurations and requirements are automatically checked and modified. The specific modification content is described in the first part.

 

Iii. Verification

After the installation is complete, we can proceed with the next installation configuration. Check the changes made by the preinstall package.

 

3.1/etc/sysctl. conf file

[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 '2017 250 32000 100'

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 file

 

[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

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 set the kernelboot kernel startup parameter NUMA = off to disable the NUMA Function

[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 ~] #

 

 

 

 

 

 

 

Bytes -------------------------------------------------------------------------------------------------------

All rights reserved. reprinted articles are allowed, but source addresses must be indicated by links. Otherwise, the documents will be held legally responsible!

Skype: tianlesoftware

Email: tianlesoftware@gmail.com

Blog: http://www.tianlesoftware.com

WEAVER: http://weibo.com/tianlesoftware

Twitter: http://twitter.com/tianlesoftware

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

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

 

 

------- Add a group to describe the relationship between Oracle tablespace and data files in the remarks section. Otherwise, reject the application ----

Dba1 group: 62697716 (full); dba2 group: 62697977 (full) dba3 group: 62697850 (full)

Super DBA group: 63306533 (full); dba4 group: 83829929 dba5 group: 142216823

Dba6 group: 158654907 dba7 group: 172855474 DBA group: 104207940

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.