12c单实例数据库打最新12.1.0.2.160119 PSU补丁记录

12c单实例数据库打最新12.1.0.2.160119 PSU补丁记录
 
[oracle@oel11 ~]$ opatch lsinv
Oracle Interim Patch Installer version 12.1.0.1.9
Copyright (c) 2016, Oracle Corporation.  All rights reserved.




Oracle Home       : /s01/oracle12c/app/oracle/product/12.1.0.2/dbhome_1
Central Inventory : /s01/oracle/app/oraInventory
   from           : /s01/oracle12c/app/oracle/product/12.1.0.2/dbhome_1/oraInst.loc
OPatch version    : 12.1.0.1.9
OUI version       : 12.1.0.2.0
Log file location : /s01/oracle12c/app/oracle/product/12.1.0.2/dbhome_1/cfgtoollogs/opatch/opatch2016-02-01_15-59-00PM_1.log


Lsinventory Output file location : /s01/oracle12c/app/oracle/product/12.1.0.2/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2016-02-01_15-59-00PM.txt


--------------------------------------------------------------------------------
Local Machine Information::
Hostname: oel11
ARU platform id: 226
ARU platform description:: Linux x86-64


Installed Top-level Products (1): 


Oracle Database 12c                                                  12.1.0.2.0
There are 1 products installed in this Oracle Home.




Interim patches (1) :


Patch  21359755     : applied on Fri Oct 30 10:53:48 CST 2015
Unique Patch ID:  19194568
Patch description:  "Database Patch Set Update : 12.1.0.2.5 (21359755)"
   Created on 21 Oct 2015, 02:52:58 hrs PST8PDT
Sub-patch  20831110; "Database Patch Set Update : 12.1.0.2.4 (20831110)"
Sub-patch  20299023; "Database Patch Set Update : 12.1.0.2.3 (20299023)"
Sub-patch  19769480; "Database Patch Set Update : 12.1.0.2.2 (19769480)"
   Bugs fixed:
     19189525, 19075256, 19865345, 19791273, 19280225, 18845653, 19248799
     19243521, 18988834, 19238590, 21281532, 18921743, 20245930, 19134173
     19571367, 20476175, 20925795, 19018206, 20387265, 19149990, 18849537
     19183343, 19703301, 19001390, 18202441, 19189317, 19644859, 19390567
     19358317, 19279273, 19706965, 19068970, 19619732, 18607546, 20348653
     18940497, 19670108, 19649152, 18948177, 19315691, 19676905, 18964978
     20165574, 19035573, 19176326, 20413820, 20558005, 19176223, 19532017
     20134339, 19074147, 18411216, 20361671, 20425790, 18966843, 20294666
     19371175, 19307662, 19195895, 19154375, 19468991, 19174521, 19520602
     19382851, 19658708, 20093776, 17835294, 19068610, 19791377, 20746251
     20048359, 19143550, 19185876, 19627012, 20281121, 19577410, 19001359
     19518079, 18610915, 18674024, 18306996, 19309466, 19081128, 19915271
     20122715, 20284155, 18791688, 21442094, 19303936, 19597439, 20235511
     18964939, 19430401, 19044962, 19409212, 20657441, 19684504, 19024808
     19028800, 19065556, 19723336, 19077215, 21421886, 19524384, 19048007
     18288842, 18952989, 16870214, 19928926, 19180770, 19197175, 19730508
     19012119, 19067244, 20074391, 19841800, 19512341, 14643995, 20331945
     19587324, 19065677, 19547370, 19637186, 21225209, 20397490, 18967382
     19174430, 18674047, 19054077, 19708632, 19536415, 19289642, 19335438
     17365043, 18856999, 20471920, 19468347, 21620471, 16359751, 18990693
     19439759, 19769480, 19272708, 19978542, 19329654, 20402832, 19873610
     19304354, 19052488, 19291380, 18681056, 19896336, 19076343, 19561643
     18618122, 20440930, 18456643, 19699191, 18909599, 19487147, 18250893
     19016730, 18743542, 20347562, 16619249, 18354830, 19687159, 19174942
     20424899, 19989009, 20688221, 20441797, 19157754, 19058490, 19032777
     19399918, 18885870, 19434529, 19018447, 18417036, 20919320, 19284031
     19022470, 20474192, 22062026, 19385656, 19501299, 17274537, 20899461
     19440586, 19606174, 18436647, 19023822, 19178851, 19124589, 19805359
     19597583, 19155797, 19393542, 19050649






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


