ITPub博客

首页 > 数据库 > Oracle > 【Oracle19c】Oracle19c RAC 升级 ru:19.3-19.6

【Oracle19c】Oracle19c RAC 升级 ru:19.3-19.6

原创 Oracle 作者:xysoul_云龙 时间:2020-03-11 14:05:39 0 删除 编辑

下载相关补丁并上传至服务器

1、环境检查

--检查环境是否正常
$ORACLE_HOME/OPatch/opatch lsinventory -detail -oh /u02/app/oracle/product/19.0.0/db_1
--根据补丁包,检查是否有冲突
--grid
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/app/grid/soft/30501910/30557433
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/app/grid/soft/30501910/30489227
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/app/grid/soft/30501910/30489632
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/app/grid/soft/30501910/
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/app/grid/soft/30501910/30655595
--oracle
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/app/grid/soft/30501910/30557433
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/app/grid/soft/30501910/30489227

系统空间检查

--系统空间检查
cat /tmp/patch_list_gihome.txt
/u01/app/grid/soft/30501910/30557433
/u01/app/grid/soft/30501910/30489227
/u01/app/grid/soft/30501910/30489632
/u01/app/grid/soft/30501910/
/u01/app/grid/soft/30501910/30655595
$ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_list_gihome.txt
cat /tmp/patch_list_dbhome.txt
/u01/app/grid/soft/30501910/30557433
/u01/app/grid/soft/30501910/30489227
$ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_list_dbhome.txt

安装前分析

--每个节点执行
/u01/app/19.0.0/grid/OPatch/opatchauto apply /u01/app/grid/soft/30501910 -analyze

2.安装

--安装 每个节点执行,如数据库未开启,需手动应用sql
/u01/app/19.0.0/grid/OPatch/opatchauto apply /u01/app/grid/soft/30501910 -nonrolling
--or
--指定gi home,仅升级gi
/u01/app/19.0.0/grid/OPatch/opatchauto apply /u01/app/grid/soft/30501910 -oh /u01/app/19.0.0/grid -nonrolling
--指定oracle home
/u02/app/oracle/product/19.0.0/db_1/OPatch/opatchauto apply /u01/app/grid/soft/30501910 -oh /u02/app/oracle/product/19.0.0/db_1 -nonrolling
--应用sql
sqlplus / as sysdba
startup
alter pluggable database all open;
cd $ORACLE_HOME/OPatch
./datapatch -verbose
cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> @utlrp.sql

3.回滚

--停机状态回滚,gi home ,oracle home
/u01/app/19.0.0/grid/OPatch/opatchauto rollback /u01/app/grid/soft/30501910 -nonrolling -oh /u01/app/19.0.0/grid
/u02/app/oracle/product/19.0.0/db_1/OPatch/opatchauto rollback /u01/app/grid/soft/30501910 -nonrolling -oh /u02/app/oracle/product/19.0.0/db_1

4.升级日志

