以下是手动升级DB的方法,对于有grid结构的数据库,可以通过opatch auto 方式进行数据库自动升级
实验环境:
操作系统版本为 redhat 6.5
数据库版本为12.1.0.2.0 单实例
[root@test1 ~]# lsb_release -a
LSB Version: :base-4.0-amd64:base-4.0-noarch:core-4.0-amd64:core-4.0-noarch
Distributor ID: RedHatEnterpriseServer
Description: Red Hat Enterprise Linux Server release 6.5 (Santiago)
Release: 6.5
Codename: Santiago
[root@test1 ~]# uname -a
Linux test1 2.6.32-431.el6.x86_64 #1 SMP Sun Nov 10 22:19:54 EST 2013 x86_64 x86_64 x86_64 GNU/Linux
[root@test1 ~]#
下载Oracle 提供的最新的 PSU 升级到 12.1.0.12
p6880880安装是OPATCH ,OPATCH 是升级数据库PATCH的工具,必须升级到指定版本以上才能升级
p22646084是本次准备为数据库升级的PSU包
oracle psu 下载的链接
https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=434132209559742&id=1454618.1&_afrWindowMode=0&_adf.ctrl-state=1bz2bwd9mb_9#aref_section24
![993803-20160717172609545-63786272.png](https://i-blog.csdnimg.cn/blog_migrate/734bf2fde42cfa24c10f9d729d02c99e.png)
一.安装PSU之前的工作
1.检查空间
/tmp 目录必须要有10G以上的剩余空间
2. 备份
2.1 备份$ORACLE_HOME/OPatch 目录
tar -cvfj $ORACLE_HOME/OPatch /oracle/Oracle_Opatch_201607BAK.tar
2.2 备份$ORACLE_HOME
tar -cvfj $ORACLE_HOME /oracle/Oracle_Home_201607BAK.tar
3 查看README 文件
![993803-20160717172611514-1589673064.png](https://i-blog.csdnimg.cn/blog_migrate/54e82931d20dac61aaf908d065d70de3.png)
二 . 安装PSU
解压opatch 到已经备份的 $ORACLE_HOME/OPatch
unzip /tmp/p6880880_121010_Linux-x86-64.zip $ORACLE_HOME
查看opatch 已经升级到 OPatch version : 12.1.0.1.12
[oracle@test1 ~ o12c]$/oracle/app/oracle/db/OPatch/opatch lsinv
Oracle 中间补丁程序安装程序版本 12.1.0.1.12
版权所有 (c) 2016, Oracle Corporation。保留所有权利。
Oracle Home : /oracle/app/oracle/db
Central Inventory : /oracle/app/oraInventory
from : /oracle/app/oracle/db/oraInst.loc
OPatch version : 12.1.0.1.12
OUI version : 12.1.0.2.0
Log file location : /oracle/app/oracle/db/cfgtoollogs/opatch/opatch2016-07-17_11-24-59上午_1.log
Lsinventory Output file location : /oracle/app/oracle/db/cfgtoollogs/opatch/lsinv/lsinventory2016-07-17_11-24-59上午.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: test1
ARU platform id: 226
ARU platform description:: Linux x86-64
已安装的顶级产品 (1):
Oracle Database 12c 12.1.0.2.0
此 Oracle 主目录中已安装 1 个产品。
此 Oracle 主目录中未安装任何中间补丁程序。
--------------------------------------------------------------------------------
OPatch succeeded.
[oracle@test1 ~ o12c]$
README文件显示这两个关于DB的PSU
![993803-20160717172612451-654344753.png](https://i-blog.csdnimg.cn/blog_migrate/9ff6db9c057d06ad7ac5dbd178026d7b.png)
停机安装PSU
已经准备好开始安装补丁,
[oracle@test1 ~ o12c]$sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on 星期日 7月 17 11:17:04 2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
连接到:
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> shut immediate;
数据库已经关闭。
已经卸载数据库。
ORACLE 例程已经关闭。
- SQL> exit
从 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@test1 ~ o12c]$ [oracle@test1 ~ o12c]$ps -ef| grep pmom oracle 6883 6145 0 11:19 pts/1 00:00:00 grep pmom
[oracle@test1 /tmp/22646084 o12c]$export PATH=$PATH:$ORACLE_HOME/OPatch:./
补丁预安装检查
[oracle@test1 /tmp/22646084/22291127 o12c]$opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle 中间补丁程序安装程序版本 12.1.0.1.12
版权所有 (c) 2016, Oracle Corporation。保留所有权利。
PREREQ session
Oracle Home : /oracle/app/oracle/db
Central Inventory : /oracle/app/oraInventory
from : /oracle/app/oracle/db/oraInst.loc
OPatch version : 12.1.0.1.12
OUI version : 12.1.0.2.0
Log file location : /oracle/app/oracle/db/cfgtoollogs/opatch/opatch2016-07-17_11-27-47上午_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
[oracle@test1 /tmp/22646084/22291127 o12c]$cd ../22502555/
[oracle@test1 /tmp/22646084/22502555 o12c]$opatch prereq CheckConflictAgainstOHWithDetail -ph ./ Oracle 中间补丁程序安装程序版本 12.1.0.1.12 版权所有 (c) 2016, Oracle Corporation。保留所有权利。 PREREQ session Oracle Home : /oracle/app/oracle/db Central Inventory : /oracle/app/oraInventory from : /oracle/app/oracle/db/oraInst.loc OPatch version : 12.1.0.1.12 OUI version : 12.1.0.2.0 Log file location : /oracle/app/oracle/db/cfgtoollogs/opatch/opatch2016-07-17_11-29-01上午_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded.
[oracle@test1 /tmp/22646084/22502555 o12c]$
检查没有问题,开始安装OCW的PSU,没有先后顺序
[oracle@test1 /tmp/22646084/22502555 o12c]$opatch apply
Oracle 中间补丁程序安装程序版本 12.1.0.1.12
版权所有 (c) 2016, Oracle Corporation。保留所有权利。
Oracle Home : /oracle/app/oracle/db
Central Inventory : /oracle/app/oraInventory
from : /oracle/app/oracle/db/oraInst.loc
OPatch version : 12.1.0.1.12
OUI version : 12.1.0.2.0
Log file location : /oracle/app/oracle/db/cfgtoollogs/opatch/opatch2016-07-17_11-30-35上午_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 22502555
是否继续? [y|n]
y
User Responded with: Y
All checks passed.
Problem with accessing response file of "/oracle/app/oracle/db/ccr/bin/setupCCR".
请关闭本地系统上在此 ORACLE_HOME 之外运行的 Oracle 实例。
(Oracle 主目录 = '/oracle/app/oracle/db')
本地系统是否已准备打补丁? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '22502555' to OH '/oracle/app/oracle/db'
ApplySession: Oracle 主目录中不存在可选组件 [ oracle.crs, 12.1.0.2.0 ] , 或找到更高版本。
正在为组件 oracle.has.db, 12.1.0.2.0 打补丁...
正在为组件 oracle.has.common, 12.1.0.2.0 打补丁...
Patch 22502555 successfully applied.
Log file location: /oracle/app/oracle/db/cfgtoollogs/opatch/opatch2016-07-17_11-30-35上午_1.log
OPatch succeeded.
安装DB PSU
[oracle@test1 /tmp/22646084/22502555 o12c]$cd -
/tmp/22646084/22291127
[oracle@test1 /tmp/22646084/22291127 o12c]$opatch apply
Oracle 中间补丁程序安装程序版本 12.1.0.1.12
版权所有 (c) 2016, Oracle Corporation。保留所有权利。
Oracle Home : /oracle/app/oracle/db
Central Inventory : /oracle/app/oraInventory
from : /oracle/app/oracle/db/oraInst.loc
OPatch version : 12.1.0.1.12
OUI version : 12.1.0.2.0
Log file location : /oracle/app/oracle/db/cfgtoollogs/opatch/opatch2016-07-17_11-31-21上午_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 19769480 20299023 20831110 21359755 21948354 22291127
是否继续? [y|n]
y
User Responded with: Y
All checks passed.
Problem with accessing response file of "/oracle/app/oracle/db/ccr/bin/setupCCR".
请关闭本地系统上在此 ORACLE_HOME 之外运行的 Oracle 实例。
(Oracle 主目录 = '/oracle/app/oracle/db')
本地系统是否已准备打补丁? [y|n]
y
User Responded with: Y
Backing up files...
Applying sub-patch '19769480' to OH '/oracle/app/oracle/db'
正在为组件 oracle.rdbms.deconfig, 12.1.0.2.0 打补丁...
正在为组件 oracle.xdk, 12.1.0.2.0 打补丁...
正在为组件 oracle.tfa, 12.1.0.2.0 打补丁...
正在为组件 oracle.rdbms.util, 12.1.0.2.0 打补丁...
正在为组件 oracle.rdbms, 12.1.0.2.0 打补丁...
正在为组件 oracle.rdbms.dbscripts, 12.1.0.2.0 打补丁...
正在为组件 oracle.xdk.parser.java, 12.1.0.2.0 打补丁...
正在为组件 oracle.oraolap, 12.1.0.2.0 打补丁...
正在为组件 oracle.xdk.rsf, 12.1.0.2.0 打补丁...
正在为组件 oracle.rdbms.rsf, 12.1.0.2.0 打补丁...
正在为组件 oracle.rdbms.rman, 12.1.0.2.0 打补丁...
正在为组件 oracle.ldap.rsf, 12.1.0.2.0 打补丁...
正在为组件 oracle.ldap.rsf.ic, 12.1.0.2.0 打补丁...
Applying sub-patch '20299023' to OH '/oracle/app/oracle/db'
ApplySession: Oracle 主目录中不存在可选组件 [ oracle.has.crs, 12.1.0.2.0 ] , 或找到更高版本。
正在为组件 oracle.tfa, 12.1.0.2.0 打补丁...
正在为组件 oracle.rdbms.deconfig, 12.1.0.2.0 打补丁...
正在为组件 oracle.rdbms.rsf, 12.1.0.2.0 打补丁...
正在为组件 oracle.rdbms, 12.1.0.2.0 打补丁...
正在为组件 oracle.rdbms.dbscripts, 12.1.0.2.0 打补丁...
正在为组件 oracle.rdbms.rsf.ic, 12.1.0.2.0 打补丁...
正在为组件 oracle.ldap.rsf, 12.1.0.2.0 打补丁...
正在为组件 oracle.ldap.rsf.ic, 12.1.0.2.0 打补丁...
Applying sub-patch '20831110' to OH '/oracle/app/oracle/db'
正在为组件 oracle.rdbms, 12.1.0.2.0 打补丁...
正在为组件 oracle.oraolap.dbscripts, 12.1.0.2.0 打补丁...
正在为组件 oracle.ldap.rsf, 12.1.0.2.0 打补丁...
正在为组件 oracle.tfa, 12.1.0.2.0 打补丁...
正在为组件 oracle.rdbms.dbscripts, 12.1.0.2.0 打补丁...
正在为组件 oracle.rdbms.rsf, 12.1.0.2.0 打补丁...
Applying sub-patch '21359755' to OH '/oracle/app/oracle/db'
正在为组件 oracle.assistants.server, 12.1.0.2.0 打补丁...
正在为组件 oracle.rdbms.rsf, 12.1.0.2.0 打补丁...
正在为组件 oracle.rdbms, 12.1.0.2.0 打补丁...
正在为组件 oracle.rdbms.dbscripts, 12.1.0.2.0 打补丁...
正在为组件 oracle.tfa, 12.1.0.2.0 打补丁...
Applying sub-patch '21948354' to OH '/oracle/app/oracle/db'
正在为组件 oracle.rdbms.deconfig, 12.1.0.2.0 打补丁...
正在为组件 oracle.xdk, 12.1.0.2.0 打补丁...
正在为组件 oracle.tfa, 12.1.0.2.0 打补丁...
正在为组件 oracle.rdbms, 12.1.0.2.0 打补丁...
正在为组件 oracle.rdbms.dbscripts, 12.1.0.2.0 打补丁...
正在为组件 oracle.xdk.parser.java, 12.1.0.2.0 打补丁...
正在为组件 oracle.rdbms.rsf, 12.1.0.2.0 打补丁...
正在为组件 oracle.xdk.rsf, 12.1.0.2.0 打补丁...
Applying sub-patch '22291127' to OH '/oracle/app/oracle/db'
ApplySession: Oracle 主目录中不存在可选组件 [ oracle.oid.client, 12.1.0.2.0 ] , 或找到更高版本。
正在为组件 oracle.ldap.rsf, 12.1.0.2.0 打补丁...
正在为组件 oracle.ldap.client, 12.1.0.2.0 打补丁...
正在为组件 oracle.tfa, 12.1.0.2.0 打补丁...
正在为组件 oracle.rdbms, 12.1.0.2.0 打补丁...
正在为组件 oracle.rdbms.dbscripts, 12.1.0.2.0 打补丁...
正在为组件 oracle.rdbms.rsf, 12.1.0.2.0 打补丁...
正在为组件 oracle.oraolap, 12.1.0.2.0 打补丁...
正在为组件 oracle.rdbms.rman, 12.1.0.2.0 打补丁...
正在为组件 oracle.oraolap.dbscripts, 12.1.0.2.0 打补丁...
Composite patch 22291127 successfully applied.
Log file location: /oracle/app/oracle/db/cfgtoollogs/opatch/opatch2016-07-17_11-31-21上午_1.log
OPatch succeeded.
[oracle@test1 /tmp/22646084/22291127 o12c]$
安装成功 ,检查安装
[oracle@test1 ~ o12c]$opatch lsinv
Oracle 中间补丁程序安装程序版本 12.1.0.1.12
版权所有 (c) 2016, Oracle Corporation。保留所有权利。
Oracle Home : /oracle/app/oracle/db
Central Inventory : /oracle/app/oraInventory
from : /oracle/app/oracle/db/oraInst.loc
OPatch version : 12.1.0.1.12
OUI version : 12.1.0.2.0
Log file location : /oracle/app/oracle/db/cfgtoollogs/opatch/opatch2016-07-17_11-36-38上午_1.log
Lsinventory Output file location : /oracle/app/oracle/db/cfgtoollogs/opatch/lsinv/lsinventory2016-07-17_11-36-38上午.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: test1
ARU platform id: 226
ARU platform description:: Linux x86-64
已安装的顶级产品 (1):
Oracle Database 12c 12.1.0.2.0
此 Oracle 主目录中已安装 1 个产品。
中间补丁程序 (2) :
Patch 22291127 : applied on Sun Jul 17 11:32:55 CST 2016
Unique Patch ID: 19694308
Patch description: "Database Patch Set Update : 12.1.0.2.160419 (22291127)"
Created on 6 Apr 2016, 03:46:21 hrs PST8PDT
Sub-patch 21948354; "Database Patch Set Update : 12.1.0.2.160119 (21948354)"
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:
16923858, 19309466, 19518079, 19902195, 18250893, 17655240, 19371175
18940497, 19028800, 19035573, 19074147, 18456643, 17274537, 19154375
20474192, 19044962, 19289642, 18845653, 19532017, 19915271, 18417036
22374754, 20471920, 22528741, 19243521, 19052488, 19658708, 21153266
19326908, 19597583, 20074391, 19174430, 19157754, 22046677, 18921743
19865345, 19065677, 19065556, 19018447, 19018206, 19777862, 19054077
20688221, 19304354, 21899588, 13542050, 19723336, 20879889, 19835133
20890311, 19333670, 20869721, 21756699, 19687159, 14643995, 19012119
19869255, 19291380, 17551063, 18681056, 20588502, 19676012, 19520602
19841800, 19439759, 20245930, 19303936, 19001359, 19248799, 20373598
19393542, 19155797, 19279273, 18886413, 18618122, 19990037, 22353346
19141838, 19644859, 21915719, 20509482, 21421886, 19358317, 19134173
20447445, 19335438, 18966843, 19077215, 19390567, 19058490, 21526048
18799993, 19769480, 19068970, 21620471, 19023822, 21225209, 19670108
19068610, 19284031, 19450314, 19016730, 18967382, 21756677, 20476175
20919320, 20347562, 18674047, 19385656, 18849537, 20348653, 19684504
19896336, 20048359, 20899461, 19524384, 19143550, 19024808, 18948177
16439813, 18354830, 20596234, 19468991, 20440930, 20397490, 20466628
20936905, 21756661, 19791273, 19706965, 19604659, 16359751, 19032777
19329654, 18990023, 19928926, 19591608, 19307662, 20173897, 21847223
19571367, 18914624, 21668627, 20281121, 19075256, 21260431, 20877664
19501299, 19487147, 20425790, 19076343, 19430401, 19676905, 20904530
20925795, 20441797, 19124589, 19888853, 16870214, 18202441, 18743542
19001390, 21442094, 19081128, 19280225, 22173980, 21315084, 21875360
19178851, 19149990, 20294666, 20951038, 19989009, 22168163, 19606174
21517440, 19791377, 19050649, 19382851, 22762046, 19189525, 19174942
18988834, 19703301, 20122715, 19176326, 18411216, 19048007, 20117253
19258504, 21188532, 17890099, 16887946, 19238590, 18791688, 20387265
22092979, 19721304, 19490948, 19619732, 20356733, 18436647, 18499088
20165574, 18952989, 20825533, 19272708, 19547370, 20794034, 21281532
19978542, 19468347, 20284155, 20657441, 19883092, 19409212, 17365043
19805359, 20952966, 19434529, 19176223, 21300341, 18799063, 18990693
18288842, 20831538, 20424899, 19699191, 22353199, 20361671, 18674024
19689979, 20235511, 19873610, 16619249, 18964978, 21091431, 19440586
19577410, 18610915, 19561643, 19399918, 19195895, 20746251, 19183343
20043616, 18856999, 21787056, 18893947, 21273804, 19067244, 19587324
18885870, 21329301, 19536415, 17835294, 20446883, 22062026, 19189317
19708632, 21917884, 21744290, 20134339, 20711718, 18973548, 20413820
19185876, 20101006, 19197175, 20558005, 20402832, 19627012, 20093776
18909599, 19597439, 19180770, 19879746, 20618595, 19354335, 19730508
19315691, 19639483, 20331945, 19512341, 19637186, 19174521, 19022470
18607546, 18306996, 19649152, 18964939, 20318889, 20124446
Patch 22502555 : applied on Sun Jul 17 11:30:48 CST 2016
Unique Patch ID: 19941482
Patch description: "OCW Patch Set Update : 12.1.0.2.160419 (22502555)"
Created on 14 Apr 2016, 02:42:10 hrs PST8PDT
Bugs fixed:
21339083, 19701617, 18589889, 20768643, 19139608, 19280860, 19061429
21453435, 19133945, 19521169, 19341538, 20011424, 18946768, 19135521
18604143, 19361757, 19187207, 19302350, 19627476, 19130141, 19530755
20317221, 19620918, 20177779, 19699720, 19168690, 19266658, 18899171
19244316, 19653795, 18330979, 19471722, 18634372, 19027351, 21227730
18707416, 19536337, 19184188, 19131709, 21113068, 20160490, 20235486
19925992, 20995001, 20006646, 21131037, 18991776, 18439295, 19380733
21245437, 18943696, 20552947, 19591984, 19550195, 18135723, 19163425
20014326, 19524857, 18849021, 18890943, 18861196, 19154753, 17940721
18524834, 19522313, 18748932, 18835283, 19184765, 19499021, 19046190
20923930, 20028666, 14851828, 19051385, 19682695, 19050688, 19831611
20598625, 21607972, 19226141, 19053891, 18871287, 18998228, 21087799
18922918, 18980002, 19683886, 18956780, 19325604, 18777835, 19026993
17338864, 18362971, 19558324, 18261648, 18945906, 19513650, 20185476
19478119, 18882642, 19702758, 18952577, 17447588, 19414274, 20752167
19262534, 19147513, 21242118, 19514085, 19473088, 20758997, 19178517
18729269, 19659885, 19529729, 19455563, 20877072, 19319904, 18703978
20340620, 18536826, 19700256, 19703246, 19292605, 20467806, 19192901
21527118, 20660273, 20011635, 17592037, 22989069, 19147751, 19479503
19029647, 19179158, 22302421, 18901356, 19140712, 20012766, 21232394
18964974, 18835366, 19184276, 19207286, 19013789, 20001507, 20510208
18950232, 19148791, 19259765, 19680763, 20079414, 16505171, 19556820
19449737, 18962892, 21646169, 19187515, 19513888, 19230771, 14661880
21519340, 21222147, 20218012, 20795241, 19853036, 19453778, 19551830
19068333, 21616278, 18520351, 18843572, 19185148, 18945435, 20775015
19232454, 21220597, 18541110, 18834955, 19319192, 19204743, 19178629
20839581, 21694237, 19304104, 18747335, 19140891, 20676340, 20725084
19270660, 19457575, 21297657, 19021575, 19069755, 18715884, 19584688
18798573, 19812592, 19018001, 19325701, 19292272, 19270956, 20877003
21794779, 19222693, 18700893, 21276514, 19662663, 18406774, 19684131
20607821, 19010177, 21082737, 19272663, 21694632, 18910576, 18907170
19426384, 9372680, 20115586, 20883009, 19700294, 19164099, 20289828
18283792, 19331454, 19155350, 20119857, 19703199, 18955644, 18508710
19908346, 18798432, 19146822, 21123424, 19589221, 18952857, 19471836
19537762, 16286734, 18750781, 20669114, 18762843, 19045143, 18945249
19146980, 19184799, 19601003, 19205086, 20099624, 19351363, 21378016
20091753, 18862203, 19537547, 19281106, 19031737, 19079087, 18968981
19148367, 19150517, 20231741, 19954372, 19217019, 18730096, 18235274
18975620, 19205617, 19513351, 20219458, 18843054, 19150313, 18708349
19332386, 18953639, 21423055, 21259359, 19067804, 19371270, 19203996
19318983, 19209951, 19054979, 20038431, 18747382, 19154673, 18752378
19150088, 19370846, 19013444, 19234177, 21053036, 18998379, 20157569
18999857, 19273577, 19367276, 19075747, 19632437, 18990354, 19288396
19874047, 19612597, 20620581, 19557558, 19427050, 19127078, 20900588
18910443, 20053557, 20033787, 19315567, 19444471, 19148982, 20953798
18290252, 19915945, 18813323, 19777496, 19500293, 20730170, 18643483
19277814, 18523468, 19134098, 20562133, 19071526, 21420753, 18965694
19226858, 18850051, 19602208, 19591356, 20061168, 18417590, 19370739
18920408, 20822591, 19609388, 18636884, 18776786, 20136892, 22289350
18989446, 19148793, 19043795, 19585454, 20746507, 19955755, 18317489
18260170, 19059053, 18919682, 19807548, 18678829, 19124972, 19147509
18849896, 18910748, 19617592, 19319357, 19273758, 18953878, 19076165
19704993, 18999195, 19498411, 18759724, 21294273, 19459023, 20634511
21474380, 21484367, 20276459, 19066844, 17208793, 19234907, 20290467
13843841, 19538714, 19383028, 19649640, 19062675, 19513969, 18859710
20862812, 19504641, 19341481, 20293730, 19986391, 18304090, 19343245
19314048, 18834934, 19473851, 19241655, 18242738, 19458082, 19470791
18894342, 20649573, 18372060, 19522067, 18953889, 18827679, 19259290
19140711, 19023430, 19045388, 20186278, 19241857, 19076778, 19522571
19709663, 18875012, 18861564, 19066699, 19273760, 19225265, 15885689
20853464, 18819158, 21696068, 19068003, 18937186, 19916737, 19049721
21394146, 19368917, 21255373, 19635215, 19613533, 18868829, 20408163
20350915, 21327402, 22024217, 19315522, 20783416, 23101338, 19141785
19885321, 19163887, 19820247, 20363708, 18715868, 18852058, 19538241
1980403
- --------------------------------------------------------------------------------
OPatch succeeded.
最后一步,需要更新数据字典
[oracle@test1 ~ o12c]$sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on 星期日 7月 17 11:38:09 2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
已连接到空闲例程。
SQL> startup;
ORACLE 例程已经启动。
Total System Global Area 1593835520 bytes
Fixed Size 2924880 bytes
Variable Size 1023413936 bytes
Database Buffers 553648128 bytes
Redo Buffers 13848576 bytes
数据库装载完毕。
数据库已经打开。
SQL>
SQL>
SQL> @?/rdbms/admin/catbundle.sql psu apply
This script is now deprecated. Use datapatch to install any
necessary SQL patches and bundles into the database.
For more details refer to MOS Note 1609718.1.
函数已创建。
PL/SQL 过程已成功完成。
SCRIPTFILE
--------------------------------------------------------------------------------
?/javavm/install/jvmpsu.sql
SQL> SET FEEDBACK 1
SQL> SET NUMWIDTH 10
SQL> SET LINESIZE 80
SQL> SET TRIMSPOOL ON
SQL> SET TAB OFF
SQL> SET PAGESIZE 100
SQL>
SQL> -- If Java is installed, do CJS, etc.
SQL>
SQL> BEGIN
2 IF dbms_registry.is_valid('JAVAVM', dbms_registry.release_version) = 1 THEN
3
4 initjvmaux.drop_sros();
5
6 EXECUTE IMMEDIATE 'create or replace java system';
7
8 update dependency$
9 set p_timestamp=(select stime from obj$ where obj#=p_obj#)
10 where (select stime from obj$ where obj#=p_obj#)!=p_timestamp and
11 (select type# from obj$ where obj#=p_obj#)=29 and
12 (select owner# from obj$ where obj#=p_obj#)=0;
13
14 -- Sanity check: the query below should not raise any error.
15
16 EXECUTE IMMEDIATE
17 'select dbms_java.longname(''java/lang/System'') from dual';
18
19 END IF;
20 END;
21 /
- ...
- ...
- 过程略
- ...
- ...
PL/SQL 过程已成功完成。
SQL>
SQL> commit;
提交完成。
SQL>
SQL>
SQL> DROP FUNCTION file_exists;
函数已删除。