首页 > 数据库 >oracle 19.3升级至19.16

oracle 19.3升级至19.16

时间：2022-11-12 23:01:11浏览次数：58  
标签：... 19.0 19.3 0.0 component Patching 19.16 oracle 

oracle 19.3升级至19.16
系统：CentOS 7.9
环境：单实例
课题：oracle 19.3升级至19.16
说明：要升级19.16，OPatch版本需大于12.2.0.1.30
1、当前DB版本
SQL> select comp_id,status,version from dba_registry;

COMP_ID                        STATUS      VERSION
------------------------------ ----------- ------------------------------
CATALOG                        VALID       19.0.0.0.0
CATPROC                        VALID       19.0.0.0.0
JAVAVM                         VALID       19.0.0.0.0
XML                            VALID       19.0.0.0.0
CATJAVA                        VALID       19.0.0.0.0
APS                            VALID       19.0.0.0.0
RAC                            OPTION OFF  19.0.0.0.0
OWM                            VALID       19.0.0.0.0
CONTEXT                        VALID       19.0.0.0.0
XDB                            VALID       19.0.0.0.0
ORDIM                          VALID       19.0.0.0.0

COMP_ID                        STATUS      VERSION
------------------------------ ----------- ------------------------------
SDO                            VALID       19.0.0.0.0
XOQ                            VALID       19.0.0.0.0
AMD                            OPTION OFF  11.2.0.4.0
APEX                           VALID       3.2.1.00.12

15 rows selected.

SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[oracle@oel ~]$ sqlplus -v

SQL*Plus: Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