[root@rac19c bin]# /u01/app/19.0.0/grid/OPatch/opatchauto apply /u01/app/grid/soft/30501910 -nonrolling
OPatchauto session is initiated at Tue Mar 10 14:03:30 2020
System initialization log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchautodb/systemconfig2020-03-10_02-03-37PM.log.
Session log file is /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/opatchauto2020-03-10_02-03-49PM.log
The id for this session is M46H
Executing OPatch prereq operations to verify patch applicability on home /u01/app/19.0.0/grid
Executing OPatch prereq operations to verify patch applicability on home /u02/app/oracle/product/19.0.0/db_1
Patch applicability verified successfully on home /u02/app/oracle/product/19.0.0/db_1
Patch applicability verified successfully on home /u01/app/19.0.0/grid
Verifying SQL patch applicability on home /u02/app/oracle/product/19.0.0/db_1
SQL patch applicability verified successfully on home /u02/app/oracle/product/19.0.0/db_1
Preparing to bring down database service on home /u02/app/oracle/product/19.0.0/db_1
Successfully prepared home /u02/app/oracle/product/19.0.0/db_1 to bring down database service
Bringing down database service on home /u02/app/oracle/product/19.0.0/db_1
Database service successfully brought down on home /u02/app/oracle/product/19.0.0/db_1
Bringing down CRS service on home /u01/app/19.0.0/grid
CRS service brought down successfully on home /u01/app/19.0.0/grid
Performing prepatch operation on home /u02/app/oracle/product/19.0.0/db_1
Perpatch operation completed successfully on home /u02/app/oracle/product/19.0.0/db_1
Start applying binary patch on home /u02/app/oracle/product/19.0.0/db_1
Binary patch applied successfully on home /u02/app/oracle/product/19.0.0/db_1
Performing postpatch operation on home /u02/app/oracle/product/19.0.0/db_1
Postpatch operation completed successfully on home /u02/app/oracle/product/19.0.0/db_1
Start applying binary patch on home /u01/app/19.0.0/grid
Binary patch applied successfully on home /u01/app/19.0.0/grid
Starting CRS service on home /u01/app/19.0.0/grid
CRS service started successfully on home /u01/app/19.0.0/grid
Starting database service on home /u02/app/oracle/product/19.0.0/db_1
Database service successfully started on home /u02/app/oracle/product/19.0.0/db_1
Preparing home /u02/app/oracle/product/19.0.0/db_1 after database service restarted
No step execution required.........
Trying to apply SQL patch on home /u02/app/oracle/product/19.0.0/db_1
SQL patch applied successfully on home /u02/app/oracle/product/19.0.0/db_1
OPatchAuto successful.
--------------------------------Summary--------------------------------
Patching is completed successfully. Please find the summary as follows:
Host:rac19c
RAC Home:/u02/app/oracle/product/19.0.0/db_1
Version:19.0.0.0.0
Summary:
==Following patches were SKIPPED:
Patch: /u01/app/grid/soft/30501910/30489632
Reason: This patch is not applicable to this specified target type - "rac_database"
Patch: /u01/app/grid/soft/30501910/30655595
Reason: This patch is not applicable to this specified target type - "rac_database"
==Following patches were SUCCESSFULLY applied:
Patch: /u01/app/grid/soft/30501910/30489227
Log: /u02/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-10_14-06-03PM_1.log
Patch: /u01/app/grid/soft/30501910/30557433
Log: /u02/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-10_14-06-03PM_1.log
Host:rac19c
CRS Home:/u01/app/19.0.0/grid
Version:19.0.0.0.0
Summary:
==Following patches were SUCCESSFULLY applied:
Patch: /u01/app/grid/soft/30501910/30489227
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-10_14-11-42PM_1.log
Patch: /u01/app/grid/soft/30501910/30489632
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-10_14-11-42PM_1.log
Patch: /u01/app/grid/soft/30501910/30557433
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-10_14-11-42PM_1.log
Patch: /u01/app/grid/soft/30501910/30655595
Log: /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2020-03-10_14-11-42PM_1.log
Patching session reported following warning(s): 
_________________________________________________
[WARNING] The database instance 'testdb1' from '/u02/app/oracle/product/19.0.0/db_1', in host'rac19c' is not running. SQL changes, if any,  will not be applied.
To apply. the SQL changes, bring up the database instance and run the command manually from any one node (run as oracle).
Refer to the readme to get the correct steps for applying the sql changes.
OPatchauto session completed at Tue Mar 10 14:23:18 2020
Time taken to complete the session 19 minutes, 49 seconds
[oracle@rac19c OPatch]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Tue Mar 10 14:25:21 2020
Version 19.6.0.0.0
Copyright (c) 1982, 2019, Oracle.  All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 2466250400 bytes
Fixed Size            9137824 bytes
Variable Size          754974720 bytes
Database Buffers     1694498816 bytes
Redo Buffers            7639040 bytes
Database mounted.
Database opened.
SQL> alter pluggable database all open;
Pluggable database altered.
SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.6.0.0.0
cd $ORACLE_HOME/OPatch
[oracle@rac19c OPatch]$ cd $ORACLE_HOME/OPatch
[oracle@rac19c OPatch]$ ./datapatch -verbose
SQL Patching tool version 19.6.0.0.0 Production on Tue Mar 10 14:27:37 2020
Copyright (c) 2012, 2019, Oracle.  All rights reserved.
Log file for this invocation: /u02/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_49511_2020_03_10_14_27_37/sqlpatch_invocation.log
Connecting to database...OK
Gathering database info...done
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 interim SQL patches:
  No interim patches found
Current state of release update SQL patches:
  Binary registry:
    19.6.0.0.0 Release_Update 191217155004: Installed
  PDB CDB$ROOT:
    Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 07-JAN-20 01.14.24.263477 PM
  PDB MYPDB:
    Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 07-JAN-20 01.30.58.580298 PM
  PDB PDB$SEED:
    Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 07-JAN-20 01.30.58.580298 PM
