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.
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是跑不起来了
[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 applyOracle 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是跑不起来了