ORACLE12.2 升級之路 之 04(Oracle 11.2.0.4单实例打PSU补丁)

#Oracle 11.2.0.4单实例打PSU补丁的过程

#1.OPatch替换为最新版本

[oracle@XAG140 OPatch]$ cd $ORACLE_HOME/OPatch

[oracle@XAG140 OPatch]$ id

uid=1001(oracle) gid=1001(oinstall) groups=1001(oinstall),1002(dba),1003(oper)

[oracle@DB OPatch]$ ./opatch version

OPatch Version: 11.2.0.3.4

OPatch succeeded.

[oracle@XAG140 OPatch]$ cd ..

[oracle@XAG140 db_1]$ mv OPatch/ OPatch_bak

[oracle@XAG140 db_1]$ unzip /home/oracle/setup/p6880880_112000_Linux-x86-64.zip

[oracle@XAG140 db_1]$ ls

apex        config  dc_ocm      has            javavm  log      odbc        ord      racg          sqlj            uix

assistants  crs    deinstall    hs            jdbc    md      olap        oui      rdbms        sqlplus          usm

bin          csmig  demo        ide            jdev    mesg    OPatch      owb      relnotes      srvm            utl

ccr          css    diagnostics  install        jdk    mgw      OPatch_bak  owm      root.sh      suptools        wwg

cdata        ctx    dv          instantclient  jlib    network  opmn        perl    scheduler    sysman          xdk

cfgtoollogs  cv      emcli        inventory      ldap    nls      oracore      plsql    slax          timingframework

clone        dbs    EMStage      j2ee          lib    oc4j    oraInst.loc  precomp  sqldeveloper  ucp

[oracle@XAG140 db_1]$ cd OPatch

[oracle@XAG140 OPatch]$ ./opatch version

OPatch Version: 11.2.0.3.19

OPatch succeeded.

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

2.数据库软件应用p27734982_112040_Linux-x86-64补丁程序 24732075 (11.2.0.4.170418)

[oracle@XAG140 patch]$ pwd

/u01/app/patch

[oracle@XAG140 patch]$ unzip p27734982_112040_Linux-x86-64.zip

[oracle@XAG140 patch]$ ls

27734982  p27734982_112040_Linux-x86-64.zip  PatchSearch.xml

[oracle@XAG140 patch]$

[oracle@XAG140 patch]$ ls -lh

total 135M

drwxr-xr-x 21 oracle oinstall 4.0K May 31 17:49 27734982

-rw-r--r--  1 oracle oinstall 135M Aug 23 15:10 p27734982_112040_Linux-x86-64.zip

-rw-rw-r--  1 oracle oinstall  91K Jul 17 18:15 PatchSearch.xml

[oracle@XAG140 patch]$ cd 27734982/

[oracle@XAG140 27734982]$ ls

17478514  18522509  19769489  20760982  21948347  23054359  24732075  26392168  26925576  27734982    README.html

18031668  19121551  20299013  21352635  22502456  24006111  25869727  26609445  27338049  patchmd.xml  README.txt

[oracle@XAG140 27734982]$ pwd

/u01/app/patch/27734982

[oracle@XAG140 27734982]$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./

Oracle Interim Patch Installer version 11.2.0.3.19

Copyright (c) 2018, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home      : /u01/app/oracle/product/11.2.0/db_1

Central Inventory : /u01/app/oraInventory

  from          : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc

OPatch version    : 11.2.0.3.19

OUI version      : 11.2.0.4.0

Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2018-08-23_15-38-45PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

[oracle@XAG140 27734982]$

[oracle@XAG140 27734982]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Thu Aug 23 15:41:21 2018

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> !lsnrctl stop

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 23-AUG-2018 15:41:36

Copyright (c) 1991, 2013, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=XAG140)(PORT=1521)))

The command completed successfully

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

[oracle@XAG140 27734982]$ ls

17478514  18522509  19769489  20760982  21948347  23054359  24732075  26392168  26925576  27734982    README.html

18031668  19121551  20299013  21352635  22502456  24006111  25869727  26609445  27338049  patchmd.xml  README.txt

[oracle@XAG140 27734982]$

[oracle@XAG140 27734982]$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch apply

Oracle Interim Patch Installer version 11.2.0.3.19

Copyright (c) 2018, Oracle Corporation.  All rights reserved.

Oracle Home      : /u01/app/oracle/product/11.2.0/db_1

Central Inventory : /u01/app/oraInventory

  from          : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc

OPatch version    : 11.2.0.3.19

OUI version      : 11.2.0.4.0

Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2018-08-23_15-51-07PM_1.log

Verifying environment and performing prerequisite checks...

Prerequisite check "CheckSystemCommandAvailable" failed.

The details are:

Missing command :fuser

Prerequisite check "CheckSystemCommandAvailable" failed.

The details are:

Missing command :fuser

Prerequisite check "CheckSystemCommandAvailable" failed.

The details are:

Missing command :fuser

Prerequisite check "CheckSystemCommandAvailable" failed.

