oracle 12c单实例数据库打12.1.0.2.4补丁记录
来源:互联网 发布:java项目http转https 编辑:程序博客网 时间:2024/05/11 21:39
操作系统版本:
[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
--------------------------------------------------------------------------------
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>
[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数据库执行下面的操作:
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>
0 0
- oracle 12c单实例数据库打12.1.0.2.4补丁记录
- 12c单实例数据库打最新12.1.0.2.5 PSU补丁记录
- 12c单实例数据库打最新12.1.0.2.160119 PSU补丁记录
- 11g单实例数据库打最新11.2.0.4.8 PSU补丁记录
- 11g单实例数据库打最新11.2.0.4.160119 PSU补丁记录
- oracle 12C数据库PSU补丁安装
- redhat打oracle补丁
- 静默安装oracle 12c单实例
- oracle 12c RMAN异机恢复还原RAC集群(ASM)为单实例库(文件系统)记录
- oracle 11g 单实例打11.2.0.3.4 P14275605 PSU
- 手工删除Oracle 12C数据库实例
- Oracle数据库补丁下载
- Oracle 数据库 补丁升级
- Oracle 12c 基于ASM 的单实例 搭建手册
- oracle 12C数据库PSU补丁安装方式的变化---新增datapatch
- 查看Oracle已打过的补丁
- 终于把oracle补丁打完了。
- oracle 单实例数据库规划参考
- 应用程序的版本更新
- 【转】iOS中几种数据持久化方案:我要永远地记住你!
- (转)C++文件的批处理——批量文件增删改查
- 降低方法
- c++运算符重载之数据间的类型转换
- oracle 12c单实例数据库打12.1.0.2.4补丁记录
- novaclient源码分析
- 提升方法
- AM335X Nand Flash 启动调试
- oracle中merge into的用法
- 移动方法
- hadoop-2.2.0安装方法详解
- C++ string copy的追根挖底!看看你理解的层度是那层
- PL/SQL相关的数据字典