Oracle 安装补丁

Oracle 安装补丁

---

1 下载补丁p6880880_112000_Linux-x86-64.zip

2 将补丁上传至/app/soft/grid 下
[root@exadata ~]#
[root@exadata ~]# cd /app/soft/grid/
[root@exadata grid]# ll
total 989476
drwxr-xr-x 8 grid oinstall      4096 Jan 22 09:20 grid
-rwxr-xr-x 1 grid oinstall 979195792 Jan 16 14:45 p10404530_112030_Linux-x86-64_3of7.zip
-rw-r--r-- 1 root root      33020933 Apr 14  2014 p6880880_112000_Linux-x86-64.zip
[root@exadata grid]#


2.1：opatch 安装(grid 与oracle 用户都需要安装)
root 用户登录,
[root@exadata grid]# cd /app/grid/grid11g/
[root@exadata grid11g]# ll | grep OPatch
drwxr-xr-x  7 grid oinstall  4096 Jan 22 11:08 OPatch
[root@exadata grid11g]# mv OPatch/ OPatch.bak
[root@exadata grid11g]# cp /app/soft/grid/p6880880_112000_Linux-x86-64.zip ./
[root@exadata grid11g]# unzip p
p6880880_112000_Linux-x86-64.zip  plsql/                            
perl/                             precomp/                          
[root@exadata grid11g]# unzip p6880880_112000_Linux-x86-64.zip

[root@exadata grid11g]# chown -R grid:oinstall OPatch
(如写入权限不足，则使用root 执行)

[root@exadata grid11g]# su - grid
[grid@exadata ~]$ . pro_asm

[grid@exadata ~]:+ASM> opatch version
OPatch Version: 11.2.0.3.6

OPatch succeeded.

[grid@exadata ~]:+ASM>

oracle 用户登录,
[grid@exadata ~]:+ASM> su - oracle
Password:
[oracle@exadata ~]$
[oracle@exadata ~]$ . pro_exadata
[oracle@exadata ~]:exadata> cd $ORACLE_HOME

[oracle@exadata ora11g]:exadata> ll | grep OPatch
drwxr-xr-x  7 oracle oinstall  4096 Jan 22 12:21 OPatch
[oracle@exadata ora11g]:exadata> mv OPatch/ OPatch.bak

[oracle@exadata ora11g]:exadata> cp /app/soft/grid/p6880880_112000_Linux-x86-64.zip ./
[oracle@exadata ora11g]:exadata> unzip p6880880_112000_Linux-x86-64.zip
[oracle@exadata ora11g]:exadata> opatch version
OPatch Version: 11.2.0.3.3
OPatch succeeded.
[oracle@exadata ora11g]:exadata>

2.2：生成OCM response file
Grid 用户登录
[oracle@exadata ora11g]:exadata> su - grid
Password:
[grid@exadata ~]$
[grid@exadata ~]$ . pro_asm
[grid@exadata ~]:+ASM> export JAVA_HOME=$ORACLE_HOME/jdk


[grid@exadata ~]:+ASM> $ORACLE_HOME/OPatch/ocm/bin/emocmrsp -no_banner -output /app/grid/ocm.rsp
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name: dong.du@123456.com
Provide your My Oracle Support password to receive security updates via your My Oracle Support account.
Password (optional):          
Unable to establish a network connection to Oracle. Specify the URL for an
Oracle Support Hub in this format:
    http[s]://:
If you do not wish to configure OCM through an Oracle Support Hub, enter NONE
Oracle Support Hub URL: NONE

Unable to establish a network connection to Oracle. If your systems require a
proxy server for outbound Internet connections, enter the proxy server details
in this format:
    [@][:]
If you want to remain uninformed of critical security issues in your
configuration, enter NONE
Proxy specification: NONE

The OCM configuration response file (/app/grid/ocm.rsp) was successfully created.


[grid@sztestdb1 oracle]:+ASM> $ORACLE_HOME/OPatch/ocm/bin/emocmrsp -no_banner
-output /app/grid/ocm.rsp
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name:
You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: y
The OCM configuration response file (/app/grid/ocm.rsp) was successfully created.
[grid@sztestdb1 oracle]:+ASM >





[grid@exadata ~]:+ASM> $ORACLE_HOME/OPatch/ocm/bin/emocmrsp -no_banner
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name: NONE
Invalid email address.

Email address/User Name: dong.du@123456.com
Provide your My Oracle Support password to receive security updates via your My Oracle Support account.
Password (optional):           
Unable to establish connection to Oracle Configuration Manager server.
Hostname (https://ccr.oracle.com) is unknown.

Unable to establish a network connection to Oracle. Specify the URL for an
Oracle Support Hub in this format:
    http[s]://:
If you do not wish to configure OCM through an Oracle Support Hub, enter NONE
Oracle Support Hub URL: NONE

Unable to establish a network connection to Oracle. If your systems require a
proxy server for outbound Internet connections, enter the proxy server details
in this format:
    [@][:]
If you want to remain uninformed of critical security issues in your
configuration, enter NONE
Proxy specification: NONE

The OCM configuration response file (ocm.rsp) was successfully created.
[grid@exadata ~]:+ASM>






2.3: 安装PSU 补丁

Root 用户执行：
su – root
cd /app/soft/grid
mkdir patch
mv p14727347_112030_Linux-x86-64.zip patch
cd patch
unzip p14727347_112030_Linux-x86-64.zip
chmod -R 755 /app/soft/grid/patch
export PATH=$PATH:/app/grid/grid11g/OPatch
执行安装：
cd /app/soft/grid/patch
opatch auto /app/soft/grid/patch -ocmrf /app/grid/ocm.rsp
如果执行报错：查看日志。
较多的错误是因为/app/grid/grid11g/lib/libclntsh.so.11.1 导致的，解决方法如下:
停止：crs
crsctl stop res -all
执行：/sbin/fuser /app/grid/grid11g/lib/libclntsh.so.11.1
停止CRS 之后,正常情况下只查到一个进程，如下方示例当中，如果有其它进程，则KILL 掉，
之后启动CRS，重新执行补丁程序。
[root@exadata lib]# /sbin/fuser /app/grid/grid11g/lib/libclntsh.so.11.1
/app/grid/grid11g/lib/libclntsh.so.11.1: 25080m
[root@exadata lib]# ps -ef|grep 25080
grid 25080 1 0 23:32 ? 00:00:00 /app/grid/grid11g/bin/ohasd.bin reboot
grid 26588 6639 0 23:36 pts/6 00:00:00 grep 25080
crsctl stop res -all
opatch auto /app/soft/grid/patch -ocmrf /app/grid/ocm.rsp



oracle 用户下执行
1. cd $ORACLE_HOME/rdbms/admin
2. sqlplus “/as sysdba”
3. SQL> STARTUP
4. SQL> @catbundle.sql psu apply
5. SQL> QUIT

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29500582/viewspace-1412083/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29500582/viewspace-1412083/