The details are:

Missing command :fuser

Prerequisite check "CheckSystemCommandAvailable" failed.

The details are:

Missing command :fuser

Prerequisite check "CheckSystemCommandAvailable" failed.

The details are:

Missing command :fuser

Prerequisite check "CheckSystemCommandAvailable" failed.

The details are:

Missing command :fuser

Prerequisite check "CheckSystemCommandAvailable" failed.

The details are:

Missing command :fuser

Prerequisite check "CheckSystemCommandAvailable" failed.

The details are:

Missing command :fuser

Prerequisite check "CheckSystemCommandAvailable" failed.

The details are:

Missing command :fuser

Prerequisite check "CheckSystemCommandAvailable" failed.

The details are:

Missing command :fuser

Prerequisite check "CheckSystemCommandAvailable" failed.

The details are:

Missing command :fuser

Prerequisite check "CheckSystemCommandAvailable" failed.

The details are:

Missing command :fuser

Prerequisite check "CheckSystemCommandAvailable" failed.

The details are:

Missing command :fuser

Prerequisite check "CheckSystemCommandAvailable" failed.

The details are:

Missing command :fuser

Prerequisite check "CheckSystemCommandAvailable" failed.

The details are:

Missing command :fuser

Prerequisite check "CheckSystemCommandAvailable" failed.

The details are:

Missing command :fuser

Prerequisite check "CheckSystemCommandAvailable" failed.

The details are:

Missing command :fuser

Prerequisite check "CheckSystemCommandAvailable" failed.

The details are:

Missing command :fuser

UtilSession failed:

Prerequisite check "CheckSystemCommandAvailable" failed.

Prerequisite check "CheckSystemCommandAvailable" failed.

Prerequisite check "CheckSystemCommandAvailable" failed.

Prerequisite check "CheckSystemCommandAvailable" failed.

Prerequisite check "CheckSystemCommandAvailable" failed.

Prerequisite check "CheckSystemCommandAvailable" failed.

Prerequisite check "CheckSystemCommandAvailable" failed.

Prerequisite check "CheckSystemCommandAvailable" failed.

Prerequisite check "CheckSystemCommandAvailable" failed.

Prerequisite check "CheckSystemCommandAvailable" failed.

Prerequisite check "CheckSystemCommandAvailable" failed.

Prerequisite check "CheckSystemCommandAvailable" failed.

Prerequisite check "CheckSystemCommandAvailable" failed.

Prerequisite check "CheckSystemCommandAvailable" failed.

Prerequisite check "CheckSystemCommandAvailable" failed.

Prerequisite check "CheckSystemCommandAvailable" failed.

Prerequisite check "CheckSystemCommandAvailable" failed.

Prerequisite check "CheckSystemCommandAvailable" failed.

Prerequisite check "CheckSystemCommandAvailable" failed.

Log file location: /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2018-08-23_15-51-07PM_1.log

OPatch failed with error code 73

[oracle@XAG140 27734982]$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch lspatches

There are no Interim patches installed in this Oracle Home "/u01/app/oracle/product/11.2.0/db_1".

OPatch succeeded.

[root@XAG140 ~]# yum search fuser

Loaded plugins: fastestmirror

Loading mirror speeds from cached hostfile

* base: mirror.centos.org

* extras: mirror.centos.org

* updates: mirror.centos.org

============================================================== Matched: fuser ===============================================================

psmisc.x86_64 : Utilities for managing processes on your system

[root@XAG140 ~]# yum install -y psmisc

Loaded plugins: fastestmirror

base                                                                                                                  | 3.6 kB  00:00:00   

extras                                                                                                                | 3.4 kB  00:00:00   

updates                                                                                                              | 3.4 kB  00:00:00   

Loading mirror speeds from cached hostfile

* base: mirror.centos.org

* extras: mirror.centos.org

* updates: mirror.centos.org

Resolving Dependencies

--> Running transaction check

---> Package psmisc.x86_64 0:22.20-15.el7 will be installed

--> Finished Dependency Resolution

Dependencies Resolved

=============================================================================================================================================

Package                        Arch                            Version                                Repository                    Size

=============================================================================================================================================

Installing:

psmisc                          x86_64                          22.20-15.el7                            base                          141 k

Transaction Summary

=============================================================================================================================================

Install  1 Package

Total download size: 141 k

Installed size: 475 k

Downloading packages:

psmisc-22.20-15.el7.x86_64.rpm                                                                                        | 141 kB  00:00:00   

Running transaction check

Running transaction test

Transaction test succeeded

Running transaction

Warning: RPMDB altered outside of yum.

  Installing : psmisc-22.20-15.el7.x86_64                                                                                                1/1

  Verifying  : psmisc-22.20-15.el7.x86_64                                                                                                1/1

Installed:

  psmisc.x86_64 0:22.20-15.el7                                                                                                             

Complete!

[root@XAG140 ~]#

[oracle@XAG140 27734982]$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch apply

#3.数据库打补丁

