oracle 11g 安装

OS系统部分

install oracle 11g below information is from oracle install doc. The Oracle Unbreakable Enterprise Kernel for Linux is available for x86-64 platforms. It is based on a stable 2.6.32 Linux kernel, and also includes optimizations二 17:27


2012年11月20日 17:27


172.16.21.231
root/123456

OS系统部分

install oracle 11g
below information is from oracle install doc.

The Oracle Unbreakable Enterprise Kernel for Linux is available for x86-64 platforms. It is based on a stable 2.6.32 Linux kernel, and also includes optimizations developed in collaboration with Oracle Database, Oracle middleware, and Oracle hardware engineering teams to ensure stability and optimal performance for the most demanding enterprise workloads.


Oracle highly recommends deploying the Oracle Unbreakable Enterprise Kernel in your Linux environment, especially if you run Oracle software. However, using Oracle Unbreakable Enterprise Kernel is optional. If you require strict Red Hat Enterprise Linux kernel (RHEL) compatibility, then Oracle Linux also includes a kernel compatible with the RHEL Linux kernel, compiled directly from the Red Hat Enterprise Linux source code.

The Oracle Unbreakable Enterprise Linux kernel installs directly on top of Oracle Linux 5, or Red Hat Enterprise Linux 5, starting with Update 5, so you are not required to upgrade to a new major release of the operating system to obtain the benefits and features of this new kernel.

Operating System Requirements

The following or later versions of the operating system are required for Oracle Database 11g Release 2 (11.2):

Asianux Server 3 SP2

Oracle Linux 4 Update 7

Oracle Linux 5 Update 2

Oracle Linux 5 Update 5 (with the Oracle Unbreakable Enterprise Kernel for Linux)

Red Hat Enterprise Linux 4 Update 7

Red Hat Enterprise Linux 5 Update 2

Red Hat Enterprise Linux 5 Update 5 (with the Oracle Unbreakable Enterprise Kernel for Linux)

SUSE Linux Enterprise Server 10 SP2

SUSE Linux Enterprise Server 11

Starting with Oracle Database 11g Release 2 (11.2), the Security Enhanced Linux (SE Linux) feature is supported for Oracle Linux 4, Red Hat Enterprise Linux 4, Oracle Linux 5, and Red Hat Enterprise Linux 5.

Note:

For Asianux Server, Oracle Linux, and Red Hat Enterprise Linux, system requirements are identical by kernel version. Specifically:
Oracle Linux 4 and Red Hat Enterprise Linux 4 requirements are the same.

Asianux Server 3, Oracle Linux 5, and Red Hat Enterprise Linux 5 requirements are the same.

Oracle Unbreakable Enterprise Kernel for Linux 5 Update 5 (2.6.32) and above, available for x86-64 systems, contains several additional features and performance enhancements not available either with Oracle Linux or with other supported Linux distributions. This kernel can be installed on either Oracle Linux or Red Hat Enterprise Linux distributions. Before installing the Oracle Unbreakable Enterp

rise Kernel, you must have Oracle Linux 5 Update 5 or Red Hat Enterprise Linux 5 Update 5 installed on an x86-64 server.

Package Requirements

If you are using Oracle Unbreakable Enterprise Kernel, then all required kernel packages are installed as part of the Oracle Unbreakable Enterprise Kernel installation.


2012-03-09
# install Oracle Unbreakable Enterprise Kernel
cd /etc/yum.repos.d
wget https://www.sodocs.net/doc/4912401262.html,/public-yum-el5.repo

# Edit both the [el5_u5_base] and [ol5_u5_base] stanzas and change enable=0 to enable=1 as follows:
[el5_u5_base]
name=Enterprise Linux $releasever U5 - $basearch - base
baseurl=http://publicyum.
https://www.sodocs.net/doc/4912401262.html,/repo/EnterpriseLinux/EL5/5/base/$basearch/
gpgkey=https://www.sodocs.net/doc/4912401262.html,/RPM-GPG-KEY-oracle-el5
gpgcheck=1
enable=1

[ol5_u5_base]
name=Oracle Linux $releasever - U5 - x86_64 - base
baseurl=http://publicyum.
https://www.sodocs.net/doc/4912401262.html,/repo/OracleLinux/OL5/5/base/x86_64/
gpgkey=https://www.sodocs.net/doc/4912401262.html,/RPM-GPG-KEY-oracle-el5
gpgcheck=1
enable=1

