RHEL6+oracle11gR2+ASM+升级到11.2.0.4.8+单实例安装_oracle 11gr2 rac rhel6.8-优快云博客

磁盘空间	3.8Gb Database 5.5 GB Grid Infrastructure
内存(RAM)	Database: minimum 1GB, recommended 2GB Grid Infrastructure for standalone server: minimum 1.5GB (plus another 1GB if installing Database too), recommended 4GB
交换空间(swap)	If RAM between 1 GB and 2 GB then 1.5 times the size fo RAM. If RAM between 2 GB to 16 GB then equal to the size of RAM. If RAM greater than 16 GB then 16 GB.
Tmp空间	At least 1 GB
Packages	binutils-2.20.51.0.2-5.43.el6.x86_64 compat-libcap1-1.10-1.x86_64 compat-libstdc++-33.x86_64gcc-4.4.7-16.el6.x86_64 elfutils-libelf-devel.x86_64 gcc-c++-4.4.7-16.el6.x86_64 glibc-2.12-1.166.el6.x86_64 glibc-devel-2.12-1.166.el6.x86_64 ksh-20120801-28.el6.x86_64 libgcc-4.4.7-16.el6.x86_64 libstdc++-4.4.7-16.el6.x86_64 libstdc++-devel-4.4.7-16.el6.x86_64 libaio-0.3.107-10.el6.x86_64 libaio-devel-0.3.107-10.el6.x86_64 make-3.81-20.el6.x86_64 sysstat-9.0.4-27.el6.x86_64 安装包命令： yum install -y binutils compat-libcap1 compat-libstdc++ gcc gcc-c++ glibc glibc-devel ksh libgcc libstdc++ libstdc++-devel libaio libaio-devel make sysstat elfutils-libelf-devel

2.2修改内核参数（/etc/sysctl.conf）

# cat > /etc/sysctl.conf << EOF

net.ipv4.ip_forward = 0

net.ipv4.conf.default.rp_filter = 1

net.ipv4.conf.default.accept_source_route =0

kernel.sysrq = 0

kernel.core_uses_pid = 1

net.ipv4.tcp_syncookies = 1

kernel.msgmnb = 65536

kernel.msgmax = 65536

fs.aio-max-nr = 1048576

fs.file-max = 6815744

kernel.shmall = 2097152

kernel.shmmax = 1073741824

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

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 = 1048576

EOF

#sysctl-p

参数解释：

kernel.shmall	是指在任意时刻，系统中可以分配的所有共享内存段的总和的最大值，kernel.shmall >= kernel.shmmax/pagesize ,此处为最小值的4倍
kernel.shmmax	#设置为物理内存大小，也可以根据实际情况设置为其一半
kernel.shmmni = 4096	最小内存大小，也是pagesize大小，为4K，可以通过命令getconf PAGE_SIZE来查看
kernel.sem	等号右边四个分别是semmsl,semmns,semopm,semmni的值
file-max	该参数表示文件句柄的最大数量，用于指定每个进程可以打开的最大文件数量
net.ipv4.ip_local_port_range	表示用于向外连接的端口范围
net.core.rmem_default	表示接收套接字缓冲区大小
net.core.rmem_max	最大socket读buffer,可参考的优化值:873200
net.core.wmem_default	表示发送套接字缓冲区大小
net.core.wmem_max	最大socket写buffer,可参考的优化值:873200

2.3配置oracle、grid账户shell限制（/etc/security/limits.conf）

2.3.1修改/etc/security/limits.conf文件

# cat >> /etc/security/limits.conf<< EOF

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

grid soft nproc 2047

grid hard nproc 16384

grid soft nofile 1024

grid hard nofile 65536

grid soft stack 10240

EOF

2.3.2 添加以下内容到/etc/pam.d/login
修改命令：

cat>> /etc/pam.d/login << EOF

session required /lib/security/pam_limits.so

EOF

解释：

要使 limits.conf 文件配置生效，必须要确保 pam_limits.so 文件被加入到启动文件中。查看 /etc/pam.d/login 文件中有：session required /lib/security/pam_limits.so

2.3.3修改/etc/profile文件

添加以下内容到/etc/profile，提高oracle和grid用户的shell限制

修改命令：

# cat>> /etc/profile << EOF

if [ $USER = "oracle" ] || [ $USER ="grid" ]; then

if [ $SHELL = "/bin/ksh" ];then

ulimit -p 16384

ulimit -n 65536

else

ulimit -u 16384 -n 65536

umask 022

EOF

使其生效

# source/etc/profile

2.4修改/etc/hosts文件

修改/etc/hosts文件：

# vi /etc/hosts

192.168.1.111 rhel6 rhel6.oracle.com

2.5用户、组、目录、环境变量的配置

2.5.1创建用户和组

#groupadd dba

#useradd -g dba grid

# useradd -g dba oracle

2.5.2创建目录及授权

# mkdir -p /app/grid

# mkdir -p /app/oracle

