oracle12c单实例数据库打12.1.0.2.4补丁记录

oracle12c单实例数据库打12.1.0.2.4补丁记录

操作系统版本：
[oracle@oel11 OPatch]$ lsb_release -a
LSB Version: :core-4.0-amd64:core-4.0-ia32:core-4.0-noarch:graphics-4.0-amd64:graphics-4.0-ia32:graphics-4.0-noarch:printing-4.0-amd64:printing-4.0-ia32:printing-4.0-noarch
Distributor ID: EnterpriseEnterpriseServer
Description: Enterprise Linux Enterprise Linux Server release 5.8 (Carthage)
Release: 5.8
Codename: Carthage


[oracle@oel11 patch]$ ls -ltr
total 73716
drwxr-xr-x 5 oracle oinstall 4096 Jul 11 15:45 20831110
-rw-rw-r-- 1 oracle oinstall 30892 Jul 14 17:06 PatchSearch.xml
-rw-r--r-- 1 oracle oinstall 75370440 Jul 21 09:48 12.1.0.2.4DB_PSU_p20831110_121020_Linux-x86-64.zip
[oracle@oel11 patch]$ cd 20831110
[oracle@oel11 20831110]$ opatch lsinv
Oracle Interim Patch Installer version 12.1.0.1.6
Copyright (c) 2015, 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.6
OUI version : 12.1.0.2.0
Log file location : /s01/oracle12c/app/oracle/product/12.1.0.2/dbhome_1/cfgtoollogs/opatch/opatch2015-07-21_09-50-01AM_1.log


Lsinventory Output file location : /s01/oracle12c/app/oracle/product/12.1.0.2/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2015-07-21_09-50-01AM.txt


--------------------------------------------------------------------------------
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 20299023 : applied on Sun Apr 19 14:36:25 CST 2015
Unique Patch ID: 18703022
Patch description: "Database Patch Set Update : 12.1.0.2.3 (20299023)"
Created on 16 Mar 2015, 22:21:54 hrs PST8PDT
Sub-patch 19769480; "Database Patch Set Update : 12.1.0.2.2 (19769480)"
Bugs fixed:
19189525, 19065556, 19075256, 19723336, 19077215, 19865345, 18845653
19280225, 19524384, 19248799, 18988834, 19048007, 18288842, 19238590
18921743, 18952989, 16870214, 19928926, 19134173, 19180770, 19018206
19197175, 19149990, 18849537, 19730508, 19183343, 19012119, 19001390
18202441, 19067244, 19189317, 19644859, 19358317, 19390567, 20074391
19279273, 19706965, 19068970, 19841800, 19512341, 14643995, 19619732
20348653, 18607546, 18940497, 19670108, 19649152, 19065677, 19547370
18948177, 19315691, 19637186, 19676905, 18964978, 19035573, 19176326
18967382, 19174430, 19176223, 19532017, 18674047, 19074147, 19054077
19536415, 19708632, 19289642, 20425790, 19335438, 18856999, 19371175
19468347, 19195895, 19154375, 16359751, 18990693, 19439759, 19769480
19272708, 19978542, 19329654, 19873610, 19174521, 19520602, 19382851
19658708, 19304354, 19052488, 19291380, 18681056, 19896336, 17835294
19076343, 19791377, 19068610, 19561643, 18618122, 20440930, 18456643
18909599, 19487147, 19143550, 19185876, 19016730, 18250893, 20347562
19627012, 16619249, 18354830, 19577410, 19687159, 19001359, 19174942
19518079, 18610915, 18674024, 18306996, 19309466, 19081128, 19915271
19157754, 19058490, 20284155, 18791688, 18885870, 19303936, 19434529
19018447, 18417036, 19597439, 20235511, 19022470, 18964939, 19430401
19044962, 19385656, 19501299, 17274537, 19409212, 19440586, 19606174
18436647, 19023822, 19684504, 19178851, 19124589, 19805359, 19024808
19597583, 19155797, 19393542, 19050649, 19028800






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


