PSU补丁号：12.1.0.2.5（）
在安装12.1.0.2.5PSU补丁之前，需更新Opatch程序，如果不更新opatch程序，应用psu的时候会报错。
-
补丁程序详细资料
-
-
提供反馈...
-
-
将补丁程序添加到收藏夹 一般 补丁程序
-
-
补丁程序6880880: OPatch patch of version 12.1.0.1.9 for Oracle software releases 12.1.0.x (OCT 2015)
-
-
上次更新时间 2015-10-13 上午2:42 (27 天前)
-
-
产品 Oracle Universal Installer
-
发行版 Oracle 12.1.0.1.0
-
平台 Linux x86-64
-
-
-
大小 50.3 MB
更新opatch程序
解压opatch程序到临时文件目录中
用新解压好的opatch程序替换原来目录下的opatch
-
[oracle@test soft]$ cd /u01/app/oracle/product/12.1.0/db_1/
-
[oracle@test db_1]$ mv OPatch/ OPatchbak
-
-
[oracle@test db_1]$ mv /soft/OPatch/ .
验证opatch版本
-
[oracle@test db_1]$ opatch version
-
OPatch Version: 12.1.0.1.9
解压psu补丁
关闭实例和停止监听
-
SQL> shutdown immediate;
-
Database closed.
-
Database dismounted.
-
ORACLE instance shut down.
-
SQL> exit
-
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@test ~]$ lsnrctl stop
-
-
LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 09-NOV-2015 03:08:20
-
-
Copyright (c) 1991, 2014, Oracle. All rights reserved.
-
-
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.2.240)(PORT=1521))
-
The command completed successfully
应用Psu补丁
-
[oracle@test soft]$ cd 21359755/
-
[oracle@test 21359755]$ opatch apply
-
Oracle Interim Patch Installer version 12.1.0.1.9
-
Copyright (c) 2015, Oracle Corporation. All rights reserved.
-
-
-
Oracle Home : /u01/app/oracle/product/12.1.0/db_1
-
Central Inventory : /u01/app/oraInventory
-
from : /u01/app/oracle/product/12.1.0/db_1/oraInst.loc
-
OPatch version : 12.1.0.1.9
-
OUI version : 12.1.0.2.0
-
Log file location : /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/opatch2015-11-09_03-08-25AM_1.log
-
-
Verifying environment and performing prerequisite checks...
-
OPatch continues with these patches: 19769480 20299023 20831110 21359755
-
-
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 = '/u01/app/oracle/product/12.1.0/db_1')
-
-
-
Is the local system ready for patching? [y|n]
-
y
-
User Responded with: Y
-
Backing up files...
-
Applying sub-patch '19769480' to OH '/u01/app/oracle/product/12.1.0/db_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.util, 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.oraolap, 12.1.0.2.0...
-
-
Patching component oracle.xdk.rsf, 12.1.0.2.0...
-
-
Patching component oracle.rdbms.rsf, 12.1.0.2.0...
-
-
Patching component oracle.rdbms.rman, 12.1.0.2.0...
-
-
Patching component oracle.ldap.rsf, 12.1.0.2.0...
-
-
Patching component oracle.ldap.rsf.ic, 12.1.0.2.0...
-
Applying sub-patch '20299023' to OH '/u01/app/oracle/product/12.1.0/db_1'
-
ApplySession: Optional component(s) [ oracle.has.crs, 12.1.0.2.0 ] not present in the Oracle Home or a higher version is found.
-
-
Patching component oracle.tfa, 12.1.0.2.0...
-
-
Patching component oracle.rdbms.deconfig, 12.1.0.2.0...
-
-
Patching component oracle.rdbms.rsf, 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.rdbms.rsf.ic, 12.1.0.2.0...
-
-
Patching component oracle.ldap.rsf, 12.1.0.2.0...
-
-
Patching component oracle.ldap.rsf.ic, 12.1.0.2.0...
-
Applying sub-patch '20831110' to OH '/u01/app/oracle/product/12.1.0/db_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...
-
Applying sub-patch '21359755' to OH '/u01/app/oracle/product/12.1.0/db_1'
-
-
Patching component oracle.assistants.server, 12.1.0.2.0...
-
-
Patching component oracle.rdbms.rsf, 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.tfa, 12.1.0.2.0...
-
Composite patch 21359755 successfully applied.
-
Log file location: /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/opatch2015-11-09_03-08-25AM_1.log
-
-
OPatch succeeded.
执行修改的脚本，所有pdb库必须为open状态
-
[oracle@test ~]$ export ORACLE_SID=cdb
-
[oracle@test ~]$ sqlplus / as sysdba
-
-
SQL*Plus: Release 12.1.0.2.0 Production on Mon Nov 9 03:13:47 2015
-
-
Copyright (c) 1982, 2014, Oracle. All rights reserved.
-
-
Connected to an idle instance.
-
-
SQL> startup
-
ORACLE instance started.
-
-
Total System Global Area 1073741824 bytes
-
Fixed Size 2932632 bytes
-
Variable Size 436207720 bytes
-
Database Buffers 629145600 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 PDB1 READ WRITE NO
-
4 PDB2 READ WRITE NO
-
SQL> exit
-
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@test ~]$ cd /u01/app/oracle/product/12.1.0/db_1/OPatch
-
[oracle@test OPatch]$ datapatch -verbose
-
SQL Patching tool version 12.1.0.2.0 on Mon Nov 9 03:34:21 2015
-
Copyright (c) 2015, Oracle. All rights reserved.
-
-
Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_4166_2015_11_09_03_34_21/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 5 in the binary registry and not installed in any PDB
-
-
Adding patches to installation queue and performing prereq checks...
-
Installation queue:
-
For the following PDBs: CDB$ROOT PDB$SEED PDB1 PDB2
-
Nothing to roll back
-
The following patches will be applied:
-
21359755 (Database Patch Set Update : 12.1.0.2.5 (21359755))
-
-
Installing patches...
-
Patch installation complete. Total patches installed: 4
-
-
Validating logfiles...
-
Patch 21359755 apply (pdb CDB$ROOT): SUCCESS
-
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/21359755/19194568/21359755_apply_CDB_CDBROOT_2015Nov09_03_37_03.log (no errors)
-
Patch 21359755 apply (pdb PDB$SEED): SUCCESS
-
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/21359755/19194568/21359755_apply_CDB_PDBSEED_2015Nov09_03_37_17.log (no errors)
-
Patch 21359755 apply (pdb PDB1): SUCCESS
-
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/21359755/19194568/21359755_apply_CDB_PDB1_2015Nov09_03_37_17.log (no errors)
-
Patch 21359755 apply (pdb PDB2): SUCCESS
-
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/21359755/19194568/21359755_apply_CDB_PDB2_2015Nov09_03_37_17.log (no errors)
-
SQL Patching tool complete on Mon Nov 9 03:37:40 2015
dataopatch 主是把修改的sql加载到数据库中，查询视图dba_registry_sqlpatch
-
SQL> select patch_id,patch_uid,version,action,status,bundle_series,bundle_id,description from dba_registry_sqlpatch;
-
-
PATCH_ID PATCH_UID VERSION ACTION STATUS BUNDLE_SERIES BUNDLE_ID DESCRIPTION
-
---------- ---------- -------------------- --------------- --------------- ------------------------------ ---------- ---------------------------------------------
-
21359755 19194568 12.1.0.2 APPLY SUCCESS PSU 5 Database Patch Set Update : 12.1.0.2.5 (21359
-
755)
验证opatch是否应用成功
-
[oracle@test OPatch]$ opatch lsinventory
-
Oracle Interim Patch Installer version 12.1.0.1.9
-
Copyright (c) 2015, Oracle Corporation. All rights reserved.
-
-
-
Oracle Home : /u01/app/oracle/product/12.1.0/db_1
-
Central Inventory : /u01/app/oraInventory
-
from : /u01/app/oracle/product/12.1.0/db_1/oraInst.loc
-
OPatch version : 12.1.0.1.9
-
OUI version : 12.1.0.2.0
-
Log file location : /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/opatch2015-11-09_03-44-19AM_1.log
-
-
Lsinventory Output file location : /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2015-11-09_03-44-19AM.txt
-
-
--------------------------------------------------------------------------------
-
Local Machine Information::
-
Hostname: test
-
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 Mon Nov 09 03:12:13 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.
阅读(1234) | 评论(0) | 转发(0) |