OPatch succeeded.




[oracle@oel11 s01]$ cd soft
[oracle@oel11 soft]$ ls -l
total 0
[oracle@oel11 soft]$ ls -ltr
total 143732
-rw-r--r-- 1 oracle oinstall 147028181 Feb  1 16:00 12.1.0.2.160119DB_p21948354_121020_Linux-x86-64.zip
[oracle@oel11 soft]$ unzip 12.1.0.2.160119DB_p21948354_121020_Linux-x86-64.zip 


[oracle@oel11 soft]$ cd 21948354
[oracle@oel11 21948354]$ ls -ltr
total 92
drwxr-xr-x 4 oracle oinstall  4096 Dec 21 15:39 19769480
drwxr-xr-x 4 oracle oinstall  4096 Dec 21 15:40 20831110
drwxr-xr-x 4 oracle oinstall  4096 Dec 21 15:40 21948354
drwxr-xr-x 4 oracle oinstall  4096 Dec 21 15:40 21359755
drwxr-xr-x 4 oracle oinstall  4096 Dec 21 15:40 20299023
-rw-rw-r-- 1 oracle oinstall    21 Dec 21 15:40 README.txt
-rw-rw-r-- 1 oracle oinstall 64755 Jan 18 23:50 README.html


检查依赖性
[oracle@oel11 21948354]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.1.0.1.9
Copyright (c) 2016, Oracle Corporation.  All rights reserved.


PREREQ session


Oracle Home       : /s01/oracle12c/app/oracle/product/12.1.0.2/dbhome_1
Central Inventory : /s01/oracle/app/oraInventory
   from           : /s01/oracle12c/app/oracle/product/12.1.0.2/dbhome_1/oraInst.loc
OPatch version    : 12.1.0.1.9
OUI version       : 12.1.0.2.0
Log file location : /s01/oracle12c/app/oracle/product/12.1.0.2/dbhome_1/cfgtoollogs/opatch/opatch2016-02-01_16-02-09PM_1.log


Invoking prereq "checkconflictagainstohwithdetail"


Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

升级补丁

[oracle@oel11 21948354]$ opatch apply
Oracle Interim Patch Installer version 12.1.0.1.9
Copyright (c) 2016, Oracle Corporation.  All rights reserved.




Oracle Home       : /s01/oracle12c/app/oracle/product/12.1.0.2/dbhome_1
Central Inventory : /s01/oracle/app/oraInventory
   from           : /s01/oracle12c/app/oracle/product/12.1.0.2/dbhome_1/oraInst.loc
OPatch version    : 12.1.0.1.9
OUI version       : 12.1.0.2.0
Log file location : /s01/oracle12c/app/oracle/product/12.1.0.2/dbhome_1/cfgtoollogs/opatch/opatch2016-02-01_16-02-20PM_1.log


Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   21948354  


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 = '/s01/oracle12c/app/oracle/product/12.1.0.2/dbhome_1')




Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying sub-patch '21948354' to OH '/s01/oracle12c/app/oracle/product/12.1.0.2/dbhome_1'


Patching component oracle.rdbms.deconfig, 12.1.0.2.0...


Patching component oracle.xdk, 12.1.0.2.0...


Patching component oracle.tfa, 12.1.0.2.0...


Patching component oracle.rdbms, 12.1.0.2.0...


Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...


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


Patching component oracle.rdbms.rsf, 12.1.0.2.0...


Patching component oracle.xdk.rsf, 12.1.0.2.0...
Composite patch 21948354 successfully applied.
Log file location: /s01/oracle12c/app/oracle/product/12.1.0.2/dbhome_1/cfgtoollogs/opatch/opatch2016-02-01_16-02-20PM_1.log