#To update your system kernel, do one of the following
yum install kernel
# or yum install oracle-linux


#kernel value for oracle-linux
semopm should be 100
file-max should be 6815744
ip_local_port_range Minimum: 9000 Maximum: 65500
rmem_default should be 262144
rmem_max should be 4194304
wmem_default should 262144
wmem_max 1048576
aio-max-nr Maximum: 1048576


vi /etc/sysctl.conf

kernel.sem = 250 32000 100 128
fs.file-max = 6815744
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048586
fs.aio-max-nr = 1048576


vi /etc/security/limits.conf

oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft stack 10240




数据库部分

# this oracle 11g doc is based on Oracle Linux 5 Update 5


#Package Requirements

#If you are using Oracle Unbreakable Enterprise Kernel, then all required kernel packages are installed as part of the Oracle Unbreakable Enterprise Kernel installation.


# login OS as root

#create OS groups and Users
#3 group "oinstall,dba,oper(optional)" need to be created
#1 user "oracle" need to be created

#before create them, check whether they exist
more /etc/oraInst.loc

egrep 'oinstall|dba|oper' /etc/group
id oracle

#create groups
groupadd oinstall
groupadd dba

#optional
groupadd oper

#create users
useradd -g oinstall -G dba oracle
passwd oracle

#Configuring Kernel Parameters
#check below value

cat /proc/sys/kernel/sem
cat /proc/sys/kernel/shmall
cat /proc/sys/kernel/shmmax
cat /proc/sys/kernel/shmmni
cat /proc/sys/fs/file-max
cat /proc/sys/net/ipv4/ip_local_port_range
cat /proc/sys/net/core/rmem_default
cat /proc/sys/net/core/rmem_max
cat /proc/sys/net/

core/wmem_default
cat /proc/sys/net/core/wmem_max
cat /proc/sys/fs/aio-max-nr

/***************************************************************************
edit /etc/sysctl.conf

kernel.sem = 250 32000 100 128
fs.file-max = 6815744
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048586
fs.aio-max-nr = 1048576

***************************************************************************/
#after modify /etc/sysctl.conf
sysctl -p

su - oracle
#check above value again

#Check Resource Limits for the Oracle Software Installation Users
/***********************************************************************************
Installation Owner Resource Limit Recommended Ranges

Resource Shell Limit Resource Soft Limit Hard Limit
Open file descriptors
nofile at least 1024 at least 65536

Number of processes available to a single user
nproc at least 2047 at least 16384

Size of the stack segment of the process
stack at least 10240 KB at least 10240 KB, and at most 32768 KB

***********************************************************************************/



#Log in as an installation owner.
su - oracle

#Check the soft and hard limits for the file descriptor setting. Ensure that the result is in the recommended range.
ulimit -Sn
ulimit -Hn

#Check the soft and hard limits for the number of processes available to a user. Ensure that the result is in the recommended range.
ulimit -Su
ulimit -Hu

#Check the soft limit for the stack setting. Ensure that the result is in the recommended range.
ulimit -Ss
ulimit -Hs

#If necessary, update the resource limits in the /etc/security/limits.conf configuration file for the installation owner. For example, add the following lines to the /etc/security/limits.conf file:
/*************************************************************************************
#add below code into /etc/security/limits.conf
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft stack 10240

Note:
The values mentioned in this example are illustrative and not actual values that must be added.

When the limits.conf file is changed, these changes take effect immediately. However, if the grid or oracle users are logged in, then these changes do not take effect until you log these users out and log them back in. You must do this before you attempt to use these accounts to install.
*************************************************************************************/


#Creating Required Directories

mkdir -p /u01/apps/
chown -R oracle:oinstall /u01/apps/
chmod -R 775 /u01/apps/



ORACLE_BAS

E=/u01/apps/oracle
ORACLE_SID=orcl
export ORACLE_BASE ORACLE_SID

#unzip two oracle install compress file
unzip linux.x64_11gR2_database_1of2.zip
unzip linux.x64_11gR2_database_2of2.zip

yum install -y gcc-4.1.2
yum install -y elfutils-libelf-devel*
yum install -y glibc-devel-2.5
yum install -y glibc-headers-2.5
yum install -y gcc-c++-4.1.2
yum install -y libaio-devel*
yum install -y libstdc++-devel-4.1.2
yum install -y sysstat-7.0.2
yum install -y unixODBC-2.2.11
yum install -y unixODBC-devel-2.2.11