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

标题: 19.3 单实例数据库手动升级到19.7 [打印本页]

作者: 王亮 时间: 2020-7-12 16:33
标题: 19.3 单实例数据库手动升级到19.7
环境说明

	升级前	升级后
操作系统	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

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

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

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]

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]

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

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]

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]

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;

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)