Adding patches to installation queue and performing prereq checks...done
Installation queue:
  For the following PDBs: CDB$ROOT PDB$SEED MYPDB
    No interim patches need to be rolled back
    Patch 30557433 (Database Release Update : 19.6.0.0.200114 (30557433)):
      Apply from 19.3.0.0.0 Release_Update 190410122720 to 19.6.0.0.0 Release_Update 191217155004
    No interim patches need to be applied
Installing patches...
Patch installation complete.  Total patches installed: 3
Validating logfiles...done
Patch 30557433 apply (pdb CDB$ROOT): SUCCESS
  logfile: /u02/app/oracle/cfgtoollogs/sqlpatch/30557433/23305305/30557433_apply_TESTDB_CDBROOT_2020Mar10_14_28_58.log (no errors)
Patch 30557433 apply (pdb PDB$SEED): SUCCESS
  logfile: /u02/app/oracle/cfgtoollogs/sqlpatch/30557433/23305305/30557433_apply_TESTDB_PDBSEED_2020Mar10_14_35_01.log (no errors)
Patch 30557433 apply (pdb MYPDB): SUCCESS
  logfile: /u02/app/oracle/cfgtoollogs/sqlpatch/30557433/23305305/30557433_apply_TESTDB_MYPDB_2020Mar10_14_35_01.log (no errors)