[oracle@oel ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Aug 18 09:08:24 2022
Version 19.3.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.3.0.0.0

2、软件包处理
说明：19.16 DB的RU编号是：34133642，GI的RU编号是：34130714
安装OPatch：
sftp> lcd F:\installmedium\19c\19.15
sftp> cd /soft 
sftp> put p6880880_190000_Linux-x86-64.zip
[root@oel soft]# mkdir /patch
sftp> lcd F:\installmedium\19c\19.16
sftp> cd /patch
sftp> put p34133642_190000_Linux-x86-64.zip
[root@oel soft]# chown -R oracle:oinstall /patch

[oracle@oel OPatch]$ pwd
/u01/app/oracle/product/19.3.0/db_1/OPatch
[oracle@oel OPatch]$ ./opatch version
OPatch Version: 12.2.0.1.17

OPatch succeeded.
[oracle@oel soft]$ echo $ORACLE_HOME
/u01/app/oracle/product/19.3.0/db_1
[oracle@oel soft]$ unzip -q -o p6880880_190000_Linux-x86-64.zip -d $ORACLE_HOME 
[oracle@oel OPatch]$ ./opatch version
OPatch Version: 12.2.0.1.30

OPatch succeeded.

[oracle@oel patch]$ unzip -q p34133642_190000_Linux-x86-64.zip
[oracle@oel patch]$ pwd
/patch

3、检查补丁冲突
[oracle@oel patch]$ cd 34133642
[oracle@oel 34133642]$ pwd
/patch/34133642
[oracle@oel 34133642]$ $ORACLE_HOME/OPatch/opatch prereq  CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.2.0.1.30
Copyright (c) 2022, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/oracle/product/19.3.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/19.3.0/db_1/oraInst.loc
OPatch version    : 12.2.0.1.30
OUI version       : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2022-08-18_13-08-55PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

4、自动补丁安装
说明：apply前关闭数据库、监听、以及oracle相关进程
[oracle@oel 34133642]$ pwd
/patch/34133642
[oracle@oel 34133642]$ echo $ORACLE_HOME
/u01/app/oracle/product/19.3.0/db_1
[oracle@oel 34133642]$ $ORACLE_HOME/OPatch/opatch apply  (时间：13:13—13:39)

Oracle Interim Patch Installer version 12.2.0.1.30
Copyright (c) 2022, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/19.3.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/19.3.0/db_1/oraInst.loc
OPatch version    : 12.2.0.1.30
OUI version       : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2022-08-18_13-10-33PM_1.log

Verifying environment and performing prerequisite checks...
Prerequisite check "CheckActiveFilesAndExecutables" failed.
The details are:


Following active files/executables/libs are used by ORACLE_HOME :/u01/app/oracle/product/19.3.0/db_1
/u01/app/oracle/product/19.3.0/db_1/lib/libclntsh.so.19.1


/u01/app/oracle/product/19.3.0/db_1/bin/oracle


/u01/app/oracle/product/19.3.0/db_1/lib/libsqlplus.so
/u01/app/oracle/product/19.3.0/db_1/lib/libasmclntsh19.so

/u01/app/oracle/product/19.3.0/db_1/bin/tnslsnr
UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.
Log file location: /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2022-08-18_13-10-33PM_1.log

OPatch failed with error code 73
[oracle@oel 34133642]$ $ORACLE_HOME/OPatch/opatch apply
Oracle Interim Patch Installer version 12.2.0.1.30
Copyright (c) 2022, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/19.3.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/19.3.0/db_1/oraInst.loc
OPatch version    : 12.2.0.1.30
OUI version       : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2022-08-18_13-33-24PM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   34133642  

Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/19.3.0/db_1')


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '34133642' to OH '/u01/app/oracle/product/19.3.0/db_1'
ApplySession: Optional component(s) [ oracle.network.gsm, 19.0.0.0.0 ] , [ oracle.rdbms.ic, 19.0.0.0.0 ] , [ oracle.rdbms.tg4db2, 19.0.0.0.0 ] , [ oracle.tfa, 19.0.0.0.0 ] , [ oracle.rdbms.tg4ifmx, 19.0.0.0.0 ] , [ oracle.options.olap, 19.0.0.0.0 ] , [ oracle.ons.cclient, 19.0.0.0.0 ] , [ oracle.rdbms.tg4tera, 19.0.0.0.0 ] , [ oracle.sdo.companion, 19.0.0.0.0 ] , [ oracle.xdk.companion, 19.0.0.0.0 ] , [ oracle.options.olap.api, 19.0.0.0.0 ] , [ oracle.ons.eons.bwcompat, 19.0.0.0.0 ] , [ oracle.rdbms.tg4msql, 19.0.0.0.0 ] , [ oracle.oid.client, 19.0.0.0.0 ] , [ oracle.rdbms.tg4sybs, 19.0.0.0.0 ] , [ oracle.net.cman, 19.0.0.0.0 ] , [ oracle.network.cman, 19.0.0.0.0 ] , [ oracle.jdk, 1.8.0.191.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.bali.jewt, 11.1.1.6.0...

Patching component oracle.bali.ewt, 11.1.1.6.0...

Patching component oracle.help.ohj, 11.1.1.7.0...

Patching component oracle.perlint, 5.28.1.0.0...

Patching component oracle.rdbms.locator, 19.0.0.0.0...

Patching component oracle.perlint.expat, 2.0.1.0.4...

Patching component oracle.rdbms.rsf, 19.0.0.0.0...

Patching component oracle.rdbms, 19.0.0.0.0...

Patching component oracle.rdbms.util, 19.0.0.0.0...

Patching component oracle.assistants.acf, 19.0.0.0.0...

Patching component oracle.assistants.deconfig, 19.0.0.0.0...

Patching component oracle.assistants.server, 19.0.0.0.0...

Patching component oracle.buildtools.rsf, 19.0.0.0.0...

Patching component oracle.ctx, 19.0.0.0.0...

Patching component oracle.dbdev, 19.0.0.0.0...

Patching component oracle.dbjava.ic, 19.0.0.0.0...

Patching component oracle.dbjava.jdbc, 19.0.0.0.0...

Patching component oracle.dbjava.ucp, 19.0.0.0.0...

Patching component oracle.duma, 19.0.0.0.0...

Patching component oracle.javavm.client, 19.0.0.0.0...

Patching component oracle.ldap.owm, 19.0.0.0.0...

Patching component oracle.ldap.rsf, 19.0.0.0.0...

Patching component oracle.ldap.security.osdt, 19.0.0.0.0...

Patching component oracle.marvel, 19.0.0.0.0...

Patching component oracle.network.rsf, 19.0.0.0.0...

Patching component oracle.odbc.ic, 19.0.0.0.0...

Patching component oracle.oracore.rsf, 19.0.0.0.0...

Patching component oracle.precomp.common.core, 19.0.0.0.0...

Patching component oracle.rdbms.crs, 19.0.0.0.0...

Patching component oracle.rdbms.dbscripts, 19.0.0.0.0...

Patching component oracle.rdbms.deconfig, 19.0.0.0.0...

Patching component oracle.rdbms.oci, 19.0.0.0.0...

Patching component oracle.rhp.db, 19.0.0.0.0...

Patching component oracle.sdo, 19.0.0.0.0...

Patching component oracle.sdo.locator.jrf, 19.0.0.0.0...

Patching component oracle.sqlplus, 19.0.0.0.0...

Patching component oracle.sqlplus.ic, 19.0.0.0.0...

Patching component oracle.wwg.plsql, 19.0.0.0.0...

Patching component oracle.ctx.rsf, 19.0.0.0.0...

Patching component oracle.ons, 19.0.0.0.0...

Patching component oracle.rdbms.rman, 19.0.0.0.0...

Patching component oracle.rdbms.install.plugins, 19.0.0.0.0...

Patching component oracle.rdbms.scheduler, 19.0.0.0.0...

Patching component oracle.dbtoolslistener, 19.0.0.0.0...

Patching component oracle.nlsrtl.rsf, 19.0.0.0.0...

Patching component oracle.rdbms.install.common, 19.0.0.0.0...

Patching component oracle.ons.ic, 19.0.0.0.0...

Patching component oracle.install.deinstalltool, 19.0.0.0.0...

Patching component oracle.oraolap, 19.0.0.0.0...

Patching component oracle.javavm.server, 19.0.0.0.0...

Patching component oracle.rdbms.hsodbc, 19.0.0.0.0...

Patching component oracle.rdbms.hs_common, 19.0.0.0.0...

Patching component oracle.precomp.rsf, 19.0.0.0.0...

Patching component oracle.xdk.rsf, 19.0.0.0.0...

Patching component oracle.ldap.client, 19.0.0.0.0...

Patching component oracle.odbc, 19.0.0.0.0...

Patching component oracle.oraolap.api, 19.0.0.0.0...

Patching component oracle.ldap.rsf.ic, 19.0.0.0.0...

Patching component oracle.ctx.atg, 19.0.0.0.0...

Patching component oracle.rdbms.drdaas, 19.0.0.0.0...

Patching component oracle.mgw.common, 19.0.0.0.0...

Patching component oracle.xdk.xquery, 19.0.0.0.0...

Patching component oracle.rdbms.dv, 19.0.0.0.0...

Patching component oracle.xdk.parser.java, 19.0.0.0.0...

Patching component oracle.ovm, 19.0.0.0.0...

Patching component oracle.xdk, 19.0.0.0.0...

Patching component oracle.oraolap.dbscripts, 19.0.0.0.0...

Patching component oracle.network.client, 19.0.0.0.0...

Patching component oracle.rdbms.lbac, 19.0.0.0.0...

Patching component oracle.ldap.ssl, 19.0.0.0.0...

Patching component oracle.sdo.locator, 19.0.0.0.0...

Patching component oracle.network.listener, 19.0.0.0.0...

Patching component oracle.rdbms.rsf.ic, 19.0.0.0.0...

Patching component oracle.precomp.common, 19.0.0.0.0...

Patching component oracle.precomp.lang, 19.0.0.0.0...

Patching component oracle.jdk, 1.8.0.201.0...
Patch 34133642 successfully applied.
Sub-set patch [29517242] has become inactive due to the application of a super-set patch [34133642].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /u01/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatch/opatch2022-08-18_13-33-24PM_1.log

OPatch succeeded.

5、检查补丁
[oracle@oel 34133642]$ $ORACLE_HOME/OPatch/opatch lspatches
34133642;Database Release Update : 19.16.0.0.220719 (34133642)
29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)

OPatch succeeded.
[oracle@oel 34133642]$ sqlplus -version

SQL*Plus: Release 19.0.0.0.0 - Production
Version 19.16.0.0.0

6、加载SQL 
说明：此步骤为加载变化的SQL到数据库，RAC环境只需在节点1执行。
[oracle@oel 34133642]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Aug 18 13:54:48 2022
Version 19.16.0.0.0

Copyright (c) 1982, 2022, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 2466249672 bytes
Fixed Size                  8899528 bytes
Variable Size             536870912 bytes
Database Buffers         1912602624 bytes
Redo Buffers                7876608 bytes
Database mounted.
Database opened.
[oracle@oel OPatch]$ cd $ORACLE_HOME/OPatch
[oracle@oel OPatch]$ pwd
/u01/app/oracle/product/19.3.0/db_1/OPatch
[oracle@oel OPatch]$ ./datapatch -verbose  (时间：13:56—14:05)
SQL Patching tool version 19.16.0.0.0 Production on Thu Aug 18 13:56:57 2022
Copyright (c) 2012, 2022, Oracle.  All rights reserved.

Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_100881_2022_08_18_13_56_57/sqlpatch_invocation.log

Connecting to database...OK
Gathering database info...done
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.16.0.0.0 Release_Update 220703022223: Installed
  SQL registry:
    Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 17-AUG-22 08.43.14.494912 PM

Adding patches to installation queue and performing prereq checks...done
Installation queue:
  No interim patches need to be rolled back
  Patch 34133642 (Database Release Update : 19.16.0.0.220719 (34133642)):
    Apply from 19.3.0.0.0 Release_Update 190410122720 to 19.16.0.0.0 Release_Update 220703022223
  No interim patches need to be applied

Installing patches...
Patch installation complete.  Total patches installed: 1

Validating logfiles...done
Patch 34133642 apply: SUCCESS
  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/34133642/24865470/34133642_apply_ORCL150_2022Aug18_13_57_28.log (no errors)
SQL Patching tool complete on Thu Aug 18 14:05:01 2022

7、查看版本变化
SQL> col status for a10
SQL> col action for a10
SQL> col action_time for a30 
SQL> col desctiption for a60
SQL> set line 200
SQL> select patch_id,patch_type,action,status,action_time,description from dba_registry_sqlpatch;

 PATCH_ID PATCH_TYPE ACTION     STATUS     ACTION_TIME                    DESCRIPTION
---------- ---------- ---------- ---------- ------------------------------ ----------------------------------------------------------------------------------------------------
29517242 RU         APPLY      SUCCESS    17-AUG-22 08.43.14.494912 PM   Database Release Update : 19.3.0.0.190416 (29517242)
34133642 RU         APPLY      SUCCESS    18-AUG-22 02.05.01.413978 PM   Database Release Update : 19.16.0.0.220719 (34133642)
SQL> col version for a25
SQL> col comments for a80
SQL> select action_time,version,comments from dba_registry_history;

ACTION_TIME                    VERSION                   COMMENTS
------------------------------ ------------------------- --------------------------------------------------------------------------------
24-AUG-13 12.03.45.119862 PM   11.2.0.4                  Patchset 11.2.0.2.0
13-APR-22 11.15.49.782861 PM    11.2.0.4                 Patchset 11.2.0.2.0
                              19                      RDBMS_19.16.0.0.0DBRU_LINUX.X64_220701
17-AUG-22 08.43.10.619660 PM   19.0.0.0.0                Patch applied on 19.3.0.0.0: Release_Update - 190410122720
17-AUG-22 08.44.42.703002 PM   19.0.0.0.0                Upgraded from 11.2.0.4.0 to 19.3.0.0.0
18-AUG-22 02.04.16.202056 PM   19.0.0.0.0                Patch applied from 19.3.0.0.0 to 19.16.0.0.0: Release_Update - 220703022223

6 rows selected.
SQL> select comp_id,status,version from dba_registry;

COMP_ID                        STATUS     VERSION
------------------------------ ---------- -------------------------
CATALOG                        VALID      19.0.0.0.0
CATPROC                        VALID      19.0.0.0.0
JAVAVM                         VALID      19.0.0.0.0
XML                            VALID      19.0.0.0.0
CATJAVA                        VALID      19.0.0.0.0
APS                            VALID      19.0.0.0.0
RAC                            OPTION OFF 19.0.0.0.0
OWM                            VALID      19.0.0.0.0
CONTEXT                        VALID      19.0.0.0.0
XDB                            VALID      19.0.0.0.0
ORDIM                          VALID      19.0.0.0.0

COMP_ID                        STATUS     VERSION
------------------------------ ---------- -------------------------
SDO                            LOADING    19.0.0.0.0
XOQ                            VALID      19.0.0.0.0
AMD                            OPTION OFF 11.2.0.4.0
APEX                           VALID      3.2.1.00.12

15 rows selected.

标签：...,19.0,19.3,0.0,component,Patching,19.16,oracle
From： https://blog.51cto.com/u_12991611/5846833

相关文章

  • Oracle 19C学习 - 22. WITH AS 语句
    什么是WITHAS语句WITHAS相当于虚拟视图。WITHAS也叫做分解子查询或者片段子查询。定义一个SQL片段，该片段会被后面的SQL语句用到，可以近似看作一个可用的临时视图。......
  • Oracle 19C学习 - 21. 物化视图
    什么是物化视图Oracle物化视图是包括一个查询结果的数据库对象。它是一种非本地数据的本地化副本，或用来生成基于某种功能或者业务需求的汇总表。物化视图存储基于非本地......
  • Oracle 锁表如何解锁
    --查询被锁对象数目selectcount(1)fromv$locked_object;--查询被锁对象selectb.owner,b.object_name,a.session_id,a.locked_modefromv$locked_objecta,dba_o......
  • Oracle 19C学习 - 20. 临时表
    临时表是什么临时表是用来暂时保存临时数据的一个数据库对象。它只能保存在临时表空间，而无法保存在用户表空间。Oracle中，临时表分为SESSION会话和TRANSACTION事务两种。......
  • Oracle 19C学习 - 19. MERGE语句
    Merge语句的作用Merge语句可以根据不同条件，获取插入、更新、删除数据表中的行，然后从一个或者多个数据源头对表进行更新或向表中插入行。Merge语句的语法MERGEINTO表名......
  • Oracle 19C学习 - 18. 索引
    什么是索引索引的主要作用就是加速表的查询。索引可以显示创建，执行索引命令创建。索引也可以隐式创建，主键和唯一键都是隐式创建索引。索引的特征索引是模式SchemaOb......
  • OpenJDK和OracleJDK的区别说明
    转自:​​http://www.java265.com/JavaJingYan/202206/16565108803835.html​​下文笔者将讲述OpenJDK和OracleJDK的区别说明，如下所示:OpenJDK由来在2006年11月13日的JavaOn......
  • OpenEuler2203使用rpm方式安装Oracle19c的过程
    OpenEuler2203使用rpm方式安装Oracle19c的过程安装介质oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpmoracle-database-ee-19c-1.0-1.x86_64.rpmcompat-libstd......
  • Oracle SQL窗口实现上下翻页
    1.root用户安装rlwraprpm-Uvhhttps://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpmyuminstall-yrlwrap2.配置环境变量su-oraclevim.ba......
  • oracle的存储结构
    一、oracle体系结构oracle的体系结构分三类：内存结构、进程结构、存储结构 二、存储结构参考连接：Oracle存储结构数据库物理结构和逻辑结构的基本关系1、一个数据库......

赞助商

阅读排行

网站主页关于我们联系我们网站地图

本网站内容转载自其他媒体，侵权联系[admin##ips99.com]。

Copyright © 2020-2023 IPS99 版权所有 IPS99