# mkdir /app/oraInventory

# chown -R grid:dba/app/oraInventory

# chown -R oracle:dba /app/oracle/

# chown -R 775 /app/oracle/

# chown -R grid:dba /app/grid/

# chown -R 775 /app/grid/

2.5.3配置grid、oracle用户环境变量

grid用户：

# su – grid

$vi .bash_profile

export ORACLE_SID=+ASM

export ORACLE_BASE=/app/grid

export ORACLE_HOME=$ORACLE_BASE/11.2.0/grid

export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

exportPATH=$ORACLE_HOME/bin:$PATH:/usr/local/bin/:.

$ source .bash_profile

oracle用户：

# su - oracle

$ vi .bash_profile

export ORACLE_BASE=/app/oracle

export ORACLE_HOME=$ORACLE_BASE/product/11.0.2/db_1

export ORACLE_SID=orcl

export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

export PATH=$ORACLE_HOME/bin:$PATH

$ source .bash_profile

2.6使用裸设备配置ASM磁盘

# vi 60-raw.rules

ACTION=="add",KERNEL=="sdb", OWNER=="grid", GROUP=="dba",RUN+="/bin/raw /dev/raw/raw1 %N"

ACTION=="add",KERNEL=="sdc", OWNER=="grid", GROUP=="dba",RUN+="/bin/raw /dev/raw/raw2 %N"

ACTION=="add",KERNEL=="sdd", OWNER=="grid", GROUP=="dba",RUN+="/bin/raw /dev/raw/raw3 %N"

ACTION=="add",KERNEL=="raw[1-3]", OWNER=="grid", GROUP=="dba",MODE=="0660"

重启服务：

# start_udev

查看裸设备：

# raw –qa 或者 # ll /dev/raw

3.Grid Infrastructure安装

3.1下载并解压grid软件包

# unzipp13390677_112040_Linux-x86-64_3of7.zip

修改权限：

# chown -R grid:dba grid/

# su – grid

$ cd grid/

运行：

$ ./runInstaller

3.2执行步骤

屏幕名称	回应
下载更新软件	选择“Skip”，单击下一步
安装选择	选择为独立的服务器配置GI
数据库语言	选择 English,单击下一步
配置ASM磁盘	根据需要添加ASM磁盘组
ASM实例密码设置	自定义
特权用户组设置	均为dba
安装路径选择	ORACLE_BASE:/app/grid ORACLE_HOME:/app/grid/11.2.0/grid
创建oraInventory目录	/app/oraInventory/
先决性检查	检查通过，则进行安装，否则需要解决一些问题
概要	选择安装
执行配置脚本	安装完成时，将提示您运行 root.sh 脚本。需要记住的是，要依次执行脚本。
安装结束	安装结束时，退出 OUI。

3.3执行步骤图片概览

解决问题：

检查说找不到 pdksh-5.2.14包，需要到网上下载，然后使用rpm装上去：

# rpm -ivh pdksh-5.2.14-30.x86_64.rpm

warning: pdksh-5.2.14-30.x86_64.rpm: HeaderV3 DSA/SHA1 Signature, key ID 73307de6: NOKEY

error: Failed dependencies:

pdksh conflicts with ksh-20120801-28.el6.x86_64

先删除冲突的包：

[root@rhel6 software]# rpm -e --nodeps ksh-20120801-28.el6.x86_64

再安装：

[root@rhel6 software]# rpm -ivh pdksh-5.2.14-30.x86_64.rpm

warning: pdksh-5.2.14-30.x86_64.rpm: HeaderV3 DSA/SHA1 Signature, key ID 73307de6: NOKEY