[oracle@DB 19121551]$ cd /u01/app/oracle/product/11.2.0/db_1/rdbms/admin/

[oracle@XAG140 admin]$ sqlplus / as sysdba

SQL> @catbundle.sql psu apply

#4.验证PSU补丁是否应用成功

[oracle@XAG140 OPatch]$ pwd

/u01/app/oracle/product/11.2.0/db_1/OPatch

[oracle@XAG140 OPatch]$

[oracle@XAG140 OPatch]$ ./opatch lspatches

27734982;Database Patch Set Update : 11.2.0.4.180717 (27734982)

OPatch succeeded.

[oracle@XAG140 OPatch]$ ./opatch lsinventory

Oracle Interim Patch Installer version 11.2.0.3.19

Copyright (c) 2018, Oracle Corporation.  All rights reserved.

Oracle Home      : /u01/app/oracle/product/11.2.0/db_1

Central Inventory : /u01/app/oraInventory

  from          : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc

OPatch version    : 11.2.0.3.19

OUI version      : 11.2.0.4.0

Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2018-08-23_17-55-36PM_1.log

Lsinventory Output file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2018-08-23_17-55-36PM.txt

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

Local Machine Information::

Hostname: XAG140

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 this Oracle Home.

Interim patches (1) :

Patch  27734982    : applied on Thu Aug 23 16:15:47 CST 2018

Unique Patch ID:  22229176

Patch description:  "Database Patch Set Update : 11.2.0.4.180717 (27734982)"

  Created on 31 May 2018, 01:37:49 hrs PST8PDT

Sub-patch  27338049; "Database Patch Set Update : 11.2.0.4.180417 (27338049)"

Sub-patch  26925576; "Database Patch Set Update : 11.2.0.4.180116 (26925576)"

Sub-patch  26392168; "Database Patch Set Update : 11.2.0.4.171017 (26392168)"

Sub-patch  26609445; "Database Patch Set Update : 11.2.0.4.170814 (26609445)"

Sub-patch  25869727; "Database Patch Set Update : 11.2.0.4.170718 (25869727)"

Sub-patch  24732075; "Database Patch Set Update : 11.2.0.4.170418 (24732075)"

Sub-patch  24006111; "Database Patch Set Update : 11.2.0.4.161018 (24006111)"

Sub-patch  23054359; "Database Patch Set Update : 11.2.0.4.160719 (23054359)"

Sub-patch  22502456; "Database Patch Set Update : 11.2.0.4.160419 (22502456)"

Sub-patch  21948347; "Database Patch Set Update : 11.2.0.4.160119 (21948347)"