OPatch succeeded.


检查补丁打完后的版本
[oracle@oel11 21948354]$ opatch lsinv
Oracle Interim Patch Installer version 12.1.0.1.9
Copyright (c) 2016, Oracle Corporation.  All rights reserved.




Oracle Home       : /s01/oracle12c/app/oracle/product/12.1.0.2/dbhome_1
Central Inventory : /s01/oracle/app/oraInventory
   from           : /s01/oracle12c/app/oracle/product/12.1.0.2/dbhome_1/oraInst.loc
OPatch version    : 12.1.0.1.9
OUI version       : 12.1.0.2.0
Log file location : /s01/oracle12c/app/oracle/product/12.1.0.2/dbhome_1/cfgtoollogs/opatch/opatch2016-02-01_16-16-55PM_1.log


Lsinventory Output file location : /s01/oracle12c/app/oracle/product/12.1.0.2/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2016-02-01_16-16-55PM.txt


--------------------------------------------------------------------------------
Local Machine Information::
Hostname: oel11
ARU platform id: 226
ARU platform description:: Linux x86-64


Installed Top-level Products (1): 


Oracle Database 12c                                                  12.1.0.2.0
There are 1 products installed in this Oracle Home.




Interim patches (1) :


Patch  21948354     : applied on Mon Feb 01 16:07:07 CST 2016
Unique Patch ID:  19553095
Patch description:  "Database Patch Set Update : 12.1.0.2.160119 (21948354)"
   Created on 20 Dec 2015, 23:39:33 hrs PST8PDT
Sub-patch  21359755; "Database Patch Set Update : 12.1.0.2.5 (21359755)"
Sub-patch  20831110; "Database Patch Set Update : 12.1.0.2.4 (20831110)"
Sub-patch  20299023; "Database Patch Set Update : 12.1.0.2.3 (20299023)"
Sub-patch  19769480; "Database Patch Set Update : 12.1.0.2.2 (19769480)"
   Bugs fixed:
     19189525, 19075256, 19141838, 19865345, 19791273, 19280225, 18845653
     20951038, 19243521, 19248799, 21756699, 18988834, 19238590, 21281532
     20245930, 18921743, 18799063, 19134173, 19571367, 20476175, 20925795
     19018206, 20509482, 20387265, 20588502, 19149990, 18849537, 18886413
     17551063, 19183343, 19703301, 19001390, 18202441, 19189317, 19644859
     19358317, 19390567, 19279273, 19706965, 19068970, 19619732, 20348653
     18607546, 18940497, 19670108, 19649152, 18948177, 19315691, 19676905
     18964978, 19035573, 20165574, 19176326, 20413820, 20558005, 19176223
     19532017, 20134339, 19074147, 18411216, 20361671, 20425790, 18966843
     20294666, 19307662, 19371175, 19195895, 19154375, 19468991, 19174521
     19520602, 19382851, 21875360, 19326908, 19658708, 20093776, 20618595
     21787056, 17835294, 19791377, 19068610, 20048359, 20746251, 19143550
     19185876, 19627012, 20281121, 19577410, 22092979, 19001359, 19518079
     18610915, 19490948, 18674024, 18306996, 19309466, 19081128, 19915271
     20122715, 21188532, 20284155, 18791688, 20890311, 21442094, 18973548
     19303936, 19597439, 20235511, 18964939, 19430401, 19044962, 19409212
     19879746, 20657441, 19684504, 19024808, 18799993, 20877664, 19028800
     19065556, 19723336, 19077215, 19604659, 21421886, 19524384, 19048007
     18288842, 19689979, 20446883, 18952989, 16870214, 19928926, 21526048
     19180770, 19197175, 19902195, 20318889, 19730508, 19012119, 19067244
     20074391, 19512341, 19841800, 14643995, 20331945, 19587324, 19547370
     19065677, 19637186, 21225209, 20397490, 18967382, 19174430, 18674047
     19054077, 19536415, 19708632, 19289642, 20869721, 19335438, 17365043
     18856999, 19869255, 20471920, 19468347, 21620471, 16359751, 18990693
     17890099, 19439759, 19769480, 19272708, 19978542, 20101006, 21300341
     20402832, 19329654, 19873610, 21668627, 21517440, 19304354, 19052488
     20794034, 19291380, 18681056, 19896336, 19076343, 19561643, 18618122
     20440930, 18456643, 19699191, 18909599, 19487147, 18250893, 19016730
     18743542, 20347562, 16619249, 18354830, 19687159, 19174942, 20424899
     19989009, 20688221, 20441797, 19157754, 19032777, 19058490, 19399918
     18885870, 19434529, 19018447, 18417036, 20919320, 19022470, 19284031
     20474192, 20173897, 22062026, 19385656, 19501299, 17274537, 20899461
     19440586, 16887946, 19606174, 18436647, 17655240, 19023822, 19178851
     19124589, 19805359, 19597583, 19155797, 19393542, 19050649






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