SQL Patching tool complete on Tue Mar 10 14:41:42 2020
[oracle@rac19c OPatch]$ ./opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.19
Copyright (c) 2020, Oracle Corporation.  All rights reserved.
Oracle Home       : /u02/app/oracle/product/19.0.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u02/app/oracle/product/19.0.0/db_1/oraInst.loc
OPatch version    : 12.2.0.1.19
OUI version       : 12.2.0.7.0
Log file location : /u02/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatch/opatch2020-03-10_14-25-09PM_1.log
Lsinventory Output file location : /u02/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2020-03-10_14-25-09PM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: rac19c
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1): 
Oracle Database 19c                                                  19.0.0.0.0
There are 1 products installed in this Oracle Home.
Interim patches (2) :
Patch  30557433     : applied on Tue Mar 10 14:08:14 CST 2020
Unique Patch ID:  23305305
Patch description:  "Database Release Update : 19.6.0.0.200114 (30557433)"
   Created on 6 Jan 2020, 19:07:34 hrs PST8PDT
   Bugs fixed:
     30545281, 8476681, 14735102, 17428816, 19080742, 19697993, 20313356
     21374587, 21965541, 23296836, 23606241, 24687075, 25756945, 25806201
     25883179, 25986062, 25997810, 26476244, 26611353, 26739322, 26777814
     26872233, 27036163, 27044169, 27101798, 27126938, 27195935, 27244999
     27254335, 27359766, 27369515, 27406105, 27411022, 27423500, 27439716
     27453490, 27458357, 27489107, 27666312, 27710072, 27729678, 27846298
     27880025, 27934711, 27935464, 27941110, 27957203, 27967484, 28064977
     28072567, 28109326, 28125947, 28129791, 28181021, 28189466, 28204262
     28205555, 28209985, 28210681, 28271258, 28271693, 28279456, 28294563
     28313275, 28319114, 28326928, 28350595, 28371123, 28373960, 28375383
     28379065, 28381939, 28386259, 28390273, 28395302, 28397317, 28402823
     28410431, 28431445, 28435333, 28454215, 28463226, 28475242, 28484299
     28489419, 28492006, 28498976, 28502773, 28513333, 28521330, 28530171
     28534475, 28538439, 28542455, 28546290, 28547068, 28547926, 28558645
     28561704, 28567417, 28567819, 28569897, 28572407, 28572533, 28572544
     28572667, 28572834, 28578945, 28587723, 28589509, 28593682, 28594086
     28597221, 28601957, 28605066, 28606598, 28612239, 28620697, 28625862
     28627033, 28636532, 28639299, 28643718, 28644549, 28645570, 28646200
     28646939, 28649388, 28655209, 28663782, 28672457, 28673945, 28692103
     28692275, 28694872, 28696373, 28705231, 28710385, 28710734, 28714461
     28715727, 28718469, 28719348, 28720204, 28720418, 28721497, 28722229
     28730079, 28734355, 28740708, 28742555, 28749853, 28752923, 28755011
     28758722, 28760206, 28765983, 28767240, 28769456, 28772390, 28774416
     28776811, 28777214, 28781754, 28785531, 28789531, 28791852, 28795551
     28795734, 28802734, 28804517, 28810381, 28811560, 28815123, 28815355
     28817449, 28819640, 28820669, 28821847, 28824482, 28827682, 28831971
     28833912, 28835937, 28836716, 28844738, 28849776, 28854004, 28855520
     28855922, 28857552, 28862532, 28863432, 28863487, 28867992, 28873575
     28875089, 28876253, 28876639, 28878865, 28882784, 28884931, 28887305
     28888327, 28889730, 28892794, 28897512, 28899663, 28901126, 28905457
     28905615, 28907196, 28912691, 28915561, 28917080, 28918429, 28919145
     28922227, 28922532, 28922608, 28925634, 28925880, 28927452, 28932914
     28933158, 28935293, 28936114, 28937717, 28938698, 28940179, 28940281
     28941901, 28942455, 28945421, 28945994, 28949888, 28950868, 28951533
     28952168, 28954762, 28955606, 28955883, 28956908, 28957292, 28957723
     28958088, 28959493, 28960863, 28962775, 28965084, 28965095, 28965231
     28965376, 28966444, 28974083, 28977322, 28983095, 28983486, 28985478
     28986207, 28986231, 28986257, 28986326, 28986481, 28988482, 28989306
     28993295, 28993353, 28994307, 28996376, 29000000, 29001305, 29001888
     29002488, 29002784, 29002927, 29003407, 29003738, 29006318, 29006621
     29007321, 29007353, 29007775, 29008035, 29008669, 29009513, 29010126
     29011936, 29012609, 29013475, 29013832, 29014076, 29015118, 29017265
     29018655, 29019121, 29021063, 29021352, 29022986, 29024054, 29024552
     29024732, 29026582, 29026606, 29027456, 29027694, 29027940, 29031575
     29031600, 29032234, 29032276, 29032457, 29032607, 29033052, 29033145
     29033200, 29033280, 29034587, 29037290, 29038528, 29038728, 29039089
     29039510, 29040739, 29043554, 29043651, 29043725, 29044763, 29044954
     29046482, 29047850, 29048178, 29048289, 29048498, 29048605, 29050357
     29050560, 29050765, 29050886, 29051702, 29051953, 29052726, 29053783
     29056024, 29056270, 29056560, 29056767, 29056894, 29059011, 29060216
     29061016, 29061959, 29062692, 29062848, 29062860, 29062868, 29110526
     29110783, 29110790, 29110797, 29110802, 29110805, 29111598, 29113282
     29113305, 29115857, 29117526, 29117642, 29118543, 29119077, 29120223
     29122224, 29122254, 29123297, 29123432, 29123482, 29124368, 29125036
     29125374, 29125380, 29126345, 29127957, 29128693, 29128935, 29129450
     29129497, 29129712, 29130219, 29131539, 29132869, 29132938, 29133470
     29134447, 29135383, 29135649, 29136111, 29138641, 29139956, 29141316
     29141341, 29141685, 29142609, 29142667, 29143516, 29144995, 29145214
     29145730, 29149829, 29150338, 29151520, 29152357, 29155099, 29157051
     29157389, 29158680, 29158899, 29159909, 29159936, 29160174, 29162095
     29163156, 29163415, 29163437, 29163524, 29163567, 29167111, 29167342
     29167374, 29167940, 29168137, 29168219, 29168433, 29169073, 29169215
     29170232, 29171683, 29171942, 29172618, 29172826, 29173140, 29173373
     29173817, 29174004, 29176318, 29177466, 29177543, 29177886, 29178385
     29180313, 29180455, 29180559, 29180893, 29181153, 29181231, 29181620
     29181743, 29181923, 29182019, 29182517, 29182901, 29183912, 29184297
     29184666, 29185193, 29186456, 29189302, 29189307, 29189889, 29190235
     29190474, 29190663, 29190740, 29191541, 29192419, 29192468, 29192685
     29193207, 29194205, 29194367, 29194493, 29194827, 29194981, 29195279
     29195337, 29195758, 29196725, 29198092, 29198913, 29199635, 29199733
     29200316, 29200700, 29201494, 29201539, 29201787, 29202104, 29202461
     29202850, 29203122, 29203166, 29203425, 29203443, 29203604, 29205281
     29205323, 29205419, 29205463, 29205767, 29205918, 29206109, 29206605
     29207073, 29208260, 29208732, 29211457, 29211724, 29212012, 29212433
     29212611, 29213320, 29213351, 29213613, 29213775, 29213850, 29213879
     29214561, 29214960, 29216312, 29216723, 29216746, 29216984, 29217294
     29217472, 29217828, 29217848, 29218570, 29219205, 29219273, 29220079
     29221248, 29221891, 29221942, 29222031, 29222784, 29223833, 29223859
     29223967, 29224065, 29224605, 29225076, 29225168, 29225758, 29227602
     29228869, 29229164, 29229754, 29229844, 29229955, 29230252, 29230565
     29231133, 29232117, 29232154, 29232449, 29233415, 29233810, 29233953
     29234123, 29236573, 29237538, 29237575, 29237744, 29240307, 29240759
     29241345, 29241651, 29242017, 29242884, 29243958, 29245137, 29245160
     29246163, 29247415, 29247712, 29247906, 29248495, 29248552, 29248835
     29248858, 29249412, 29249991, 29250059, 29250317, 29251259, 29253184
     29253871, 29254031, 29254930, 29255178, 29255273, 29255431, 29255435
     29256426, 29259119, 29259320, 29260452, 29260956, 29261547, 29261548
     29261906, 29262512, 29262887, 29265448, 29266248, 29266899, 29267292
     29268412, 29269171, 29269228, 29269825, 29270585, 29273539, 29273570
     29273735, 29273812, 29273847, 29274428, 29274564, 29274627, 29275461
     29276272, 29277317, 29278218, 29278684, 29279658, 29279751, 29279854
     29281527, 29281691, 29281796, 29282233, 29282898, 29285197, 29285503
     29285788, 29285956, 29286037, 29286229, 29287130, 29287705, 29292837
     29293072, 29293574, 29297863, 29297915, 29298220, 29299049, 29299082
     29299844, 29301463, 29301566, 29302963, 29303918, 29304781, 29306226
     29306713, 29307638, 29311528, 29311588, 29312310, 29312672, 29312734
     29312753, 29312889, 29313347, 29313417, 29313525, 29314539, 29314636
     29317756, 29318410, 29319441, 29321489, 29323946, 29324568, 29324735
     29325087, 29325105, 29325257, 29325765, 29325993, 29327044, 29329042
     29329087, 29329807, 29330361, 29331066, 29331209, 29331380, 29331493
     29332292, 29332395, 29332763, 29332771, 29333500, 29336843, 29337310
     29337742, 29338315, 29338348, 29338453, 29338780, 29338913, 29339101
     29339155, 29341209, 29343086, 29343861, 29345937, 29346057, 29346211
     29346943, 29347620, 29348176, 29350052, 29350762, 29351386, 29351662
     29351716, 29351735, 29351749, 29352298, 29352724, 29352867, 29352947
     29353271, 29353432, 29353821, 29353960, 29355654, 29356547, 29356704
     29356711, 29356752, 29358509, 29358828, 29360252, 29360285, 29360672
     29360911, 29360950, 29361319, 29361472, 29361801, 29363151, 29364171
     29364177, 29366940, 29367019, 29367561, 29368253, 29368310, 29372541
     29373418, 29373588, 29374179, 29375355, 29375941, 29375984, 29376346
     29377804, 29377986, 29378029, 29378834, 29378913, 29379978, 29382641
     29382784, 29382815, 29383695, 29384781, 29384854, 29384864, 29385429
     29385652, 29386502, 29386635, 29386660, 29387073, 29387274, 29388020
     29388072, 29388094, 29388524, 29388830, 29389889, 29390011, 29390435
     29390785, 29391030, 29391237, 29391849, 29391925, 29392966, 29393291
     29394014, 29394140, 29394749, 29395657, 29397954, 29397996, 29398488
     29398863, 29399046, 29399100, 29399121, 29399336, 29399938, 29402131
     29404483, 29405012, 29405462, 29405651, 29405996, 29407804, 29408853
     29409149, 29409455, 29410311, 29410834, 29411037, 29411469, 29412066
     29412269, 29416688, 29417173, 29417719, 29417884, 29418165, 29420834
     29421059, 29423003, 29423016, 29423156, 29423826, 29424999, 29426241
     29429017, 29429264, 29429466, 29429566, 29430524, 29430866, 29431192
     29431485, 29432176, 29434301, 29435474, 29435652, 29436454, 29436514
     29436727, 29437594, 29437712, 29438277, 29438736, 29439522, 29441196
     29443187, 29443250, 29444072, 29444282, 29444602, 29446669, 29448498
     29449477, 29449845, 29449852, 29450193, 29450421, 29450812, 29450936
     29451386, 29452251, 29452576, 29452936, 29452953, 29454978, 29455424
     29456714, 29457312, 29457370, 29457502, 29457807, 29457978, 29460252
     29461420, 29461791, 29462594, 29462767, 29462957, 29463047, 29463528
     29464616, 29464779, 29465177, 29467622, 29469565, 29470291, 29471860
     29472618, 29476473, 29481584, 29483452, 29483532, 29483626, 29483672
     29483685, 29483712, 29483723, 29483771, 29485099, 29486181, 29488894
     29489436, 29489546, 29490256, 29492127, 29492939, 29493122, 29494245
     29495057, 29495684, 29497311, 29497588, 29497696, 29498198, 29500257
     29500826, 29502561, 29503543, 29503631, 29503827, 29504492, 29504682
     29505668, 29507270, 29507616, 29508681, 29509777, 29510278, 29511611
     29514479, 29515134, 29515240, 29515476, 29515766, 29515834, 29516300
     29516727, 29516766, 29517168, 29517883, 29521187, 29521688, 29521748
     29521862, 29522358, 29522561, 29522662, 29523055, 29523511, 29524599
     29525467, 29525886, 29526966, 29527595, 29527610, 29528368, 29529147
     29530440, 29530515, 29530812, 29530909, 29531654, 29531836, 29532532
     29536342, 29536445, 29538631, 29541742, 29541769, 29542084, 29542449
     29542643, 29543034, 29543956, 29546817, 29547010, 29547867, 29548427
     29548687, 29548722, 29549071, 29549104, 29549154, 29549730, 29552773
     29553141, 29557144, 29557261, 29557336, 29557556, 29558238, 29558975
     29559187, 29559446, 29559908, 29559981, 29564592, 29564593, 29565611
     29580394, 29580983, 29581771, 29584261, 29584693, 29586143, 29587765
     29597536, 29597754, 29598039, 29598046, 29598233, 29599008, 29599300
     29601461, 29602831, 29603460, 29603884, 29604002, 29604257, 29607136
     29607797, 29608000, 29610506, 29611020, 29611991, 29615824, 29616244
     29616414, 29618074, 29618190, 29620042, 29622936, 29625065, 29625804
     29625876, 29626154, 29626732, 29628200, 29629430, 29629650, 29629681
     29629745, 29631749, 29632095, 29632265, 29632611, 29633697, 29633753
     29633936, 29634643, 29635427, 29635717, 29635990, 29637362, 29637526
     29638285, 29641736, 29643721, 29645349, 29648928, 29651183, 29651520
     29653132, 29653246, 29655668, 29656819, 29657422, 29657960, 29661028
     29661065, 29661722, 29663368, 29664087, 29664161, 29665940, 29667994
     29668005, 29669413, 29670782, 29671363, 29672507, 29676089, 29677051
     29677173, 29677733, 29677927, 29679856, 29681987, 29683039, 29687214
     29687459, 29687718, 29687763, 29689145, 29689255, 29692694, 29694869
     29695425, 29695841, 29696310, 29700125, 29700460, 29700770, 29703932
     29707099, 29707896, 29708915, 29710188, 29710858, 29713810, 29715220
     29716194, 29716491, 29717659, 29719146, 29720133, 29721418, 29725476
     29725781, 29726695, 29739576, 29741976, 29742223, 29746962, 29747493
     29747648, 29747653, 29748285, 29748336, 29748513, 29749471, 29750673
     29751094, 29753244, 29754951, 29755821, 29756274, 29756444, 29757099
     29757264, 29757651, 29758217, 29758661, 29761678, 29761837, 29761911
     29765393, 29766207, 29766503, 29766679, 29768899, 29770750, 29771032
     29771242, 29773197, 29773842, 29775393, 29779196, 29782211, 29782823
     29782866, 29784106, 29785239, 29787292, 29787766, 29791152, 29791880
     29793318, 29794462, 29795712, 29795957, 29796378, 29797726, 29802695
     29804875, 29805772, 29809837, 29812489, 29813503, 29815713, 29817278
     29821582, 29825525, 29827852, 29831196, 29834506, 29836096, 29838485
     29838773, 29839715, 29840619, 29841267, 29841687, 29843277, 29843692
     29844226, 29845530, 29846126, 29846645, 29848084, 29848849, 29849100
     29850930, 29851733, 29853485, 29858121, 29858376, 29865188, 29865658
     29869086, 29869404, 29869887, 29870065, 29871098, 29873665, 29875459
     29875565, 29877608, 29878076, 29881478, 29881839, 29882729, 29884958
     29887111, 29888621, 29890740, 29891916, 29893132, 29897418, 29897863
     29900203, 29902327, 29902330, 29903299, 29903454, 29906678, 29907942
     29909658, 29912286, 29914449, 29915217, 29915848, 29916975, 29920025
     29921318, 29926466, 29927756, 29928210, 29937565, 29938225, 29940373
     29942096, 29942554, 29943670, 29944035, 29944660, 29945645, 29946388
     29951620, 29956016, 29957493, 29961609, 29962248, 29962927, 29962939
     29966768, 29967223, 29968085, 29970298, 29971027, 29971888, 29989783
     29989845, 29991257, 29997326, 30003187, 30006159, 30006985, 30007797
     30008125, 30008214, 30009710, 30015070, 30019864, 30024618, 30029806
     30032376, 30033547, 30034456, 30035598, 30038392, 30040157, 30042490
     30043610, 30044507, 30047702, 30047765, 30051176, 30051783, 30053036
     30058149, 30058453, 30059106, 30059109, 30066352, 30074349, 30074472
     30075037, 30076197, 30078675, 30079949, 30080266, 30081580, 30083488
     30084971, 30085897, 30086992, 30090568, 30092859, 30095591, 30095952
     30097092, 30098251, 30099454, 30101186, 30104555, 30106748, 30110224
     30110370, 30110518, 30114489, 30114534, 30127522, 30127904, 30131645
     30135396, 30142907, 30149658, 30150606, 30154633, 30155837, 30159329
     30164714, 30165493, 30165503, 30170104, 30174401, 30175291, 30177597
     30178250, 30187866, 30189516, 30191274, 30193165, 30206493, 30218044
     30223712, 30223847, 30224950, 30235919, 30246179, 30247305, 30252098
     30252156, 30253608, 30255143, 30264405, 30266791, 30269428, 30274188
     30282591, 30299817, 30312094, 30318638, 30324180, 30342878, 30365745
     30389229, 30402386, 30408515, 30412188, 30453442, 30458593, 30474167
     30474774, 30485255, 30534827, 30641755