Sub-patch  21352635; "Database Patch Set Update : 11.2.0.4.8 (21352635)"

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:

    21174504, 17184721, 21538558, 16091637, 18092127, 17381384, 15979965

    20671094, 16731148, 16314254, 13837378, 18441944, 17835048, 13558557

    17008068, 17201159, 25427662, 17853498, 20717359, 17246576, 18356166

    18681862, 18440047, 20569094, 20031873, 16875449, 20387265, 19788842

    17296856, 21330264, 14010183, 17648596, 17551063, 17025461, 24719736

    17267114, 22507210, 17912217, 17889583, 18202441, 17040764, 17478145

    16524926, 25655390, 19358317, 22148226, 18747196, 26544823, 18641419

    17036973, 18948177, 17811789, 16542886, 14285317, 18009564, 16618694

    8322815, 16832076, 18247991, 16692232, 22507234, 17570240, 13871092

    24624166, 24348685, 17848897, 17441661, 14034426, 17465741, 16596890

    17437634, 21343897, 20506706, 21453153, 18339044, 17951233, 22321741

    21795111, 18430495, 21787056, 22380919, 19469538, 20506715, 17811429

    19721304, 17903598, 18230522, 19554106, 19458377, 21281607, 17612828

    6599380, 22092979, 22321756, 17040527, 17811438, 18641461, 14657740

    13364795, 21387964, 19490948, 17346671, 17588480, 22351572, 18235390

    26474853, 18849970, 17889549, 19309466, 16472716, 20596234, 18331850

    18641451, 17344412, 21179898, 19461270, 17546761, 24842886, 14521849

    18203835, 18203838, 18964939, 18203837, 17313525, 22195457, 18139690

    16837842, 22296366, 14106803, 17842825, 21352646, 22657942, 16360112

    20657441, 22195441, 17389192, 26198926, 14565184, 17205719, 18440095

    14764829, 22195448, 14354737, 13944971, 16571443, 21868720, 17186905

    17080436, 18673342, 22905130, 17027426, 27374796, 19972569, 19972568

    20144308, 19972566, 17282229, 19972564, 16870214, 21629064, 19615136

    21354456, 17390431, 18762750, 23007241, 16613964, 17957017, 18098207

    18471685, 19730508, 21538485, 18264060, 17323222, 17754782, 17600719

    18317531, 17852463, 17596908, 17655634, 16228604, 27053456, 20074391

    19972570, 18090142, 18996843, 19854503, 16042673, 17835627, 20334344

    17393683, 20861693, 18000422, 17551709, 26575788, 23315889, 20506699

    19006849, 18277454, 18456514, 19174430, 17258090, 17174582, 25654936

    17242746, 16399083, 17824637, 21132297, 22465352, 17762296, 22168163

    17397545, 16450169, 12364061, 20067212, 18856999, 19211724, 19463893

    19463897, 21343775, 17853456, 18673304, 20004021, 26030218, 21668627

    16194160, 17477958, 16538760, 12982566, 24570598, 20828947, 18259031

    20296213, 18293054, 17610798, 19699191, 23065323, 17311728, 18135678

    18774543, 23294548, 16785708, 10136473, 24560906, 22551446, 19777862

    17786518, 18315328, 18334586, 12747740, 18096714, 19032867, 21641760

    17390160, 18899974, 17232014, 20598042, 18673325, 16422541, 18155762

    14015842, 19827973, 22683225, 17726838, 18554871, 23177648, 18051556

    20803583, 21972320, 15990359, 17922254, 18282562, 16855292, 16668584

    21343838, 20299015, 17446237, 18093615, 18043064, 23713236, 17694209

    17288409, 18308268, 20475845, 17274537, 13955826, 16934803, 17634921

    17501491, 16315398, 23725036, 22683212, 17006183, 13829543, 18191164

    17655240, 26746894, 22809871, 18384391, 19393542, 21538567, 16198143

    21847223, 25823754, 17892268, 20142975, 19584068, 17165204, 25165496

    18604493, 21756699, 18508861, 16901385, 18554763, 21532755, 18189036

    17443671, 17385178, 14829250, 17936109, 20925795, 20509482, 17478514

    27441326, 16850630, 13951456, 16595641, 14054676, 15861775, 21142837

    16912439, 17299889, 17297939, 23003979, 18619917, 16833527, 17798953

    17816865, 18607546, 17571306, 21286665, 17341326, 26910644, 17851160

    20558005, 17586955, 19049453, 21051840, 17587063, 16956380, 18328509

    25423453, 14133975, 18061914, 18522509, 21051833, 20294666, 18765602

    20860659, 20324049, 18199537, 17332800, 13609098, 22502493, 18384537

    14338435, 17945983, 16392068, 21067387, 17752995, 21051862, 16863422

    25505382, 17237521, 18244962, 19544839, 24433711, 24717859, 17156148

    18973907, 23026585, 17877323, 17449815, 18180390, 17088068, 17037130

    20004087, 21422580, 19466309, 11733603, 25505371, 21051858, 18084625

    18674024, 21051852, 18091059, 25369547, 16306373, 18306996, 17787259

    18193833, 19915271, 20513399, 20631274, 25879656, 16344544, 14692762

    18614015, 17346091, 18228645, 17721717, 18436307, 21756677, 19888853

    11883252, 17891943, 19475971, 22353199, 16384983, 19121551, 27825893

    12816846, 17982555, 17761775, 22243719, 17265217, 25505394, 17071721

    16721594, 18262334, 21756661, 17891946, 15913355, 17672719, 17602269

    17239687, 17042658, 17238511, 17811456, 17284817, 17752121, 20879889

    21380789, 17394950, 17011832, 16579084, 22195465, 14602788, 18325460

    24476265, 26569225, 24476274, 12611721, 16903536, 17006570, 19689979

    16043574, 18783224, 24662775, 16494615, 21526048, 17392698, 19197175

    16069901, 17811447, 27870645, 17308789, 22195477, 24835538, 17865671

    17343514, 19013183, 17325413, 18316692, 16180763, 17348614, 14368995

    21983325, 17393915, 16285691, 19211433, 20331945, 17883081, 17705023

    24316947, 17614227, 19578350, 22195485, 14084247, 13645875, 16777840

    19727057, 14852021, 18744139, 18674047, 17716305, 19285025, 18482502

    27534509, 17622427, 19289642, 22195492, 25947799, 14458214, 20869721

    21172913, 17767676, 18723434, 25505407, 17786278, 19258504, 17082983

    21351877, 17365043, 13498382, 18331812, 16065166, 25489607, 16685417

    18031668, 22893153, 16943711, 19272701, 21517440, 25897615, 17649265

    13866822, 18094246, 24528741, 17783588, 14245531, 17082359, 18280813

    20448824, 23330119, 16268425, 19487147, 25600421, 18018515, 17302277

    17215560, 24411921, 19271443, 25764020, 17016369, 20777150, 23330124

    16756406, 20441797, 19769489, 28100487, 17545847, 25093656, 18260550

    13853126, 17227277, 23536835, 25957038, 24652769, 19207117, 9756271

    18868646, 17614134, 26667023, 17546973, 18704244, 19680952, 26667015

    17050888, 18828868, 18273830, 17360606, 16992075, 24563422, 17375354

    12905058, 18362222, 21429602, 27086138, 17571039, 17468141, 18436647

    17235750, 21168487, 16220077, 16929165

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

