19c 单实例打补丁

修改权限:

chmod 775 -R $ORACLE_HOME/OPatch

chmod 777 -R /u01/orasoft
chown -R oracle:oinstall /u01/orasoft

冲突检查:

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/orasoft/32545008/32545013

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/orasoft/32545008/32579761

[oracle@db3 ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/orasoft/32545008/32545013
Oracle Interim Patch Installer version 12.2.0.1.25
Copyright (c) 2022, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/oracle/product/19c/db_1
Central Inventory : /u01/app/oracle/oraInventory
   from           : /u01/app/oracle/product/19c/db_1/oraInst.loc
OPatch version    : 12.2.0.1.25
OUI version       : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatch/opatch2022-03-27_20-14-55PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
[oracle@db3 ~]$
[oracle@db3 ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/orasoft/32545008/32579761
Oracle Interim Patch Installer version 12.2.0.1.25
Copyright (c) 2022, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/oracle/product/19c/db_1
Central Inventory : /u01/app/oracle/oraInventory
   from           : /u01/app/oracle/product/19c/db_1/oraInst.loc
OPatch version    : 12.2.0.1.25
OUI version       : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatch/opatch2022-03-27_20-15-59PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
[oracle@db3 ~]$

冲突分析
oracle用户

$ORACLE_HOME/OPatch/opatch  apply /u01/orasoft/32545008/32545013 -analyze

y

y

 $ORACLE_HOME/OPatch/opatch  apply /u01/orasoft/32545008/32579761 -analyze

y

y

[oracle@db3 32545008]$ $ORACLE_HOME/OPatch/opatch  apply /u01/orasoft/32545008/32545013 -analyze
Oracle Interim Patch Installer version 12.2.0.1.25
Copyright (c) 2022, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/19c/db_1
Central Inventory : /u01/app/oracle/oraInventory
   from           : /u01/app/oracle/product/19c/db_1/oraInst.loc
OPatch version    : 12.2.0.1.25
OUI version       : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatch/opatch2022-03-27_20-19-54PM_1.log

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

Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
You are calling OPatch with -ocmrf option while this OPatch is generic, not being bundled with OCM. The -ocmrf option is being deprecated. Please remove it while calling OPatch.

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


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '32545013' to OH '/u01/app/oracle/product/19c/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.options.olap.api, 19.0.0.0.0 ] , [ oracle.ons.cclient, 19.0.0.0.0 ] , [ oracle.options.olap, 19.0.0.0.0 ] , [ oracle.network.cman, 19.0.0.0.0 ] , [ oracle.oid.client, 19.0.0.0.0 ] , [ oracle.ons.eons.bwcompat, 19.0.0.0.0 ] , [ oracle.net.cman, 19.0.0.0.0 ] , [ oracle.xdk.companion, 19.0.0.0.0 ] , [ oracle.jdk, 1.8.0.191.0 ]  not present in the Oracle Home or a higher version is found.
Users request no RAC file generation.  Do not create MP files.

Skip patching component oracle.rdbms.rsf, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.rdbms.util, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.rdbms, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.assistants.acf, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.assistants.deconfig, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.assistants.server, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.buildtools.rsf, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.ctx, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.dbjava.ic, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.dbjava.jdbc, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.dbjava.ucp, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.dbtoolslistener, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.duma, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.javavm.client, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.ldap.owm, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.ldap.rsf, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.marvel, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.network.rsf, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.oracore.rsf, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.precomp.common.core, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.rdbms.dbscripts, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.rdbms.deconfig, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.rdbms.oci, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.rhp.db, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.sdo, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.sdo.locator.jrf, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.sqlplus, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.wwg.plsql, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.xdk, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.odbc, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.xdk.rsf, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.dbdev, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.xdk.parser.java, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.javavm.server, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.sdo.locator, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.rdbms.install.plugins, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.mgw.common, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.ons, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.ons.ic, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.ldap.rsf.ic, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.oraolap, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.ctx.atg, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.rdbms.install.common, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.sqlplus.ic, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.oraolap.dbscripts, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.xdk.xquery, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.network.listener, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.rdbms.dv, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.oraolap.api, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.rdbms.scheduler, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.rdbms.crs, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.ctx.rsf, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.ldap.security.osdt, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.precomp.rsf, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.ldap.client, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.network.client, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.rdbms.drdaas, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.rdbms.rman, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.rdbms.lbac, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.nlsrtl.rsf, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.ovm, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.rdbms.rsf.ic, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.precomp.common, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.precomp.lang, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.jdk, 1.8.0.201.0 and its actions.
The actions are reported here, but are not performed.

ApplySession skipping inventory update.
Patch 32545013 successfully applied.
Log file location: /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatch/opatch2022-03-27_20-19-54PM_1.log

OPatch succeeded.
[oracle@db3 32545008]$ $ORACLE_HOME/OPatch/opatch  apply /u01/orasoft/32545008/32579761 -analyze
Oracle Interim Patch Installer version 12.2.0.1.25
Copyright (c) 2022, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/19c/db_1
Central Inventory : /u01/app/oracle/oraInventory
   from           : /u01/app/oracle/product/19c/db_1/oraInst.loc
OPatch version    : 12.2.0.1.25
OUI version       : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatch/opatch2022-03-27_20-25-05PM_1.log

Verifying environment and performing prerequisite checks...

--------------------------------------------------------------------------------
Start OOP by Prereq process.
Launch OOP...

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


Oracle Home       : /u01/app/oracle/product/19c/db_1
Central Inventory : /u01/app/oracle/oraInventory
   from           : /u01/app/oracle/product/19c/db_1/oraInst.loc
OPatch version    : 12.2.0.1.25
OUI version       : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatch/opatch2022-03-27_20-25-45PM_1.log

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

Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
You are calling OPatch with -ocmrf option while this OPatch is generic, not being bundled with OCM. The -ocmrf option is being deprecated. Please remove it while calling OPatch.

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


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '32579761' to OH '/u01/app/oracle/product/19c/db_1'
ApplySession: Optional component(s) [ oracle.xag, 19.0.0.0.0 ] , [ oracle.has.crs.cvu, 19.0.0.0.0 ] , [ oracle.rhp.crs, 19.0.0.0.0 ] , [ oracle.has.crs, 19.0.0.0.0 ] , [ oracle.has.cvu, 19.0.0.0.0 ]  not present in the Oracle Home or a higher version is found.
Users request no RAC file generation.  Do not create MP files.

Skip patching component oracle.rdbms, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.has.common.cvu, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.rhp.db, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.has.db, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.has.rsf, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.has.db.cvu, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.has.common, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.


Skip patching component oracle.rhp.common, 19.0.0.0.0 and its actions.
The actions are reported here, but are not performed.

ApplySession skipping inventory update.
Patch 32579761 successfully applied.
Log file location: /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatch/opatch2022-03-27_20-25-45PM_1.log

OPatch succeeded.

关闭数据库,关闭监听

[oracle@db3 ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Sun Mar 27 20:29:42 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

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[oracle@db3 ~]$ 
[oracle@db3 orasoft]$ lsnrctl stop

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 27-MAR-2022 20:31:39

Copyright (c) 1991, 2019, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=db3)(PORT=1521)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 111: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 111: Connection refused

创建补丁 oracle用户


$ORACLE_HOME/OPatch/opatch  apply /u01/orasoft/32545008/32545013 -oh /u01/app/oracle/product/19c/db_1

$ORACLE_HOME/OPatch/opatch  apply /u01/orasoft/32545008/32579761 -oh /u01/app/oracle/product/19c/db_1

[oracle@db3 ~]$ $ORACLE_HOME/OPatch/opatch  apply /u01/orasoft/32545008/32545013 -oh /u01/app/oracle/product/19c/db_1
Oracle Interim Patch Installer version 12.2.0.1.25
Copyright (c) 2022, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/19c/db_1
Central Inventory : /u01/app/oracle/oraInventory
   from           : /u01/app/oracle/product/19c/db_1/oraInst.loc
OPatch version    : 12.2.0.1.25
OUI version       : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatch/opatch2022-03-27_20-30-26PM_1.log

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

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/19c/db_1')


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '32545013' to OH '/u01/app/oracle/product/19c/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.options.olap.api, 19.0.0.0.0 ] , [ oracle.ons.cclient, 19.0.0.0.0 ] , [ oracle.options.olap, 19.0.0.0.0 ] , [ oracle.network.cman, 19.0.0.0.0 ] , [ oracle.oid.client, 19.0.0.0.0 ] , [ oracle.ons.eons.bwcompat, 19.0.0.0.0 ] , [ oracle.net.cman, 19.0.0.0.0 ] , [ oracle.xdk.companion, 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.util, 19.0.0.0.0...

Patching component oracle.rdbms, 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.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.dbtoolslistener, 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.marvel, 19.0.0.0.0...

Patching component oracle.network.rsf, 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.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.wwg.plsql, 19.0.0.0.0...

Patching component oracle.xdk, 19.0.0.0.0...

Patching component oracle.odbc, 19.0.0.0.0...

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

Patching component oracle.dbdev, 19.0.0.0.0...

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

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

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

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

Patching component oracle.mgw.common, 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.ldap.rsf.ic, 19.0.0.0.0...

Patching component oracle.oraolap, 19.0.0.0.0...

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Patching component oracle.ovm, 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 32545013 successfully applied.
Sub-set patch [29517242] has become inactive due to the application of a super-set patch [32545013].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatch/opatch2022-03-27_20-30-26PM_1.log

OPatch succeeded.
[oracle@db3 ~]$ +
bash: +: command not found...
[oracle@db3 ~]$
[oracle@db3 ~]$ $ORACLE_HOME/OPatch/opatch  apply /u01/orasoft/32545008/32579761 -oh /u01/app/oracle/product/19c/db_1
Oracle Interim Patch Installer version 12.2.0.1.25
Copyright (c) 2022, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/19c/db_1
Central Inventory : /u01/app/oracle/oraInventory
   from           : /u01/app/oracle/product/19c/db_1/oraInst.loc
OPatch version    : 12.2.0.1.25
OUI version       : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatch/opatch2022-03-27_20-48-18PM_1.log

Verifying environment and performing prerequisite checks...

--------------------------------------------------------------------------------
Start OOP by Prereq process.
Launch OOP...

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


Oracle Home       : /u01/app/oracle/product/19c/db_1
Central Inventory : /u01/app/oracle/oraInventory
   from           : /u01/app/oracle/product/19c/db_1/oraInst.loc
OPatch version    : 12.2.0.1.25
OUI version       : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatch/opatch2022-03-27_20-49-22PM_1.log

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

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/19c/db_1')


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '32579761' to OH '/u01/app/oracle/product/19c/db_1'
ApplySession: Optional component(s) [ oracle.xag, 19.0.0.0.0 ] , [ oracle.has.crs.cvu, 19.0.0.0.0 ] , [ oracle.rhp.crs, 19.0.0.0.0 ] , [ oracle.has.crs, 19.0.0.0.0 ] , [ oracle.has.cvu, 19.0.0.0.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.rdbms, 19.0.0.0.0...

Patching component oracle.has.common.cvu, 19.0.0.0.0...

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

Patching component oracle.has.db, 19.0.0.0.0...

Patching component oracle.has.rsf, 19.0.0.0.0...

Patching component oracle.has.db.cvu, 19.0.0.0.0...

Patching component oracle.has.common, 19.0.0.0.0...

Patching component oracle.rhp.common, 19.0.0.0.0...
Patch 32579761 successfully applied.
Sub-set patch [29585399] has become inactive due to the application of a super-set patch [32579761].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatch/opatch2022-03-27_20-49-22PM_1.log

OPatch succeeded.
[oracle@db3 ~]$

启库,更新datapatch,将补丁中的sql文件加载到数据库中

oracle用户
sqlplus /nolog
Connect / as sysdba;
startup;
alter pluggable database all open;
quit;

cd $ORACLE_HOME/OPatch
./datapatch -verbose

cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
CONNECT / AS SYSDBA
@utlrp.sql

[oracle@db3 ~]$ cd $ORACLE_HOME/OPatch
[oracle@db3 OPatch]$ ./datapatch -verbose
SQL Patching tool version 19.11.0.0.0 Production on Sun Mar 27 20:59:06 2022
Copyright (c) 2012, 2021, Oracle.  All rights reserved.

Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_15528_2022_03_27_20_59_06/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.11.0.0.0 Release_Update 210413004009: Installed
  SQL registry:
    Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 27-MAR-22 07.46.46.742608 PM

Adding patches to installation queue and performing prereq checks...done
Installation queue:
  No interim patches need to be rolled back
  Patch 32545013 (Database Release Update : 19.11.0.0.210420 (32545013)):
    Apply from 19.3.0.0.0 Release_Update 190410122720 to 19.11.0.0.0 Release_Update 210413004009
  No interim patches need to be applied

Installing patches...

Patch installation complete.  Total patches installed: 1

Validating logfiles...done
Patch 32545013 apply: SUCCESS
  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/32545013/24175065/32545013_apply_ORCL_2022Mar27_21_00_37.log (no errors)
SQL Patching tool complete on Sun Mar 27 21:16:58 2022
[oracle@db3 OPatch]$

  • 0
    点赞
  • 2
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值