oracle升级包安装,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 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 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 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 () 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/,如需转载,请注明出处,否则将追究法律责任。

相关资源:oracle10.2补丁
表情包
插入表情
评论将由博主筛选后显示,对所有人可见 | 还能输入1000个字符
相关推荐
©️2020 CSDN 皮肤主题: 1024 设计师:白松林 返回首页