OPatch succeeded.

SQL> select * from dba_registry_history;

  ACTION_TIME                   ACTION NAMESPACE VERSION ID BUNDLE_SERIES COMMENTS

1 24-AUG-13 12.03.45.119862 PM APPLY SERVER 11.2.0.4 0 PSU Patchset 11.2.0.2.0

2 23-AUG-18 03.24.44.382287 PM APPLY SERVER 11.2.0.4 0 PSU Patchset 11.2.0.2.0

3 23-AUG-18 04.48.52.034209 PM APPLY SERVER 11.2.0.4 180717 PSU PSU 11.2.0.4.180717


================================================================================================

#安装OJVM补丁集预检查

SQL> shutdown immediate

SQL> exit

[oracle@XAG140 patch]$ pwd

/u01/app/patch

[oracle@XAG140 patch]$ unzip p27923163_112040_Linux-x86-64.zip

[oracle@XAG140 patch]$ cd 27923163/

[oracle@XAG140 27923163]$  /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./

Oracle Interim Patch Installer version 11.2.0.3.19

Copyright (c) 2018, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home      : /u01/app/oracle/product/11.2.0/db_1

Central Inventory : /u01/app/oraInventory

  from          : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc

OPatch version    : 11.2.0.3.19

OUI version      : 11.2.0.4.0

Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2018-09-14_10-38-43AM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

#安装OJVM补丁集

[oracle@XAG140 27923163]$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch apply

Oracle Interim Patch Installer version 11.2.0.3.19

Copyright (c) 2018, Oracle Corporation.  All rights reserved.

Oracle Home      : /u01/app/oracle/product/11.2.0/db_1

Central Inventory : /u01/app/oraInventory

  from          : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc

OPatch version    : 11.2.0.3.19

OUI version      : 11.2.0.4.0

Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2018-09-14_11-14-10AM_1.log

Verifying environment and performing prerequisite checks...

OPatch continues with these patches:  27923163 

Do you want to proceed? [y|n]

y

User Responded with: Y

All checks passed.

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

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

(Oracle Home = '/u01/app/oracle/product/11.2.0/db_1')

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

y

User Responded with: Y

Backing up files...

Applying interim patch '27923163' to OH '/u01/app/oracle/product/11.2.0/db_1'