Preparing... (100%########################################### [100%]

1:pdksh ( 17%########################################### [100%]

然后点击’Check again’进行重新检查，检查通过后进行安装，等待即可。

依次执行脚本，第二个脚本执行需要一定的时间，因为它要开启集群的服务。

执行完所有脚本后，返回运行窗口，点击’OK’，继续安装。

安装完毕。

3.4检查安装

检查GI安装情况：

通过grid用户执行crs_stat -t 检查asm是否安装好

$ crs_stat -t

可以看到相关的服务已经成功开启，说明GI已经安装成功！

启动ASM服务：crs_start -all

也可以通过连接ASM实例来证明GI的安装是否成功：

4.安装数据库软件

下载并依次解压数据库软件包（2个）：

# unzip p13390677_112040_Linux-x86-64_1of7.zip

# unzip p13390677_112040_Linux-x86-64_2of7.zip

# chown -R oracle:dba database/

切换到oracle用户执行安装

# su - oracle

$ cd database/

运行$ ./runInstaller

开始安装oracle软件。

具体的概览图在此处就省略了，要注意几个选择，分别是“安装单实例”、“只安装数据库软件”、“路径”的选择，其他的就确认下一步，最后检查通过进行安装。

屏幕名称	回应
配置安全更新	取消选择，单击下一步
下载更新软件	选择“Skip”，单击下一步
选择安装类型	选择单实例
GI选项	选择独立的服务器
数据库语音	选择 English,单击下一步
数据库版本选择	选择相关组件（企业版、标准版等）
指定安装位置	ORACLE_BASE:/app/oracle ORACLE_HOME:/app/oracle/product/11.2.0/db_1
特权操作系统组	OSDBA组：dba OSOPER组: dba
产品特定的先决性检查	检查通过
创建数据库	仅安装数据库软件
概要	选择安装
执行配置脚本	安装完成时，将提示您运行 root.sh 脚本。 # /app/oracle/product/11.0.2/db_1/root.sh
安装结束	安装结束时，退出 OUI。

5.升级GI PSU、DB PSU

从11.2.0.4.0升级到11.2.0.4.8，升级注意：只需要下载GI PSU，因为其包含了DB PSU，升级的时候需要先升级GI HOME，然后升级DB HOME，最后如果有需要的话就要执行脚本。

5.1更新OPatch工具

[grid@rhel6 ~]$ /app/grid/11.2.0/grid/OPatch/opatchversion

OPatch Version: 11.2.0.3.4

OPatch succeeded.

[grid@rhel6~]$ /app/grid/11.2.0/grid/OPatch/opatch lsinventory

Oracle Interim PatchInstaller version 11.2.0.3.4

Oracle Home : /app/grid/11.2.0/grid

Central Inventory :/app/oraInventory

from : /app/grid/11.2.0/grid/oraInst.loc

OPatch version : 11.2.0.3.4

OUI version : 11.2.0.4.0

Log filelocation :/app/grid/11.2.0/grid/cfgtoollogs/opatch/opatch2015-10-23_17-24-36PM_1.log

LsinventoryOutput file location : /app/grid/11.2.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2015-10-23_17-24-36PM.txt

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

Installed Top-level Products (1):

Oracle Grid Infrastructure 11g 11.2.0.4.0

There are 1 products installed in thisOracle Home.

There are no Interim patches installed inthis Oracle Home.

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

OPatch succeeded.

更新OPatch工具到GI_HOME和DB_HOME：

更新到GI_HOME：

#su - grid

$ unzip p6880880_112000_Linux-x86-64.zip -d/app/grid/11.2.0/grid/

再次查看：

$ /app/grid/11.2.0/grid/OPatch/opatch version

OPatch Version:11.2.0.3.12 ==》已经从11.2.0.3.4更新成11.2.0.3.12

OPatch succeeded.

更新到DB_HOME：

# su - oracle

$ unzip p6880880_112000_Linux-x86-64.zip -d/app/oracle/product/11.0.2/db_1/

列出所有已经安装的组件：

$ $ORACLE_HOME/OPatch/opatch lsinventory-detail -oh $ORACLE_HOME

5.2配置OCM

注意：响应文件（response file）ocm.rsp是opatch auto命令必需使用的参数文件，所以必需创建

root用户：

# cd /app/grid/11.2.0/grid/OPatch/ocm/bin/

# ls

dummy emocmrsp

# ./emocmrsp

OCM Installation Response Generator10.3.7.0.0 - Production

Provide your email address to be informedof security issues, install and

initiate Oracle Configuration Manager.Easier for you if you use your My

Oracle Support Email address/User Name.

Visithttp://www.oracle.com/support/policies.html for details.

Email address/User Name:

You have not provided an email address fornotification of security issues.

Do you wish to remain uninformed ofsecurity issues ([Y]es, [N]o) [N]: Y

The OCM configurationresponse file (ocm.rsp) was successfully created.

# ls

dummy emocmrsp ocm.rsp

5.3安装GI PSU and DB PSU

5.3.1 GI PSU补丁

5.3.1.1 解压GI PSU补丁（包含了DB PSU）

在解压之前，需要确定解压到的目录必须为空，且不能为/tmp，而且安装的组要有相应的权限在该目录：

# unzip p21523375_112040_Linux-x86-64.zip-d /home/grid/GI_DB_PSU/

# chown -R grid:dba 21523375/

5.3.1.2 运行打补丁程序

以root用户执行：

打gi_home补丁（GI PSU补丁）

# chmod 777/app/grid/11.2.0/grid/OPatch/ocm/bin/ocm.rsp

#/app/grid/11.2.0/grid/OPatch/opatch auto /home/grid/GI_DB_PSU/21523375 -ocmrf/app/grid/11.2.0/grid/OPatch/ocm/bin/ocm.rsp

对于auto patch失败的部分，无需rollback，再次auto即可

打完补丁之后，GI_HOME的权限改变了，需要改回来：

# chown -R grid:dba /app/grid/11.2.0/grid/

5.3.1.3 检查打了哪些补丁

$ $ORACLE_HOME/OPatch/opatch lspatches

21352635;Database Patch Set Update :11.2.0.4.8 (21352635)

OPatch succeeded.

# su – grid
$ $ORACLE_HOME/OPatch/opatch lsinventory

5.3.2 DB PSU补丁

5.3.2.1 进入DB PSU目录

进入到GI PSU解压目录，然后进入到指定的DB PSU目录：

$ cd 21352635/

5.3.2.2 运行打补丁程序

$/app/oracle/product/11.0.2/db_1/OPatch/opatch apply

或者使用root用户执行：

# exportORACLE_HOME=/app/ora11g/product/11.2.0/db_1
# $ORACLE_HOME/OPatch/opatch auto 21352635/ -oh $ORACLE_HOME -ocmrf /app/grid/11.2.0/grid/OPatch/ocm/bin/ocm.rsp（注意，该方法打完补丁后记得要把ORACLE_HOME的目录权限改回来）

5.3.2.3 打完补丁后期工作

# su –oracle
$ $ORACLE_HOME/OPatch/opatch lsinventory

5.4 打完补丁后期工作

注意：此步骤是在建库之后才能进行的。即如果本来没有实例，则要先创建实例，再执行脚本；若本来就有实例，则在打完补丁之后执行脚本即可。

如果存在数据库或新建的数据库，使用General, Data Warehouse, Transaction Processing这三种方式创建的需要执行脚本，

Using DBCA (Database ConfigurationAssistant) to select a sample database (General, DataWarehouse, Transaction Processing) or Using a script that was created by DBCAthat creates a database from a sample database

执行脚本（只需要在数据库实例上执行即可）

[oracle@rhel6 ~]$ cd/app/oracle/product/11.0.2/db_1/rdbms/admin/

[oracle@rhel6 admin]$ sqlplus / as sysdba

SQL>@catbundle.sql psu apply #更新dba_registry_historyview以便使用psu

…

SQL> show errors;

No errors.

当没有看到脚本catbundle.sql执行过程提示有无效对象时，可以不用再执行utlrp.sql。

当然，如果要执行的话也是可以的，一样的执行方法：

[oracle@rhel6 admin]$ cd/app/oracle/product/11.0.2/db_1/rdbms/admin/

[oracle@rhel6 admin]$ sqlplus / as sysdba

SQL>@utlrp.sql

…

SQL> show errors;

No errors.

检查日志，查看脚本执行是否报错： $ORACLE_BASE/cfgtoollogs/catbundle for any errors:

catbundle_PSU__APPLY_.log

catbundle_PSU__GENERATE_.log

6.建库DBCA

oracle用户操作

6.1创建监听

$ netmgr或者 $netca

按照常规配置即可，以后有需要可以再修改

6.2 建库

运行$ dbca

此时，点击下一步时遇到错误：

解决方法：

grid用户：

[grid@rhel6 ~]$ cd/app/grid/11.2.0/grid/bin/

[grid@rhel6 bin]$ ll oracle

-rwxr-x--x. 1 grid dba 210098085 Oct 2318:32 oracle

oracle用户：

[oracle@rhel6 ~]$ cd/app/oracle/product/11.0.2/db_1/bin/

[oracle@rhel6 bin]$ ll oracle

-rwsr-s--x. 1 oracle dba 239811917 Oct 2319:07 oracle

修改ORACLE_HOME/bin/oracle的权限为6751：

[grid@rhel6 bin]$ chmod6751 $ORACLE_HOME/bin/oracle

[oracle@rhel6 bin]$ chmod6751 $ORACLE_HOME/bin/oracle

取消所有的组件：

内存管理选择自定义手动设置：

size标签处的block size根据客户要求更改，进程数一般为2000~3000：

字符集标签选择中文简体，其他默认即可，点击下一步：

进行文件大小的设置：

控制文件，设为两个，存放在不同位置：

表空间设置，因为默认都是自动扩展的，所有在建完库之后要取消所有表空间的自动扩展特性，特别是TEMP和UNDO表空间：

日志文件的设置，一般使用默认的3个日志组，每个组设置两个成员，大小为1G或2G，设置完成后，点击下一步：

点击完成开始安装实例：

安装完毕后退出安装界面。

检验实例是否创建成功：

7.附录

7.1安装GI执行脚本过程

#/app/oraInventory/orainstRoot.sh

Changing permissions of /app/oraInventory.

Adding read,write permissions for group.

Removing read,write,execute permissions forworld.

Changing groupname of /app/oraInventory todba.

The execution of the script is complete.

[root@rhel6software]# /app/grid/11.2.0/grid/root.sh

Performing root user operation for Oracle11g

The following environment variables are setas:

ORACLE_OWNER= grid

ORACLE_HOME= /app/grid/11.2.0/grid

Enter the full pathname of the local bindirectory: [/usr/local/bin]:

Copying dbhome to /usr/local/bin ...

Copying oraenv to /usr/local/bin ...

Copying coraenv to /usr/local/bin ...

Creating /etc/oratab file...

Entries will be added to the /etc/oratabfile as needed by

Database Configuration Assistant when adatabase is created

Finished running generic part of rootscript.

Now product-specific root actions will beperformed.

Using configuration parameter file:/app/grid/11.2.0/grid/crs/install/crsconfig_params

Creating trace directory

LOCAL ADD MODE

Creating OCR keys for user 'grid', privgrp'dba'..

Operation successful.

LOCAL ONLY MODE

Successfully accumulated necessary OCRkeys.

Creating OCR keys for user 'root', privgrp'root'..

Operation successful.

CRS-4664: Node rhel6 successfully pinned.

Adding Clusterware entries to upstart

rhel6 2015/10/23 16:03:20 /app/grid/11.2.0/grid/cdata/rhel6/backup_20151023_160320.olr

Successfully configuredOracle Grid Infrastructure for a Standalone Server

7.2GI PSU打补丁过程

[root@rhel6 bin]# /app/grid/11.2.0/grid/OPatch/opatchauto /home/grid/GI_DB_PSU/21523375 -ocmrf/app/grid/11.2.0/grid/OPatch/ocm/bin/ocm.rsp

Executing /app/grid/11.2.0/grid/perl/bin/perl/app/grid/11.2.0/grid/OPatch/crs/patch11203.pl -patchdir /home/grid/GI_DB_PSU-patchn 21523375 -ocmrf /app/grid/11.2.0/grid/OPatch/ocm/bin/ocm.rsp -paramfile/app/grid/11.2.0/grid/crs/install/crsconfig_params

This is the main log file: /app/grid/11.2.0/grid/cfgtoollogs/opatchauto2015-10-23_20-06-27.log

This file will show your detectedconfiguration and all the steps that opatchauto attempted to do on your system:

/app/grid/11.2.0/grid/cfgtoollogs/opatchauto2015-10-23_20-06-27.report.log

2015-10-23 20:06:27: Starting OracleRestart Patch Setup

Using configuration parameter file:/app/grid/11.2.0/grid/crs/install/crsconfig_params

Stopping CRS...

Stopped CRS successfully

patch/home/grid/GI_DB_PSU/21523375/21352635 apply successful for home /app/grid/11.2.0/grid

patch/home/grid/GI_DB_PSU/21523375/21352649 apply successful for home /app/grid/11.2.0/grid

patch/home/grid/GI_DB_PSU/21523375/21352642 apply failed for home /app/grid/11.2.0/grid

Starting CRS...

CRS-4123: Oracle High Availability Serviceshas been started.

opatch auto succeeded.

7.2.1检查GI PSU打补丁情况

[grid@rhel6~]$ $ORACLE_HOME/OPatch/opatch lsinventory

Oracle Interim Patch Installer version11.2.0.3.12

Oracle Home : /app/grid/11.2.0/grid

Central Inventory : /app/oraInventory

from :/app/grid/11.2.0/grid/oraInst.loc

OPatch version : 11.2.0.3.12

OUI version : 11.2.0.4.0

Log file location :/app/grid/11.2.0/grid/cfgtoollogs/opatch/opatch2015-10-23_21-19-12PM_1.log

Lsinventory Output file location :/app/grid/11.2.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2015-10-23_21-19-12PM.txt

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

Local Machine Information::

Hostname: rhel6

ARU platform id: 226

ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Grid Infrastructure 11g 11.2.0.4.0

There are 1 products installed in thisOracle Home.

Interim patches (2) :

Patch 21352649 : applied on Fri Oct 23 20:37:24 CST 2015

Unique Patch ID: 19203841

Patch description: "OCW Patch Set Update : 11.2.0.4.8(21352649)"

Created on 2 Sep 2015, 23:43:49 hrs PST8PDT

Bugs fixed:

19270660, 18328800, 18508710, 18691572, 21251192, 20365005, 17750548

17387214, 17617807, 14497275, 20219458, 17733927, 18180541, 18962892

17292250, 17378618, 16759171, 20110156, 17843489, 17065496, 13991403

17273020, 17155238, 21245437, 18261183, 18053580, 20218012, 20995001

17039197, 17947785, 16317771, 10052729, 20340620, 20317221, 15917869

18199185, 18399991, 20186278, 17374271, 18024089, 16849642, 20746251

20246071, 14270845, 18882642, 18414137, 17001914, 17927970, 14378120

16346413, 15986647, 18068871, 21222147, 18143836, 16206997, 19168690

20235511, 18343490, 16613232, 19276791, 17722664, 20440643, 12928658

18952577, 18520351, 16249829, 18226143, 18265482, 18229842, 17172091

20676340, 17818075, 20091753, 18231837, 14373486, 17483479, 18120545

18729166, 13843841, 21225209, 17405302, 18709496, 18330979, 18744838

17087371, 20531190, 14525998, 18187697, 20598625, 14385860, 18348155

19479503, 12928592, 17516024, 18370031, 17764053, 19272663, 17551223

14671408, 18272135, 14207615, 17500165,18875012, 18464784, 19558324

18848125, 19241857, 14851828, 17955615, 20315294, 14693336, 16284825

17352230, 20014326, 17238586, 17089344, 17405605, 17531342, 17159489

17640316, 13823394, 16543190, 17983675, 17598201, 17481314, 16281493

18346135, 15986311, 19601468, 17208793, 18700935, 18999857, 14076173

18428146, 18352845, 17435488, 18352846, 17391726, 17387779, 14777968

15851860, 16206882, 20141091, 20175174, 17305100, 15832129, 19885321

16901346, 17985714, 18536826, 17780903, 18752378, 18946768, 16876500

16875342, 17769597, 19955755, 16429265, 18336452, 17273003, 17209968

16988311, 20094984, 19319357, 17059927, 17046460, 18053631, 16867761

18774591, 21442094, 20235486, 19359787, 15869775, 19642566, 17447588

16798862, 15920201

Patch 21352635 : applied on Fri Oct 23 20:27:33 CST 2015

Unique Patch ID: 19227862

Patch description: "Database Patch Set Update : 11.2.0.4.8(21352635)"

Created on 1 Sep 2015, 07:49:44 hrs

Sub-patch 20760982; "Database Patch Set Update : 11.2.0.4.7 (20760982)"

Sub-patch 20299013; "Database Patch Set Update : 11.2.0.4.6 (20299013)"

Sub-patch 19769489; "Database Patch Set Update : 11.2.0.4.5 (19769489)"

Sub-patch 19121551; "Database Patch Set Update : 11.2.0.4.4 (19121551)"

Sub-patch 18522509; "Database Patch Set Update : 11.2.0.4.3 (18522509)"

Sub-patch 18031668; "Database Patch Set Update : 11.2.0.4.2 (18031668)"

Sub-patch 17478514; "Database Patch Set Update : 11.2.0.4.1 (17478514)"

Bugs fixed:

17288409, 21051852, 18607546, 17205719, 17811429, 17816865, 20506699

17922254, 17754782, 16934803, 13364795, 17311728, 17441661, 17284817

16992075, 17446237, 14015842, 19972569, 21538558, 20925795, 17449815

17375354, 19463897, 17982555, 17235750, 13866822, 18317531, 17478514

18235390, 14338435, 20803583, 13944971, 20142975, 17811789, 16929165

18704244, 20506706, 17546973, 20334344, 14054676, 17088068, 18264060

17346091, 17343514, 21538567, 19680952, 18471685, 19211724, 13951456

16315398, 18744139, 16850630, 19049453, 18673304, 17883081, 19915271

18641419, 18262334, 17006183, 16065166, 18277454, 16833527, 10136473

18051556, 17865671, 17852463, 18554871, 17853498, 18334586, 17588480

17551709, 19827973, 17842825, 17344412, 18828868, 17025461, 11883252

13609098, 17239687, 17602269, 19197175, 18316692, 17313525, 12611721

19544839, 18964939, 17600719, 18191164, 19393542, 17571306, 18482502

20777150, 19466309, 17040527, 17165204, 18098207, 16785708, 17174582

16180763, 17465741, 16777840, 12982566, 19463893, 12816846, 16875449

17237521, 19358317, 17811438, 17811447, 17945983, 18762750, 17184721

16912439, 18061914, 17282229, 18331850, 18202441, 17082359, 18723434

19554106, 14034426, 18339044, 19458377, 17752995, 20448824, 17891943

17258090, 17767676, 16668584, 18384391, 17040764, 17381384, 15913355

18356166, 14084247, 20506715, 13853126, 18203837, 14245531, 16043574

17848897, 17877323, 17468141, 17786518, 17912217, 17037130, 18155762

16956380, 17478145, 17394950, 18189036, 18641461, 18619917, 17027426

21352646, 16268425, 19584068, 18436307, 17265217, 17634921, 13498382

20004087, 17443671, 18000422, 20004021, 17571039, 21067387, 16344544

18009564, 14354737, 18135678, 18614015, 20441797, 18362222, 17835048

16472716, 17936109, 17050888, 17325413, 14010183, 18747196, 17761775

16721594, 17082983, 20067212, 21179898, 17302277, 18084625, 15990359

18203835, 17297939, 17811456, 16731148, 17215560, 13829543, 14133975

17694209, 18091059, 17385178, 8322815, 17586955, 17201159, 17655634

18331812, 19730508, 18868646, 17648596, 16220077, 16069901, 17348614

17393915, 17274537, 17957017, 18096714, 17308789, 18436647, 14285317

19289642, 14764829, 18328509, 17622427, 16943711, 14368995, 17346671

18996843, 17783588, 16618694, 17672719, 18856999, 18783224, 17851160

17546761, 17798953, 18273830, 19972566, 16384983, 17726838, 17360606

13645875, 18199537, 16542886, 17889549, 14565184, 17071721, 20299015

17610798, 20657441, 17397545, 18230522, 16360112, 19769489, 12905058

18641451, 12747740, 18430495, 17042658, 17016369, 14602788, 19972568

18508861, 19788842, 14657740, 17332800, 13837378, 19972564, 17186905

18315328, 19699191, 17437634, 19006849, 19013183, 17296856, 18674024

17232014, 16855292, 21051840, 14692762, 17762296, 17705023, 19121551

19854503, 19309466, 18681862, 18554763, 20558005, 17390160, 18456514

16306373, 13955826, 18139690, 17501491, 17299889, 17752121, 17889583

18673325, 18293054, 17242746, 17951233, 17649265, 18094246, 19615136

17011832, 16870214, 17477958, 18522509, 20631274, 16091637, 17323222

16595641, 16524926, 18228645, 18282562, 17596908, 17156148, 18031668

16494615, 17545847, 17614134, 13558557, 17341326, 17891946, 17716305

16392068, 19271443, 18092127, 18440047, 17614227, 14106803, 16903536

18973907, 18673342, 17389192, 16194160, 17006570, 17612828, 17721717

17570240, 17390431, 16863422, 18325460, 19727057, 16422541, 19972570

17267114, 18244962, 21538485, 18765602, 18203838, 16198143, 17246576

14829250, 17835627, 18247991, 14458214, 21051862, 16692232, 17786278

17227277, 16042673, 16314254, 16228604, 16837842, 17393683, 17787259

20331945, 20074391, 15861775, 16399083, 18018515, 18260550, 21051858

17036973, 16613964, 17080436, 16579084, 18384537, 18280813, 20296213

16901385, 15979965, 18441944, 16450169, 9756271, 17892268, 11733603

16285691, 17587063, 16538760, 18180390, 18193833, 21051833, 17238511

17824637, 16571443, 18306996, 14852021, 18674047, 17853456, 12364061

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

OPatch succeeded.

7.3 DB PSU打补丁过程

DB PSU补丁：

#su- oracle

$/app/oracle/product/11.0.2/db_1/OPatch/opatch apply

Oracle Interim Patch Installer version11.2.0.3.12

Oracle Home : /app/oracle/product/11.0.2/db_1

Central Inventory : /app/oraInventory

from :/app/oracle/product/11.0.2/db_1/oraInst.loc

OPatch version : 11.2.0.3.12

OUI version : 11.2.0.4.0

Log file location :/app/oracle/product/11.0.2/db_1/cfgtoollogs/opatch/opatch2015-10-23_21-54-25PM_1.log

Verifying environment and performingprerequisite checks...

OPatch continues with these patches: 17478514 18031668 18522509 19121551 19769489 20299013 20760982 21352635

Do you want to proceed? [y|n]

User Responded with: Y

All checks passed.

Provide your email address to be informedof security issues, install and

initiate Oracle Configuration Manager.Easier for you if you use your My

Oracle Support Email address/User Name.

Visithttp://www.oracle.com/support/policies.html for details.

Email address/User Name:

You have not provided an email address fornotification of security issues.

Do you wish to remain uninformed ofsecurity issues ([Y]es, [N]o) [N]: Y

Please shutdown Oracle instances runningout of this ORACLE_HOME on the local system.

(Oracle Home ='/app/oracle/product/11.0.2/db_1')

Is the local system ready for patching?[y|n]

User Responded with: Y

Backing up files...

Applying sub-patch '17478514' to OH'/app/oracle/product/11.0.2/db_1'

Patching component oracle.rdbms,11.2.0.4.0...

Patching component oracle.rdbms.rsf,11.2.0.4.0...

Patching component oracle.sdo,11.2.0.4.0...

Patching component oracle.sysman.agent,10.2.0.4.5...

Patching component oracle.xdk,11.2.0.4.0...

Patching component oracle.rdbms.dbscripts,11.2.0.4.0...

Patching component oracle.sdo.locator,11.2.0.4.0...

Patching component oracle.nlsrtl.rsf,11.2.0.4.0...

Patching component oracle.xdk.rsf,11.2.0.4.0...

Patching component oracle.rdbms.rman,11.2.0.4.0...

Applying sub-patch '18031668' to OH'/app/oracle/product/11.0.2/db_1'

Patching component oracle.rdbms,11.2.0.4.0...

Patching component oracle.rdbms.rsf,11.2.0.4.0...

Patching component oracle.ldap.rsf,11.2.0.4.0...

Patching component oracle.rdbms.crs,11.2.0.4.0...

Patching component oracle.precomp.common,11.2.0.4.0...

Patching component oracle.ldap.rsf.ic,11.2.0.4.0...

Patching component oracle.rdbms.deconfig,11.2.0.4.0...

Patching component oracle.rdbms.dbscripts,11.2.0.4.0...

Patching component oracle.rdbms.rman,11.2.0.4.0...

Applying sub-patch '18522509' to OH'/app/oracle/product/11.0.2/db_1'

Patching component oracle.rdbms.rsf,11.2.0.4.0...

Patching component oracle.rdbms,11.2.0.4.0...

Patching component oracle.precomp.common,11.2.0.4.0...

Patching component oracle.rdbms.rman,11.2.0.4.0...

Patching component oracle.rdbms.dbscripts,11.2.0.4.0...

Patching component oracle.rdbms.deconfig,11.2.0.4.0...

Applying sub-patch '19121551' to OH '/app/oracle/product/11.0.2/db_1'

Patching component oracle.precomp.common,11.2.0.4.0...

Patching componentoracle.sysman.console.db, 11.2.0.4.0...

Patching component oracle.rdbms.rsf,11.2.0.4.0...

Patching component oracle.rdbms.rman,11.2.0.4.0...

Patching component oracle.rdbms,11.2.0.4.0...

Patching component oracle.rdbms.dbscripts,11.2.0.4.0...

Patching component oracle.ordim.client,11.2.0.4.0...

Patching component oracle.ordim.jai,11.2.0.4.0...

Applying sub-patch '19769489' to OH'/app/oracle/product/11.0.2/db_1'

ApplySession: Optional component(s) [oracle.sysman.agent, 11.2.0.4.0 ] notpresent in the Oracle Home or a higher version is found.

Patching component oracle.precomp.common,11.2.0.4.0...

Patching component oracle.ovm,11.2.0.4.0...

Patching component oracle.xdk,11.2.0.4.0...

Patching component oracle.rdbms.util,11.2.0.4.0...

Patching component oracle.rdbms,11.2.0.4.0...

Patching component oracle.rdbms.dbscripts,11.2.0.4.0...

Patching component oracle.xdk.parser.java,11.2.0.4.0...

Patching component oracle.oraolap,11.2.0.4.0...

Patching component oracle.rdbms.rsf,11.2.0.4.0...

Patching component oracle.xdk.rsf,11.2.0.4.0...

Patching component oracle.rdbms.rman,11.2.0.4.0...

Patching component oracle.rdbms.deconfig,11.2.0.4.0...

Applying sub-patch '20299013' to OH'/app/oracle/product/11.0.2/db_1'

Patching component oracle.rdbms.dv,11.2.0.4.0...

Patching component oracle.rdbms.oci,11.2.0.4.0...

Patching component oracle.precomp.common,11.2.0.4.0...

Patching component oracle.sysman.agent,10.2.0.4.5...

Patching component oracle.xdk,11.2.0.4.0...

Patching component oracle.sysman.common,10.2.0.4.5...

Patching component oracle.rdbms,11.2.0.4.0...

Patching component oracle.rdbms.dbscripts,11.2.0.4.0...

Patching component oracle.xdk.parser.java,11.2.0.4.0...

Patching componentoracle.sysman.console.db, 11.2.0.4.0...

Patching component oracle.xdk.rsf,11.2.0.4.0...

Patching component oracle.rdbms.rsf,11.2.0.4.0...

Patching componentoracle.sysman.common.core, 10.2.0.4.5...

Patching component oracle.rdbms.rman,11.2.0.4.0...

Patching component oracle.rdbms.deconfig,11.2.0.4.0...

Applying sub-patch '20760982' to OH'/app/oracle/product/11.0.2/db_1'

Patching componentoracle.sysman.console.db, 11.2.0.4.0...

Patching component oracle.rdbms,11.2.0.4.0...

Patching component oracle.rdbms.dbscripts,11.2.0.4.0...

Applying sub-patch '21352635' to OH'/app/oracle/product/11.0.2/db_1'

Patching component oracle.sysman.agent,10.2.0.4.5...

Patching component oracle.rdbms.rsf,11.2.0.4.0...

Patching component oracle.rdbms.rman,11.2.0.4.0...

Patching component oracle.rdbms,11.2.0.4.0...

Composite patch 21352635 successfullyapplied.

Log filelocation:/app/oracle/product/11.0.2/db_1/cfgtoollogs/opatch/opatch2015-10-23_21-54-25PM_1.log

OPatch succeeded.

7.3.1 检查DB PSU打补丁情况

[oracle@rhel621352635]$ /app/oracle/product/11.0.2/db_1/OPatch/opatch lsinventory

Oracle Interim Patch Installer version11.2.0.3.12

Oracle Home : /app/oracle/product/11.0.2/db_1

Central Inventory : /app/oraInventory

from :/app/oracle/product/11.0.2/db_1/oraInst.loc

OPatch version : 11.2.0.3.12

OUI version : 11.2.0.4.0

Log file location :/app/oracle/product/11.0.2/db_1/cfgtoollogs/opatch/opatch2015-10-23_22-15-00PM_1.log

Lsinventory Output file location :/app/oracle/product/11.0.2/db_1/cfgtoollogs/opatch/lsinv/lsinventory2015-10-23_22-15-00PM.txt

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

Local Machine Information::

Hostname: rhel6

ARU platform id: 226

ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Database 11g 11.2.0.4.0

There are 1 products installed in thisOracle Home.

Interim patches (1) :

Patch 21352635 : applied on Fri Oct 23 22:07:52 CST 2015