oracle 12c单实例数据库打12.1.0.2.4补丁记录
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了oracle 12c单实例数据库打12.1.0.2.4补丁记录，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含13479字，纯文字阅读大概需要20分钟。
内容图文
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>
版权声明：本文为博主原创文章，未经博主允许不得转载。
oracle 12c单实例数据库打12.1.0.2.4补丁记录
标签：oracle 12c 12.1.0.2.4 patch
本文系统来源：http://blog.csdn.net/lemontree1123/article/details/46981661
内容总结
以上是互联网集市为您收集整理的oracle 12c单实例数据库打12.1.0.2.4补丁记录全部内容，希望文章能够帮你解决oracle 12c单实例数据库打12.1.0.2.4补丁记录所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。
来源：【匿名】