ApplySession: Optional component(s) [ oracle.sqlj, 11.2.0.4.0 ] , [ oracle.sqlj.companion, 11.2.0.4.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.javavm.server, 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.dbjava.jdbc, 11.2.0.4.0...

Patching component oracle.dbjava.ic, 11.2.0.4.0...

Patching component oracle.javavm.client, 11.2.0.4.0...

Patch 27923163 successfully applied.

Log file location: /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2018-09-14_11-14-10AM_1.log

OPatch succeeded.

[oracle@XAG140 27923163]$

#安装OJVM补丁集的后续工作

[oracle@XAG140 27923163]$ cd $ORACLE_HOME/sqlpatch/27923163

[oracle@XAG140 27923163]$ pwd

/u01/app/oracle/product/11.2.0/db_1/sqlpatch/27923163

[oracle@XAG140 27923163]$ sqlplus / as sysdba

SQL> startup upgrade

SQL> @postinstall.sql

SQL> shutdown immediate

SQL> startup

SQL> @/u01/app/oracle/product/11.2.0/db_1/rdbms/admin/utlrp.sql

SQL> exit

[oracle@XAG140 27923163]$ lsnrctl start

[oracle@XAG140 27923163]$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch lsinv

Oracle Interim Patch Installer version 11.2.0.3.19

Copyright (c) 2018, Oracle Corporation.  All rights reserved.

Oracle Home      : /u01/app/oracle/product/11.2.0/db_1

Central Inventory : /u01/app/oraInventory

  from          : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc

OPatch version    : 11.2.0.3.19

OUI version      : 11.2.0.4.0

Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2018-09-14_11-25-57AM_1.log

Lsinventory Output file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2018-09-14_11-25-57AM.txt

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

Local Machine Information::

Hostname: XAG140

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 this Oracle Home.

Interim patches (2) :

Patch  27923163    : applied on Fri Sep 14 11:15:56 CST 2018

Unique Patch ID:  22212880

Patch description:  "OJVM PATCH SET UPDATE 11.2.0.4.180717"

  Created on 24 May 2018, 08:57:43 hrs PST8PDT

  Bugs fixed:

    26637592, 26023002, 19007266, 21566944, 27642235, 21811517, 19058059

    19852360, 20408829, 18933818, 25076732, 22675136, 27461842, 25649873

    22670385, 19231857, 21047766, 17804361, 18458318, 17285560, 17056813

    18166577, 23265914, 23727132, 19374518, 24448240, 25494379, 19554117

    19153980, 19909862, 17201047, 17528315, 24534298, 25067795, 19187988

    19699946, 22118835, 19006757, 21911849, 27952577, 27000663, 19895326

    19176885, 22253904, 14774730, 19223010

Patch  27734982    : applied on Thu Aug 23 16:15:47 CST 2018

Unique Patch ID:  22229176

Patch description:  "Database Patch Set Update : 11.2.0.4.180717 (27734982)"

  Created on 31 May 2018, 01:37:49 hrs PST8PDT

Sub-patch  27338049; "Database Patch Set Update : 11.2.0.4.180417 (27338049)"

Sub-patch  26925576; "Database Patch Set Update : 11.2.0.4.180116 (26925576)"

Sub-patch  26392168; "Database Patch Set Update : 11.2.0.4.171017 (26392168)"

Sub-patch  26609445; "Database Patch Set Update : 11.2.0.4.170814 (26609445)"

Sub-patch  25869727; "Database Patch Set Update : 11.2.0.4.170718 (25869727)"

Sub-patch  24732075; "Database Patch Set Update : 11.2.0.4.170418 (24732075)"

Sub-patch  24006111; "Database Patch Set Update : 11.2.0.4.161018 (24006111)"

Sub-patch  23054359; "Database Patch Set Update : 11.2.0.4.160719 (23054359)"

Sub-patch  22502456; "Database Patch Set Update : 11.2.0.4.160419 (22502456)"

Sub-patch  21948347; "Database Patch Set Update : 11.2.0.4.160119 (21948347)"

Sub-patch  21352635; "Database Patch Set Update : 11.2.0.4.8 (21352635)"

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:

    21174504, 17184721, 21538558, 16091637, 18092127, 17381384, 15979965

    20671094, 16731148, 16314254, 13837378, 18441944, 17835048, 13558557

    17008068, 17201159, 25427662, 17853498, 20717359, 17246576, 18356166

    18681862, 18440047, 20569094, 20031873, 16875449, 20387265, 19788842

    17296856, 21330264, 14010183, 17648596, 17551063, 17025461, 24719736

    17267114, 22507210, 17912217, 17889583, 18202441, 17040764, 17478145

    16524926, 25655390, 19358317, 22148226, 18747196, 26544823, 18641419

    17036973, 18948177, 17811789, 16542886, 14285317, 18009564, 16618694

    8322815, 16832076, 18247991, 16692232, 22507234, 17570240, 13871092

    24624166, 24348685, 17848897, 17441661, 14034426, 17465741, 16596890

    17437634, 21343897, 20506706, 21453153, 18339044, 17951233, 22321741

    21795111, 18430495, 21787056, 22380919, 19469538, 20506715, 17811429

    19721304, 17903598, 18230522, 19554106, 19458377, 21281607, 17612828

    6599380, 22092979, 22321756, 17040527, 17811438, 18641461, 14657740

    13364795, 21387964, 19490948, 17346671, 17588480, 22351572, 18235390

    26474853, 18849970, 17889549, 19309466, 16472716, 20596234, 18331850

    18641451, 17344412, 21179898, 19461270, 17546761, 24842886, 14521849

    18203835, 18203838, 18964939, 18203837, 17313525, 22195457, 18139690

    16837842, 22296366, 14106803, 17842825, 21352646, 22657942, 16360112

    20657441, 22195441, 17389192, 26198926, 14565184, 17205719, 18440095

    14764829, 22195448, 14354737, 13944971, 16571443, 21868720, 17186905

    17080436, 18673342, 22905130, 17027426, 27374796, 19972569, 19972568

    20144308, 19972566, 17282229, 19972564, 16870214, 21629064, 19615136

    21354456, 17390431, 18762750, 23007241, 16613964, 17957017, 18098207

    18471685, 19730508, 21538485, 18264060, 17323222, 17754782, 17600719

    18317531, 17852463, 17596908, 17655634, 16228604, 27053456, 20074391

    19972570, 18090142, 18996843, 19854503, 16042673, 17835627, 20334344

    17393683, 20861693, 18000422, 17551709, 26575788, 23315889, 20506699

    19006849, 18277454, 18456514, 19174430, 17258090, 17174582, 25654936

    17242746, 16399083, 17824637, 21132297, 22465352, 17762296, 22168163

    17397545, 16450169, 12364061, 20067212, 18856999, 19211724, 19463893

    19463897, 21343775, 17853456, 18673304, 20004021, 26030218, 21668627

    16194160, 17477958, 16538760, 12982566, 24570598, 20828947, 18259031

    20296213, 18293054, 17610798, 19699191, 23065323, 17311728, 18135678

    18774543, 23294548, 16785708, 10136473, 24560906, 22551446, 19777862

    17786518, 18315328, 18334586, 12747740, 18096714, 19032867, 21641760

    17390160, 18899974, 17232014, 20598042, 18673325, 16422541, 18155762

    14015842, 19827973, 22683225, 17726838, 18554871, 23177648, 18051556

    20803583, 21972320, 15990359, 17922254, 18282562, 16855292, 16668584

    21343838, 20299015, 17446237, 18093615, 18043064, 23713236, 17694209

    17288409, 18308268, 20475845, 17274537, 13955826, 16934803, 17634921

    17501491, 16315398, 23725036, 22683212, 17006183, 13829543, 18191164

    17655240, 26746894, 22809871, 18384391, 19393542, 21538567, 16198143

    21847223, 25823754, 17892268, 20142975, 19584068, 17165204, 25165496

    18604493, 21756699, 18508861, 16901385, 18554763, 21532755, 18189036

    17443671, 17385178, 14829250, 17936109, 20925795, 20509482, 17478514

    27441326, 16850630, 13951456, 16595641, 14054676, 15861775, 21142837

    16912439, 17299889, 17297939, 23003979, 18619917, 16833527, 17798953

    17816865, 18607546, 17571306, 21286665, 17341326, 26910644, 17851160

    20558005, 17586955, 19049453, 21051840, 17587063, 16956380, 18328509

    25423453, 14133975, 18061914, 18522509, 21051833, 20294666, 18765602

    20860659, 20324049, 18199537, 17332800, 13609098, 22502493, 18384537

    14338435, 17945983, 16392068, 21067387, 17752995, 21051862, 16863422

    25505382, 17237521, 18244962, 19544839, 24433711, 24717859, 17156148

    18973907, 23026585, 17877323, 17449815, 18180390, 17088068, 17037130

    20004087, 21422580, 19466309, 11733603, 25505371, 21051858, 18084625

    18674024, 21051852, 18091059, 25369547, 16306373, 18306996, 17787259

    18193833, 19915271, 20513399, 20631274, 25879656, 16344544, 14692762

    18614015, 17346091, 18228645, 17721717, 18436307, 21756677, 19888853

    11883252, 17891943, 19475971, 22353199, 16384983, 19121551, 27825893

    12816846, 17982555, 17761775, 22243719, 17265217, 25505394, 17071721

    16721594, 18262334, 21756661, 17891946, 15913355, 17672719, 17602269

    17239687, 17042658, 17238511, 17811456, 17284817, 17752121, 20879889

    21380789, 17394950, 17011832, 16579084, 22195465, 14602788, 18325460

    24476265, 26569225, 24476274, 12611721, 16903536, 17006570, 19689979

    16043574, 18783224, 24662775, 16494615, 21526048, 17392698, 19197175

    16069901, 17811447, 27870645, 17308789, 22195477, 24835538, 17865671

    17343514, 19013183, 17325413, 18316692, 16180763, 17348614, 14368995

    21983325, 17393915, 16285691, 19211433, 20331945, 17883081, 17705023

    24316947, 17614227, 19578350, 22195485, 14084247, 13645875, 16777840

    19727057, 14852021, 18744139, 18674047, 17716305, 19285025, 18482502

    27534509, 17622427, 19289642, 22195492, 25947799, 14458214, 20869721

    21172913, 17767676, 18723434, 25505407, 17786278, 19258504, 17082983

    21351877, 17365043, 13498382, 18331812, 16065166, 25489607, 16685417

    18031668, 22893153, 16943711, 19272701, 21517440, 25897615, 17649265

    13866822, 18094246, 24528741, 17783588, 14245531, 17082359, 18280813

    20448824, 23330119, 16268425, 19487147, 25600421, 18018515, 17302277

    17215560, 24411921, 19271443, 25764020, 17016369, 20777150, 23330124

    16756406, 20441797, 19769489, 28100487, 17545847, 25093656, 18260550

    13853126, 17227277, 23536835, 25957038, 24652769, 19207117, 9756271

    18868646, 17614134, 26667023, 17546973, 18704244, 19680952, 26667015

    17050888, 18828868, 18273830, 17360606, 16992075, 24563422, 17375354

    12905058, 18362222, 21429602, 27086138, 17571039, 17468141, 18436647

    17235750, 21168487, 16220077, 16929165

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

OPatch succeeded.

[oracle@XAG140 27923163]$

SQL> select * from dba_registry_history;

ACTION_TIME                   ACTION NAMESPACE VERSION ID BUNDLE_SERIES COMMENTS

1 22-AUG-18 04.37.01.355121 PM VIEW RECOMPILE 8289601 view recompilation

2 22-AUG-18 04.37.01.464407 PM UPGRADE SERVER 10.2.0.5.0 Upgraded from 10.2.0.1.0

3 24-AUG-18 06.20.16.789759 PM VIEW INVALIDATE 8289601 view invalidation

4 24-AUG-18 06.20.48.426719 PM UPGRADE SERVER 11.2.0.4.0 Upgraded from 10.2.0.5.0

5 24-AUG-18 06.28.34.974329 PM APPLY SERVER 11.2.0.4 180717 PSU PSU 11.2.0.4.180717

6 14-SEP-18 11.21.30.172469 AM jvmpsu.sql SERVER 11.2.0.4.180717OJVMPSU 0 RAN jvmpsu.sql

7 14-SEP-18 11.21.30.632304 AM APPLY SERVER 11.2.0.4.180717OJVMPSU 0 OJVM PSU post-install

8 14-SEP-18 11.21.30.636062 AM APPLY 27923163 Patch 27923163 applied

最后编辑于 ：
©著作权归作者所有,转载或内容合作请联系作者
  • 人面猴
    序言：七十年代末，一起剥皮案震惊了整个滨河市，随后出现的几起案子，更是在滨河造成了极大的恐慌，老刑警刘岩，带你破解...
    沈念sama阅读 211,948评论 6赞 492
  • 死咒
    序言：滨河连续发生了三起死亡事件，死亡现场离奇诡异，居然都是意外死亡，警方通过查阅死者的电脑和手机，发现死者居然都...
    沈念sama阅读 90,371评论 3赞 385
  • 救了他两次的神仙让他今天三更去死
    文/潘晓璐 我一进店门，熙熙楼的掌柜王于贵愁眉苦脸地迎上来，“玉大人，你说我怎么就摊上这事。” “怎么了？”我有些...
    开封第一讲书人阅读 157,490评论 0赞 348
  • 道士缉凶录：失踪的卖姜人
    文/不坏的土叔 我叫张陵，是天一观的道长。 经常有香客问我，道长，这世上最难降的妖魔是什么？ 我笑而不...
    开封第一讲书人阅读 56,521评论 1赞 284
  • 港岛之恋（遗憾婚礼）
    正文 为了忘掉前任，我火速办了婚礼，结果婚礼上，老公的妹妹穿的比我还像新娘。我一直安慰自己，他们只是感情好，可当我...
    茶点故事阅读 65,627评论 6赞 386
  • 恶毒庶女顶嫁案：这布局不是一般人想出来的
    文/花漫 我一把揭开白布。 她就那样静静地躺着，像睡着了一般。 火红的嫁衣衬着肌肤如雪。 梳的纹丝不乱的头发上，一...
    开封第一讲书人阅读 49,842评论 1赞 290
  • 城市分裂传说
    那天，我揣着相机与录音，去河边找鬼。 笑死，一个胖子当着我的面吹牛，可吹牛的内容都是我干的。 我是一名探鬼主播，决...
    沈念sama阅读 38,997评论 3赞 408
  • 双鸳鸯连环套：你想象不到人心有多黑
    文/苍兰香墨 我猛地睁开眼，长吁一口气：“原来是场噩梦啊……” “哼！你这毒妇竟也来了？” 一声冷哼从身侧响起，我...
    开封第一讲书人阅读 37,741评论 0赞 268
  • 万荣杀人案实录
    序言：老挝万荣一对情侣失踪，失踪者是张志新（化名）和其女友刘颖，没想到半个月后，有当地人在树林里发现了一具尸体，经...
    沈念sama阅读 44,203评论 1赞 303
  • 护林员之死
    正文 独居荒郊野岭守林人离奇死亡，尸身上长有42处带血的脓包…… 初始之章·张勋 以下内容为张勋视角 年9月15日...
    茶点故事阅读 36,534评论 2赞 327
  • 白月光启示录
    正文 我和宋清朗相恋三年，在试婚纱的时候发现自己被绿了。 大学时的朋友给我发了我未婚夫和他白月光在一起吃饭的照片。...
    茶点故事阅读 38,673评论 1赞 341
  • 活死人
    序言：一个原本活蹦乱跳的男人离奇死亡，死状恐怖，灵堂内的尸体忽然破棺而出，到底是诈尸还是另有隐情，我是刑警宁泽，带...
    沈念sama阅读 34,339评论 4赞 330
  • 日本核电站爆炸内幕
    正文 年R本政府宣布，位于F岛的核电站，受9级特大地震影响，放射性物质发生泄漏。R本人自食恶果不足惜，却给世界环境...
    茶点故事阅读 39,955评论 3赞 313
  • 男人毒药：我在死后第九天来索命
    文/蒙蒙 一、第九天 我趴在偏房一处隐蔽的房顶上张望。 院中可真热闹，春花似锦、人声如沸。这庄子的主人今日做“春日...
    开封第一讲书人阅读 30,770评论 0赞 21
  • 一桩弑父案，背后竟有这般阴谋
    文/苍兰香墨 我抬头看了看天上的太阳。三九已至，却和暖如春，着一层夹袄步出监牢的瞬间，已是汗流浃背。 一阵脚步声响...
    开封第一讲书人阅读 32,000评论 1赞 266
  • 情欲美人皮
    我被黑心中介骗来泰国打工， 没想到刚下飞机就差点儿被人妖公主榨干…… 1. 我叫王不留，地道东北人。 一个月前我还...
    沈念sama阅读 46,394评论 2赞 360
  • 代替公主和亲
    正文 我出身青楼，却偏偏与公主长得像，于是被迫代替她去往敌国和亲。 传闻我的和亲对象是个残疾皇子，可洞房花烛夜当晚...
    茶点故事阅读 43,562评论 2赞 349

推荐阅读更多精彩内容