OPatch succeeded.
[oracle@oel11 20831110]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.1.0.1.6
Copyright (c) 2015, 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.6
OUI version : 12.1.0.2.0
Log file location : /s01/oracle12c/app/oracle/product/12.1.0.2/dbhome_1/cfgtoollogs/opatch/opatch2015-07-21_09-50-10AM_1.log


Invoking prereq "checkconflictagainstohwithdetail"


Prereq "checkConflictAgainstOHWithDetail" passed.


OPatch succeeded.
[oracle@oel11 20831110]$ sqlplus / as sysdba


SQL*Plus: Release 12.1.0.2.0 Production on Tue Jul 21 09:50:32 2015


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




Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options


SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
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 20831110]$ ps -fu oracle
UID PID PPID C STIME TTY TIME CMD
oracle 2829 2828 0 09:45 pts/0 00:00:00 -bash
oracle 3068 3067 0 09:46 pts/1 00:00:00 -bash
oracle 3375 3373 0 09:48 ? 00:00:00 /usr/sbin/vsftpd /etc/vsftpd/vsftpd.conf
oracle 3621 2829 0 09:51 pts/0 00:00:00 ps -fu oracle
[oracle@oel11 20831110]$ opatch apply
Oracle Interim Patch Installer version 12.1.0.1.6
Copyright (c) 2015, 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.6
OUI version : 12.1.0.2.0
Log file location : /s01/oracle12c/app/oracle/product/12.1.0.2/dbhome_1/cfgtoollogs/opatch/opatch2015-07-21_09-51-17AM_1.log


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


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 '20831110' to OH '/s01/oracle12c/app/oracle/product/12.1.0.2/dbhome_1'


Patching component oracle.rdbms, 12.1.0.2.0...


Patching component oracle.oraolap.dbscripts, 12.1.0.2.0...


Patching component oracle.ldap.rsf, 12.1.0.2.0...


Patching component oracle.tfa, 12.1.0.2.0...


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


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


Verifying the update...
Composite patch 20831110 successfully applied.
Log file location: /s01/oracle12c/app/oracle/product/12.1.0.2/dbhome_1/cfgtoollogs/opatch/opatch2015-07-21_09-51-17AM_1.log


OPatch succeeded.
[oracle@oel11 20831110]$ opatch lsinv
Oracle Interim Patch Installer version 12.1.0.1.6
Copyright (c) 2015, 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.6
OUI version : 12.1.0.2.0
Log file location : /s01/oracle12c/app/oracle/product/12.1.0.2/dbhome_1/cfgtoollogs/opatch/opatch2015-07-21_10-00-04AM_1.log


Lsinventory Output file location : /s01/oracle12c/app/oracle/product/12.1.0.2/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2015-07-21_10-00-04AM.txt


--------------------------------------------------------------------------------
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 20831110 : applied on Tue Jul 21 09:54:03 CST 2015
Unique Patch ID: 18977826
Patch description: "Database Patch Set Update : 12.1.0.2.4 (20831110)"
Created on 11 Jul 2015, 00:45:40 hrs PST8PDT
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, 19065556, 19075256, 19723336, 19077215, 19865345, 19280225
18845653, 19524384, 19248799, 18288842, 19048007, 18988834, 19238590
18921743, 18952989, 16870214, 19134173, 19928926, 19197175, 19018206
19180770, 20387265, 19149990, 18849537, 19183343, 19730508, 19703301
19012119, 19001390, 18202441, 19189317, 19067244, 19644859, 20074391
19358317, 19390567, 19279273, 19706965, 19068970, 14643995, 19512341
19841800, 20331945, 19619732, 18607546, 20348653, 18940497, 19670108
19649152, 19547370, 19065677, 18948177, 21225209, 19637186, 19315691
19676905, 18964978, 20165574, 19035573, 18967382, 19176326, 20558005
19174430, 19176223, 19532017, 19054077, 19074147, 18674047, 19536415
19708632, 19289642, 20425790, 19335438, 20294666, 18856999, 19307662
19195895, 19468347, 19371175, 19154375, 16359751, 18990693, 19769480
19439759, 19272708, 19978542, 20402832, 19329654, 19382851, 19520602
19873610, 19174521, 19658708, 20093776, 19304354, 19052488, 19291380
18681056, 17835294, 19896336, 19076343, 19791377, 19068610, 19561643
18618122, 20746251, 20440930, 18456643, 19699191, 18909599, 19487147
19143550, 18250893, 19016730, 19185876, 20347562, 19627012, 16619249
18354830, 19577410, 19687159, 19001359, 19174942, 20424899, 19989009
19518079, 18610915, 18674024, 18306996, 19309466, 19081128, 19915271
19157754, 19058490, 19399918, 18791688, 20284155, 18885870, 19434529
19303936, 19018447, 18417036, 19597439, 20235511, 20919320, 19284031
19022470, 20474192, 18964939, 19430401, 19044962, 19385656, 19501299
17274537, 20899461, 19409212, 19440586, 20657441, 19606174, 18436647
19023822, 19124589, 19684504, 19178851, 19024808, 19805359, 19597583
19155797, 19050649, 19393542, 19028800






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

