重庆思庄Oracle、Redhat认证学习论坛

 找回密码
 注册

QQ登录

只需一步,快速开始

搜索
查看: 3558|回复: 0
打印 上一主题 下一主题

[Oracle] 19.3 单实例数据库手动升级到19.7

[复制链接]
跳转到指定楼层
楼主
发表于 2020-7-12 16:33:09 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
环境说明
  
  
升级前
升级后
操作系统
redhat7.5
Redhat7.5
Oracle版本
19.3.0.0
19.7.0.0
单机
多租户
多租户
OPATCH版本
12.2.0.1.17
12.2.0.1.21
Patch补丁包
p6880880_190000_Linux-x86-64.zip
  
p30783543_190000_DB_Linux-x86-64.zip


手动升级到19.7
1、       更新OPATCH
先将19.3中的OPATCH包更新为更高级的版本,否则在应用升级补丁时,会因版本过低,无法应用
查看当前OPATCH版本
[oracle@localhost OPatch]$ $ORACLE_HOME/OPatch/opatch version
OPatch Version: 12.2.0.1.17
OPatch succeeded.
更新OPATCH后,再次检查版本,验证是否升级成功
[oracle@localhost 19.3.0]$ $ORACLE_HOME/OPatch/opatch version
OPatch Version: 12.2.0.1.21
OPatch succeeded.
2、检查Patch 补丁版本冲突
[oracle@localhost 30869156]$ $ORACLE_HOME/OPatch/opatch prereqCheckConflictAgainstOHWithDetail -phBaseDir /setup/30869156/
Oracle Interim Patch Installer version 12.2.0.1.21
Copyright (c) 2020, Oracle Corporation.  All rights reserved.
PREREQ session
Oracle Home       :/u01/app/oracle/product/19.3.0
Central Inventory : /u01/app/oraInventory
   from           :/u01/app/oracle/product/19.3.0/oraInst.loc
OPatch version    :12.2.0.1.21
OUI version       :12.2.0.7.0
Log file location : /u01/app/oracle/product/19.3.0/cfgtoollogs/opatch/opatch2020-07-01_19-52-01PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
3、应用PATCH包,升级OJVM
[oracle@localhost 30783543]$/u01/app/oracle/product/19.3.0/OPatch/opatch apply -local/setup/30783543/30805684/
Oracle Interim Patch Installer version 12.2.0.1.21
Copyright (c) 2020, Oracle Corporation.  All rights reserved.
Oracle Home       :/u01/app/oracle/product/19.3.0
Central Inventory : /u01/app/oraInventory
   from           :/u01/app/oracle/product/19.3.0/oraInst.loc
OPatch version    :12.2.0.1.21
OUI version       :12.2.0.7.0
Log file location :/u01/app/oracle/product/19.3.0/cfgtoollogs/opatch/opatch2020-07-01_21-01-58PM_1.log
Verifying environment and performing prerequisite checks...
Prerequisite check "CheckSystemCommandAvailable"failed.
The details are:
Missing command :fuser
UtilSession failed:
Prerequisite check"CheckSystemCommandAvailable" failed.
Log file location: /u01/app/oracle/product/19.3.0/cfgtoollogs/opatch/opatch2020-07-01_21-01-58PM_1.log
OPatch failed with error code 73
报错处理
需要安装一个psmic包,使用yun源进行安装
[root@localhost setup]# yum install -y psmisc
Loaded plugins: langpacks, product-id, search-disabled-repos,subscription-manager
This system is not registered with an entitlement server. Youcan use subscription-manager to register.
yum                                                                                                    | 4.3 kB  00:00:00     
Resolving Dependencies
--> Running transaction check
---> Package psmisc.x86_64 0:22.20-15.el7 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
===============================================================================================================================
Package                      Arch                         Version                             Repository                 Size
===============================================================================================================================
Installing:
psmisc                       x86_64                       22.20-15.el7                        yum                       141 k
Transaction Summary
===============================================================================================================================
Install  1 Package
Total download size: 141 k
Installed size: 475 k
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing :psmisc-22.20-15.el7.x86_64                                                                                 1/1
  Verifying  : psmisc-22.20-15.el7.x86_64                                                                                  1/1
Installed:
  psmisc.x86_640:22.20-15.el7                                                                                                
