升级前：
[oracle@db23
19c]$ ./bin/sqlplus / as sysdba
SQL*Plus:
Release 19.0.0.0.0 - Production on Fri Sep 13 03:54:18 2024
Version
19.3.0.0.0
升级：
[oracle@db23
36582781]$ /client/19c/OPatch/opatch apply
Oracle
Interim Patch Installer version 12.2.0.1.43
Copyright
(c) 2024, Oracle Corporation. All rights reserved.
Oracle
Home : /client/19c
Central
Inventory : /opt/oracle/oraInventory
from :
/client/19c//oraInst.loc
OPatch
version : 12.2.0.1.43
OUI
version : 12.2.0.7.0
Log
file location : /client/19c/cfgtoollogs/opatch/opatch2024-09-13_04-02-19AM_1.log
Verifying
environment and performing prerequisite checks...
OPatch
continues with these patches: 36582781
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 = '/client/19c')
Is
the local system ready for patching? [y|n]
y
User
Responded with: Y
Backing
up files...
Applying
interim patch '36582781' to OH '/client/19c'
ApplySession:
Optional component(s) [ oracle.network.gsm, 19.0.0.0.0 ] , [ oracle.rdbms, 19.0.0.0.0 ] , [ oracle.assistants.server, 19.0.0.0.0 ] , [ oracle.blaslapack, 19.0.0.0.0 ] , [ oracle.crypto.rsf, 19.0.0.0.0 ] , [ oracle.ctx, 19.0.0.0.0 ] , [ oracle.marvel, 19.0.0.0.0 ] , [ oracle.pg4appc, 19.0.0.0.0 ] , [ oracle.pg4mq, 19.0.0.0.0 ] , [ oracle.precomp.companion, 19.0.0.0.0 ] , [ oracle.rdbms.scheduler, 19.0.0.0.0 ] , [ oracle.rdbms.tg4db2, 19.0.0.0.0 ] , [ oracle.rhp.db, 19.0.0.0.0 ] , [ oracle.sdo, 19.0.0.0.0 ] , [ oracle.sdo.locator.jrf, 19.0.0.0.0 ] , [ oracle.tfa, 19.0.0.0.0 ] , [ oracle.ovm, 19.0.0.0.0 ] , [ oracle.net.cman, 19.0.0.0.0 ] , [ oracle.rdbms.drdaas, 19.0.0.0.0 ] , [ oracle.oraolap, 19.0.0.0.0 ] , [ oracle.ons.cclient, 19.0.0.0.0 ] , [ oracle.rdbms.dv, 19.0.0.0.0 ] , [ oracle.rdbms.hsodbc, 19.0.0.0.0 ] , [ oracle.rdbms.hs_common, 19.0.0.0.0 ] , [ oracle.rdbms.tg4ifmx, 19.0.0.0.0 ] , [ oracle.options.olap, 19.0.0.0.0 ] , [ oracle.rdbms.tg4msql, 19.0.0.0.0 ] , [ oracle.mgw.common, 19.0.0.0.0 ] , [ oracle.network.listener, 19.0.0.0.0 ] , [ oracle.sdo.companion, 19.0.0.0.0 ] , [ oracle.ons.eons.bwcompat, 19.0.0.0.0 ] , [ oracle.network.cman, 19.0.0.0.0 ] , [ oracle.sdo.locator, 19.0.0.0.0 ] , [ oracle.ctx.atg, 19.0.0.0.0 ] , [ oracle.rdbms.dm, 19.0.0.0.0 ] , [ oracle.oraolap.dbscripts, 19.0.0.0.0 ] , [ oracle.javavm.server, 19.0.0.0.0 ] , [ oracle.dbtoolslistener, 19.0.0.0.0 ] , [ oracle.rdbms.tg4sybs, 19.0.0.0.0 ] , [ oracle.rdbms.tg4tera, 19.0.0.0.0 ] , [ oracle.rdbms.locator, 19.0.0.0.0 ] , [ oracle.ctx.rsf, 19.0.0.0.0 ] , [ oracle.xdk.companion, 19.0.0.0.0 ] , [ oracle.options.olap.api, 19.0.0.0.0 ] , [ oracle.oid.client, 19.0.0.0.0 ] , [ oracle.rdbms.rat, 19.0.0.0.0 ] , [ oracle.rdbms.lbac, 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.util, 19.0.0.0.0...
Patching
component oracle.rdbms.rsf, 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.buildtools.rsf, 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.network.rsf, 19.0.0.0.0...
Patching
component oracle.odbc.ic, 19.0.0.0.0...
Patching
component oracle.ons, 19.0.0.0.0...
Patching
component oracle.ons.ic, 19.0.0.0.0...
Patching
component oracle.oracore.rsf, 19.0.0.0.0...
Patching
component oracle.perlint, 5.28.1.0.0...
Patching
component oracle.precomp.common.core, 19.0.0.0.0...
Patching
component oracle.nlsrtl.rsf.core, 19.0.0.0.0...
Patching
component oracle.nlsrtl.rsf.ic, 19.0.0.0.0...
Patching
component oracle.precomp.rsf, 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.ic, 19.0.0.0.0...
Patching
component oracle.rdbms.oci, 19.0.0.0.0...
Patching
component oracle.rdbms.rsf.ic, 19.0.0.0.0...
Patching
component oracle.rsf, 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.xdk.rsf, 19.0.0.0.0...
Patching
component oracle.nlsrtl.rsf.lbuilder, 19.0.0.0.0...
Patching
component oracle.rdbms.install.plugins, 19.0.0.0.0...
Patching
component oracle.install.deinstalltool, 19.0.0.0.0...
Patching
component oracle.oraolap.api, 19.0.0.0.0...
Patching
component oracle.xdk.parser.java, 19.0.0.0.0...
Patching
component oracle.xdk.xquery, 19.0.0.0.0...
Patching
component oracle.ldap.ssl, 19.0.0.0.0...
Patching
component oracle.rdbms.rman, 19.0.0.0.0...
Patching
component oracle.odbc, 19.0.0.0.0...
Patching
component oracle.ldap.client, 19.0.0.0.0...
Patching
component oracle.rdbms.install.common, 19.0.0.0.0...
Patching
component oracle.xdk, 19.0.0.0.0...
Patching
component oracle.ldap.rsf.ic, 19.0.0.0.0...
Patching
component oracle.network.client, 19.0.0.0.0...
Patching
component oracle.nlsrtl.rsf, 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
36582781 successfully applied.
Log
file location: /client/19c/cfgtoollogs/opatch/opatch2024-09-13_04-02-19AM_1.log
OPatch
succeeded.
[oracle@db23
36582781]$ /client/19c/bin/sql
sql
sqlj sqlldr sqlplus
升级后：
[oracle@db23
36582781]$ /client/19c/bin/sqlplus
SQL*Plus:
Release 19.0.0.0.0 - Production on Fri Sep 13 04:13:30 2024
Version
19.24.0.0.0
Copyright
(c) 1982, 2024, Oracle. All rights reserved.
今天群里讨论oracle的客户端升级，之前没怎么留心过，今天做了下测试，安装版的升级
和数据库升级一样，免安装版的直接下载最新的替换即可。