OPatch succeeded.

对Single/Multitenant (CDB/PDB) DB数据库执行下面的操作：

[oracle@oel11 20831110]$ sqlplus /nolog


SQL*Plus: Release 12.1.0.2.0 Production on Tue Jul 21 10:00:26 2015


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


SQL> Connect / as sysdba
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> 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 20831110]$ cd $ORACLE_HOME/OPatch
[oracle@oel11 OPatch]$ ./datapatch -verbose
SQL Patching tool version 12.1.0.2.0 on Tue Jul 21 10:03:19 2015
Copyright (c) 2015, Oracle. All rights reserved.


Log file for this invocation: /s01/oracle12c/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_4768_2015_07_21_10_03_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 4 in the binary registry and ID 3 in PDB CDB$ROOT, ID 3 in PDB PDB$SEED, ID 3 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:
20831110 (Database Patch Set Update : 12.1.0.2.4 (20831110))


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


Validating logfiles...
Patch 20831110 apply (pdb CDB$ROOT): SUCCESS
logfile: /s01/oracle12c/app/oracle/cfgtoollogs/sqlpatch/20831110/18977826/20831110_apply_PROD12_CDBROOT_2015Jul21_10_04_30.log (no errors)
Patch 20831110 apply (pdb PDB$SEED): SUCCESS
logfile: /s01/oracle12c/app/oracle/cfgtoollogs/sqlpatch/20831110/18977826/20831110_apply_PROD12_PDBSEED_2015Jul21_10_04_34.log (no errors)
Patch 20831110 apply (pdb PDB12C): SUCCESS
logfile: /s01/oracle12c/app/oracle/cfgtoollogs/sqlpatch/20831110/18977826/20831110_apply_PROD12_PDB12C_2015Jul21_10_04_34.log (no errors)
SQL Patching tool complete on Tue Jul 21 10:04:44 2015
[oracle@oel11 OPatch]$ sqlplus / as sysdba


SQL*Plus: Release 12.1.0.2.0 Production on Tue Jul 21 10:04:57 2015


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




Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options


SQL> desc dba_registry_sqlpatch;
Name Null? Type
----------------------------------------- -------- ----------------------------
PATCH_ID NOT NULL NUMBER
PATCH_UID NOT NULL NUMBER
VERSION NOT NULL VARCHAR2(20)
FLAGS VARCHAR2(10)
ACTION NOT NULL VARCHAR2(15)
STATUS VARCHAR2(15)
ACTION_TIME NOT NULL TIMESTAMP(6)
DESCRIPTION VARCHAR2(100)
BUNDLE_SERIES VARCHAR2(30)
BUNDLE_ID NUMBER
BUNDLE_DATA CLOB
LOGFILE VARCHAR2(500)


SQL> select patch_id,action,status from dba_registry_sqlpatch;


PATCH_ID ACTION STATUS
---------- --------------- ---------------
19769480 APPLY SUCCESS
20299023 APPLY SUCCESS
20831110 APPLY SUCCESS


SQL>