Patch  30489227     : applied on Tue Mar 10 14:06:26 CST 2020
Unique Patch ID:  23305624
Patch description:  "OCW RELEASE UPDATE 19.6.0.0.0 (30489227)"
   Created on 7 Jan 2020, 03:37:45 hrs PST8PDT
   Bugs fixed:
     17787434, 25736599, 26675491, 27148384, 27222128, 27262781, 27572040
     27604329, 27760043, 27877830, 28302580, 28319989, 28406406, 28441307
     28470673, 28554809, 28621543, 28628631, 28642469, 28697242, 28697896
     28699321, 28704073, 28710663, 28747089, 28755846, 28762163, 28772816
     28785321, 28800508, 28805158, 28808652, 28815557, 28847541, 28847572
     28847655, 28852065, 28865162, 28870111, 28870496, 28871040, 28874416
     28874529, 28874678, 28877252, 28881191, 28881848, 28887933, 28888083
     28892095, 28911140, 28912188, 28917537, 28925250, 28925460, 28935956
     28940472, 28942694, 28951332, 28958624, 28963036, 28968779, 28973989
     28980448, 28984430, 28987100, 28995287, 29003207, 29003617, 29016294
     29018680, 29024876, 29026154, 29027933, 29030056, 29047127, 29051269
     29052850, 29053083, 29058476, 29111631, 29112455, 29117337, 29118754
     29123444, 29125708, 29125786, 29129476, 29130169, 29131772, 29132456
     29139727, 29146157, 29147849, 29149170, 29152603, 29152752, 29154631
     29154636, 29154829, 29159216, 29159661, 29160462, 29161923, 29169540
     29169739, 29170717, 29173618, 29181568, 29182920, 29183298, 29186091
     29191827, 29201143, 29201695, 29202442, 29209545, 29209972, 29210577
     29210610, 29210624, 29210683, 29213641, 29218185, 29219627, 29224294
     29225861, 29229839, 29231008, 29235934, 29242906, 29243749, 29244495
     29244766, 29244968, 29248723, 29249583, 29251564, 29254863, 29255616
     29257308, 29260224, 29261171, 29261695, 29266584, 29268887, 29271019
     29273360, 29274911, 29275362, 29276220, 29280752, 29282090, 29282666
     29285453, 29285621, 29288842, 29289634, 29290235, 29292232, 29293806
     29293928, 29294753, 29299830, 29307090, 29307109, 29311336, 29318127
     29329675, 29330791, 29338139, 29339299, 29342966, 29347106, 29351297
     29351881, 29357821, 29359713, 29360467, 29360775, 29367971, 29368725
     29376616, 29377086, 29379299, 29379381, 29380201, 29380253, 29380496
     29380527, 29381000, 29382296, 29385861, 29387212, 29390900, 29391301
     29392779, 29393649, 29395961, 29397888, 29398418, 29402110, 29407192
     29411931, 29413360, 29413448, 29416851, 29433434, 29438073, 29445982
     29450417, 29452365, 29457241, 29457319, 29460775, 29462569, 29465047
     29468589, 29470298, 29471399, 29473188, 29478378, 29485756, 29490266
     29495628, 29498957, 29499868, 29502953, 29504266, 29505022, 29505730
     29507560, 29510452, 29518947, 29524627, 29528119, 29529127, 29529530
     29529973, 29535802, 29537427, 29540165, 29542152, 29545235, 29549429
     29552763, 29555663, 29583036, 29585881, 29592188, 29593025, 29599431
     29599530, 29600906, 29601549, 29605539, 29618725, 29623009, 29632615
     29637215, 29641885, 29645874, 29655862, 29657866, 29659031, 29663838
     29671651, 29671851, 29671933, 29672162, 29672852, 29684210, 29684609
     29684672, 29686671, 29690422, 29692674, 29694497, 29721974, 29722328
     29741589, 29754146, 29760252, 29760705, 29769321, 29770006, 29770719
     29772541, 29780086, 29786752, 29797504, 29797626, 29798124, 29799836
     29805654, 29814993, 29817598, 29825944, 29828755, 29838281, 29839229
     29841704, 29851066, 29852422, 29853256, 29862652, 29862828, 29866585
     29867220, 29868392, 29876493, 29885967, 29893587, 29896074, 29909288
     29910893, 29921525, 29936936, 29939536, 29958570, 29972301, 29997804
     30006937, 30007337, 30009279, 30009884, 30012348, 30022613, 30028540
     30028697, 30032515, 30033476, 30039843, 30043518, 30047157, 30076461
     30080241, 30085531, 30123264, 30140462, 30142644, 30155486, 30159782
     30165554, 30191807, 30203000, 30210185, 30216942, 30226726, 30252076
     30300812, 30303080, 30422030, 30461079, 30461097, 30472602, 30482794
     30499905, 30559848, 3