OPatch succeeded.


升级数据字典
[oracle@oel11 21948354]$ sqlplus / as sysdba


SQL*Plus: Release 12.1.0.2.0 Production on Mon Feb 1 16:17:26 2016


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


Connected to an idle instance.


SQL> startup
ORACLE instance started.


Total System Global Area  838860800 bytes
Fixed Size                  2929936 bytes
Variable Size             562039536 bytes
Database Buffers          268435456 bytes
Redo Buffers                5455872 bytes
Database mounted.
Database opened.
SQL> show pdbs


    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB12C                         READ WRITE NO
SQL> alter pluggable database all open;


Pluggable database altered.


SQL> show pdbs


    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB12C                         READ WRITE NO
SQL> quit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
[oracle@oel11 21948354]$ cd $ORACLE_HOME/OPatch
[oracle@oel11 OPatch]$ ./datapatch -verbose
SQL Patching tool version 12.1.0.2.0 on Mon Feb  1 16:19:19 2016
Copyright (c) 2015, Oracle.  All rights reserved.


Log file for this invocation: /s01/oracle12c/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_4633_2016_02_01_16_19_19/sqlpatch_invocation.log


Connecting to database...OK
Note:  Datapatch will only apply or rollback SQL fixes for PDBs
       that are in an open state, no patches will be applied to closed PDBs.
       Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation
       (Doc ID 1585822.1)
Bootstrapping registry and package to current versions...done
Determining current state...done


Current state of SQL patches:
Bundle series PSU:
  ID 160119 in the binary registry and ID 5 in PDB CDB$ROOT, ID 5 in PDB PDB$SEED, ID 5 in PDB PDB12C


Adding patches to installation queue and performing prereq checks...
Installation queue:
  For the following PDBs: CDB$ROOT PDB$SEED PDB12C
    Nothing to roll back
    The following patches will be applied:
      21948354 (Database Patch Set Update : 12.1.0.2.160119 (21948354))


Installing patches...
Patch installation complete.  Total patches installed: 3


Validating logfiles...
Patch 21948354 apply (pdb CDB$ROOT): SUCCESS
  logfile: /s01/oracle12c/app/oracle/cfgtoollogs/sqlpatch/21948354/19553095/21948354_apply_PROD12_CDBROOT_2016Feb01_16_20_43.log (no errors)
Patch 21948354 apply (pdb PDB$SEED): SUCCESS
  logfile: /s01/oracle12c/app/oracle/cfgtoollogs/sqlpatch/21948354/19553095/21948354_apply_PROD12_PDBSEED_2016Feb01_16_20_57.log (no errors)
Patch 21948354 apply (pdb PDB12C): SUCCESS
  logfile: /s01/oracle12c/app/oracle/cfgtoollogs/sqlpatch/21948354/19553095/21948354_apply_PROD12_PDB12C_2016Feb01_16_20_57.log (no errors)
SQL Patching tool complete on Mon Feb  1 16:21:08 2016
[oracle@oel11 OPatch]$ 


哎,机子严重老化,12C RAC是跑不起来了