Oracle 11.2.0.4升级到11.2.0.4.18 详细步骤

11.2.0.4单机安装完成后升级到11.2.0.4.18的详细步骤：

步骤：

1、 先下载psu补丁包：

https://support.oracle.com/epmos/faces/DocumentDisplay?id=1454618.1&displayIndex=3#aref_section230

2、 确认补丁包的版本和适配

在readme 中

3、 安装

 

安装记录：

1、 下载补丁包，确认版本

[oracle@dg1bao]$ ll

total203780

-rw-r--r--1 oracle oinstall 110236755 May 25 23:35 p24732075_112040_Linux-x86-64.zip

-rw-r--r--1 oracle oinstall  98352086 May 27 09:37p6880880_112000_Linux-x86-64.zip

 

2、 升级Opath

[oracle@dg1OPatch]$ pwd

/oracle/app/oracle/product/11.2.0/dbhome_4/OPatch

（1）先确认版本：

[oracle@dg1OPatch]$ ./opatch version

OPatchVersion: 11.2.0.3

OPatchsucceeded.

（2）备份Opath

[oracle@bsplinuxoracle]$ tar zcvf opatch_bk.tar OPatch

（3）解压覆盖(其实可以把原Opath删掉再解压)

unzip p6880880_112000_Linux-x86-64.zip –d $ORACLE_HOME

（4）验证

[oracle@dg1OPatch]$ ./opatch version

OPatchVersion: 11.2.0.3.15

OPatchsucceeded.

 

3、 升级database

（1）解压

[oracle@dg1bao]$ unzip p24732075_112040_Linux-x86-64.zip -d /oracle/app/oracle/product/11.2.0/dbhome_4/

（2）收集升级前信息

升级之前：

[oracle@dg1OPatch]$ ./opatch lsinventory

OracleInterim Patch Installer version 11.2.0.3.15

Copyright(c) 2017, Oracle Corporation.  All rightsreserved.

OracleHome       :/oracle/app/oracle/product/11.2.0/dbhome_4

CentralInventory : /oracle/oraInventory

   from          :/oracle/app/oracle/product/11.2.0/dbhome_4/oraInst.loc

OPatchversion    : 11.2.0.3.15

OUIversion       : 11.2.0.4.0

Log filelocation :/oracle/app/oracle/product/11.2.0/dbhome_4/cfgtoollogs/opatch/opatch2017-05-27_10-21-35AM_1.log

LsinventoryOutput file location :/oracle/app/oracle/product/11.2.0/dbhome_4/cfgtoollogs/opatch/lsinv/lsinventory2017-05-27_10-21-35AM.txt

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

LocalMachine Information::

Hostname:dg1

ARUplatform id: 226

ARUplatform description:: Linux x86-64

InstalledTop-level Products (1):

OracleDatabase 11g                                                 11.2.0.4.0

Thereare 1 products installed in this Oracle Home.

Thereare no Interim patches installed in this Oracle Home.

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

OPatchsucceeded.

[oracle@dg1OPatch]$ ./opatch lspatches

Thereare no Interim patches installed in this Oracle Home"/oracle/app/oracle/product/11.2.0/dbhome_4".

OPatchsucceeded.

SQL>select version, id, bundle_series, comments from dba_registry_history;

VERSION               ID BUNDLE_SERIES                  COMMENTS

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

                 8289601                                viewinvalidation

11.2.0.4.0                                             Upgraded from 11.2.0.1.0

11.2.0.4               0 PSU                            Patchset 11.2.0.2.0

 

（3）关闭数据库和监听

SQL> shutdown immediate ;

[oracle@dg1bao]$ lsnrctl stop

（4）在补丁包目录下使用$ORACLE_HOME下Opath打补丁

[oracle@dg1dbhome_4]$ pwd

/oracle/app/oracle/product/11.2.0/dbhome_4/24732075

检查：

[oracle@dg124732075]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./

-bash:opatch: command not found

[oracle@dg124732075]$ /oracle/app/oracle/product/11.2.0/dbhome_4/OPatch/opatch prereqCheckConflictAgainstOHWithDetail -ph ./

OracleInterim Patch Installer version 11.2.0.3.15

Copyright(c) 2017, Oracle Corporation.  All rightsreserved.

PREREQsession

OracleHome       :/oracle/app/oracle/product/11.2.0/dbhome_4

CentralInventory : /oracle/oraInventory

   from           :/oracle/app/oracle/product/11.2.0/dbhome_4/oraInst.loc

OPatchversion    : 11.2.0.3.15

OUIversion       : 11.2.0.4.0

Log filelocation :/oracle/app/oracle/product/11.2.0/dbhome_4/cfgtoollogs/opatch/opatch2017-05-27_10-35-36AM_1.log

Invokingprereq "checkconflictagainstohwithdetail"

Prereq"checkConflictAgainstOHWithDetail" passed.

OPatchsucceeded.

开始应用:

[oracle@dg124732075]$/oracle/app/oracle/product/11.2.0/dbhome_4/OPatch/opatch apply

OracleInterim Patch Installer version 11.2.0.3.15

Copyright(c) 2017, Oracle Corporation.  All rightsreserved.

OracleHome       :/oracle/app/oracle/product/11.2.0/dbhome_4