--------------------------------------------------------------------------------
OPatch succeeded.
[oracle@rac19c admin]$ sql
SQL*Plus: Release 19.0.0.0.0 - Production on Tue Mar 10 14:54:27 2020
Version 19.6.0.0.0
Copyright (c) 1982, 2019, Oracle.  All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.6.0.0.0
SQL> select PATCH_ID,PATCH_TYPE,ACTION,STATUS,TARGET_VERSION from dba_registry_sqlpatch;
  PATCH_ID PATCH_TYPE ACTION          STATUS            TARGET_VERSION
---------- ---------- --------------- ------------------------- ---------------
  29517242 RU          APPLY          SUCCESS            19.3.0.0.0
  30557433 RU          APPLY          SUCCESS            19.6.0.0.0
SQL> 
SQL> select banner from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
SQL>

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29487349/viewspace-2679606/,如需转载,请注明出处,否则将追究法律责任。

全部评论
主要从事数据库相关工作,其他操作系统、中间件等也有涉及,热衷分享、开源,支持国产,期待中华民族全面的伟大复兴。岁月老将至,如有幸在江湖中留点踪迹,也是欣慰。 【文盲筱烨】好读书爱运动的IT技术爱好者 微博:文盲筱烨 微信公众号:筱烨视点

注册时间:2014-02-15

  • 博文量
    179
  • 访问量
    784457