Complete!
再次进行PATCH安装,安装OJVM
[oracle@localhost 30783543]$ /u01/app/oracle/product/19.3.0/OPatch/opatchapply -local /setup/30783543/30805684/
Oracle Interim Patch Installer version 12.2.0.1.21
Copyright (c) 2020, Oracle Corporation.  All rights reserved.
Oracle Home       :/u01/app/oracle/product/19.3.0
Central Inventory : /u01/app/oraInventory
   from           :/u01/app/oracle/product/19.3.0/oraInst.loc
OPatch version    :12.2.0.1.21
OUI version       :12.2.0.7.0
Log file location :/u01/app/oracle/product/19.3.0/cfgtoollogs/opatch/opatch2020-07-01_22-59-52PM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   30805684
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Please shutdown Oracle instances running out of thisORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/19.3.0')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '30805684' to OH'/u01/app/oracle/product/19.3.0'
Patching component oracle.javavm.server, 19.0.0.0.0...
Patching component oracle.javavm.server.core, 19.0.0.0.0...
Patching component oracle.rdbms.dbscripts, 19.0.0.0.0...
Patching component oracle.rdbms, 19.0.0.0.0...
Patch 30805684 successfully applied.
Log file location:/u01/app/oracle/product/19.3.0/cfgtoollogs/opatch/opatch2020-07-01_22-59-52PM_1.log
OPatch succeeded.
4、安装DB的PATCH
[oracle@localhost 30783543]$ /u01/app/oracle/product/19.3.0/OPatch/opatchapply -local /setup/30783543/30869156/
Oracle Interim Patch Installer version 12.2.0.1.21
Copyright (c) 2020, Oracle Corporation.  All rights reserved.
Oracle Home       :/u01/app/oracle/product/19.3.0
Central Inventory : /u01/app/oraInventory
   from           :/u01/app/oracle/product/19.3.0/oraInst.loc
OPatch version    :12.2.0.1.21
OUI version       :12.2.0.7.0
Log file location :/u01/app/oracle/product/19.3.0/cfgtoollogs/opatch/opatch2020-07-01_23-03-24PM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   30869156
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Please shutdown Oracle instances running out of thisORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/19.3.0')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '30869156' to OH '/u01/app/oracle/product/19.3.0'
ApplySession: Optional component(s) [ oracle.network.gsm,19.0.0.0.0 ] , [ oracle.rdbms.ic, 19.0.0.0.0 ] , [ oracle.tfa, 19.0.0.0.0 ] , [oracle.oraolap.mgmt, 19.0.0.0.0 ] , [ oracle.rdbms.tg4db2, 19.0.0.0.0 ] , [oracle.options.olap.awm, 19.0.0.0.0 ] , [ oracle.sqlj, 19.0.0.0.0 ] , [oracle.net.cman, 19.0.0.0.0 ] , [ oracle.network.cman, 19.0.0.0.0 ] , [oracle.assistants.asm, 19.0.0.0.0 ] , [ oracle.options.olap, 19.0.0.0.0 ] , [oracle.xdk.parser.java.jaxb2, 19.0.0.0.0 ] , [ oracle.assistants.usm,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.rdbms.rsf, 19.0.0.0.0...
Patching component oracle.rdbms, 19.0.0.0.0..
等待它执行完成
5、验证
查看版本
SQL>select banner_full from v$version;
SQL> selectcomp_name,version,status from dba_registry;
打开所有的PDB
SQL>alter pluggable database all open;
编译无效对象
SQL> @?/rdbms/admin/utlrp.sql
更新补丁字典信息
cd $ORACLE_HOME/OPatch
./datapatch -verbose
查看补丁字典信息
SQL> select PATCH_ID,PATCH_TYPE,ACTION,STATUS,TARGET_VERSIONfrom dba_registry_sqlpatch;


分享到:  QQ好友和群QQ好友和群 QQ空间QQ空间 腾讯微博腾讯微博 腾讯朋友腾讯朋友
收藏收藏 支持支持 反对反对
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

QQ|手机版|小黑屋|重庆思庄Oracle、Redhat认证学习论坛 ( 渝ICP备12004239号-4 )

GMT+8, 2024-11-26 23:35 , Processed in 0.124762 second(s), 21 queries .

重庆思庄学习中心论坛-重庆思庄科技有限公司论坛

© 2001-2020

快速回复 返回顶部 返回列表