--==== grid patching =====
[grid@baprdg01 OPatch]$ ./opatch version
OPatch Version: 12.2.0.1.17
OPatch succeeded.
[grid@baprdg01 OPatch]$
[grid@baprdg01 OPatch]$ ls -ld
drwxr-x--- 14 grid oinstall 4096 Nov 6 14:46 .
[grid@baprdg01 OPatch]$
--move OPatch Version: 12.2.0.1.17
[grid@baprdg01 OPatch]$ pwd
/u01/app/19.0.0.0/grid/OPatch
[grid@baprdg01 OPatch]$ cd ..
[grid@baprdg01 grid]$ mv OPatch/ bak_OPatch_6oct23
[grid@baprdg01 grid]$ ls -ltr
-- use OPatch Version: 12.2.0.1.33
[grid@baprdg01 grid]$ chmod -R 775 OPatch/
[grid@baprdg01 grid]$
[grid@baprdg01 grid]$ cd OPatch/
[grid@baprdg01 OPatch]$
[grid@baprdg01 OPatch]$ ./opatch version
OPatch Version: 12.2.0.1.33
OPatch succeeded.
[grid@baprdg01 OPatch]$
[grid@baprdg01 OPatch]$
/d01/app/19c/grid/OPatch
root@cbspr:/d01/app/19c/grid/crs/install# cd /d01/app/19c/grid/crs/install
root@cbspr:/d01/app/19c/grid/crs/install#
root@cbspr:/d01/app/19c/grid/crs/install#
root@cbspr:/d01/app/19c/grid/crs/install# ./rootcrs.sh -prepatch
Using configuration parameter file: /d01/app/19c/grid/crs/install/crsconfig_params
The log of current session can be found at:
/d01/app/grid/crsdata/cbspr/crsconfig/crs_prepatch_cbspr_2023-05-28_02-41-09PM.log
2023/05/28 14:42:28 CLSRSC-4012: Shutting down Oracle Trace File Analyzer (TFA) Collector.
2023/05/28 14:43:15 CLSRSC-4013: Successfully shut down Oracle Trace File Analyzer (TFA) Collector.
2023/05/28 14:43:20 CLSRSC-347: Successfully unlock /d01/app/19c/grid
2023/05/28 14:43:24 CLSRSC-671: Pre-patch steps for patching GI home successfully completed.
root@cbspr:/d01/app/19c/grid/crs/install#
/d01/app/19c/grid/bin
root@cbspr:/d01/app/19c/grid/bin#
root@cbspr:/d01/app/19c/grid/bin# ./crsctl stop has
CRS-4639: Could not contact Oracle High Availability Services
CRS-4000: Command Stop failed, or completed with errors.
root@cbspr:/d01/app/19c/grid/bin#
/d01/app/19c/grid/OPatch/opatch apply -oh /d01/app/19c/grid -local /d01/soft/gpatch/33509923/33515361
grid@cbspr:~$ /d01/app/19c/grid/OPatch/opatch apply -oh /d01/app/19c/grid -local /d01/soft/gpatch/33509923/33515361
Oracle Interim Patch Installer version 12.2.0.1.28
Copyright (c) 2023, Oracle Corporation. All rights reserved.
Oracle Home : /d01/app/19c/grid
Central Inventory : /d01/app/oraInventory
from : /d01/app/19c/grid/oraInst.loc
OPatch version : 12.2.0.1.28
OUI version : 12.2.0.7.0
Log file location : /d01/app/19c/grid/cfgtoollogs/opatch/opatch2023-05-28_14-47-53PM_1.log
Verifying environment and performing prerequisite checks...
--------------------------------------------------------------------------------
Start OOP by Prereq process.
Launch OOP...
Oracle Interim Patch Installer version 12.2.0.1.28
Copyright (c) 2023, Oracle Corporation. All rights reserved.
Oracle Home : /d01/app/19c/grid
Central Inventory : /d01/app/oraInventory
from : /d01/app/19c/grid/oraInst.loc
OPatch version : 12.2.0.1.28
OUI version : 12.2.0.7.0
Log file location : /d01/app/19c/grid/cfgtoollogs/opatch/opatch2023-05-28_14-48-17PM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 33515361
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 = '/d01/app/19c/grid')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '33515361' to OH '/d01/app/19c/grid'
ApplySession: Optional component(s) [ oracle.ctx, 19.0.0.0.0 ] , [ oracle.marvel, 19.0.0.0.0 ] , [ oracle.network.gsm, 19.0.0.0.0 ] , [ oracle.odbc.ic, 19.0.0.0.0 ] , [ oracle.precomp.common.core, 19.0.0.0.0 ] , [ oracle.rdbms.ic, 19.0.0.0.0 ] , [ oracle.rdbms.oci, 19.0.0.0.0 ] , [ oracle.rdbms.tg4db2, 19.0.0.0.0 ] , [ oracle.sdo, 19.0.0.0.0 ] , [ oracle.rdbms.drdaas, 19.0.0.0.0 ] , [ oracle.options.olap.api, 19.0.0.0.0 ] , [ oracle.xdk.xquery, 19.0.0.0.0 ] , [ oracle.rdbms.hsodbc, 19.0.0.0.0 ] , [ oracle.ons.cclient, 19.0.0.0.0 ] , [ oracle.network.cman, 19.0.0.0.0 ] , [ oracle.odbc, 19.0.0.0.0 ] , [ oracle.rdbms.tg4sybs, 19.0.0.0.0 ] , [ oracle.rdbms.lbac, 19.0.0.0.0 ] , [ oracle.rdbms.tg4msql, 19.0.0.0.0 ] , [ oracle.oraolap.api, 19.0.0.0.0 ] , [ oracle.rdbms.dv, 19.0.0.0.0 ] , [ oracle.rdbms.tg4ifmx, 19.0.0.0.0 ] , [ oracle.oid.client, 19.0.0.0.0 ] , [ oracle.rdbms.tg4tera, 19.0.0.0.0 ] , [ oracle.ctx.atg, 19.0.0.0.0 ] , [ oracle.net.cman, 19.0.0.0.0 ] , [ oracle.dbdev, 19.0.0.0.0 ] , [ oracle.mgw.common, 19.0.0.0.0 ] , [ oracle.oraolap, 19.0.0.0.0 ] , [ oracle.xdk, 19.0.0.0.0 ] , [ oracle.rdbms.scheduler, 19.0.0.0.0 ] , [ oracle.xdk.companion, 19.0.0.0.0 ] , [ oracle.rdbms.hs_common, 19.0.0.0.0 ] , [ oracle.ons.eons.bwcompat, 19.0.0.0.0 ] , [ oracle.options.olap, 19.0.0.0.0 ] , [ oracle.precomp.common, 19.0.0.0.0 ] , [ oracle.precomp.lang, 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.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.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.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.oracore.rsf, 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.rhp.db, 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.rsf, 19.0.0.0.0...
Patching component oracle.sqlplus.ic, 19.0.0.0.0...
Patching component oracle.tfa, 19.0.0.0.0...
Patching component oracle.wwg.plsql, 19.0.0.0.0...
Patching component oracle.rdbms.crs, 19.0.0.0.0...
Patching component oracle.network.client, 19.0.0.0.0...
Patching component oracle.javavm.server, 19.0.0.0.0...
Patching component oracle.rdbms.rman, 19.0.0.0.0...
Patching component oracle.xdk.rsf, 19.0.0.0.0...
Patching component oracle.precomp.rsf, 19.0.0.0.0...
Patching component oracle.ldap.ssl, 19.0.0.0.0...
Patching component oracle.ons, 19.0.0.0.0...
Patching component oracle.ovm, 19.0.0.0.0...
Patching component oracle.ldap.client, 19.0.0.0.0...
Patching component oracle.ons.ic, 19.0.0.0.0...
Patching component oracle.oraolap.dbscripts, 19.0.0.0.0...
Patching component oracle.ctx.rsf, 19.0.0.0.0...
Patching component oracle.sdo.locator, 19.0.0.0.0...
Patching component oracle.rdbms.install.common, 19.0.0.0.0...
Patching component oracle.rdbms.install.plugins, 19.0.0.0.0...
Patching component oracle.xdk.parser.java, 19.0.0.0.0...
Patching component oracle.dbtoolslistener, 19.0.0.0.0...
Patching component oracle.ldap.rsf.ic, 19.0.0.0.0...
Patching component oracle.network.listener, 19.0.0.0.0...
Patching component oracle.nlsrtl.rsf, 19.0.0.0.0...
Patching component oracle.rdbms.rsf.ic, 19.0.0.0.0...
Patching component oracle.jdk, 1.8.0.201.0...
Patch 33515361 successfully applied.
Sub-set patch [29517242] has become inactive due to the application of a super-set patch [33515361].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /d01/app/19c/grid/cfgtoollogs/opatch/opatch2023-05-28_14-48-17PM_1.log
OPatch succeeded.
grid@cbspr:~$
/d01/app/19c/grid/OPatch/opatch apply -oh /d01/app/19c/grid -local /d01/soft/gpatch/33509923/33529556
grid@cbspr:~$ /d01/app/19c/grid/OPatch/opatch apply -oh /d01/app/19c/grid -local /d01/soft/gpatch/33509923/33529556
Oracle Interim Patch Installer version 12.2.0.1.28
Copyright (c) 2023, Oracle Corporation. All rights reserved.
Oracle Home : /d01/app/19c/grid
Central Inventory : /d01/app/oraInventory
from : /d01/app/19c/grid/oraInst.loc
OPatch version : 12.2.0.1.28
OUI version : 12.2.0.7.0
Log file location : /d01/app/19c/grid/cfgtoollogs/opatch/opatch2023-05-28_14-54-08PM_1.log
Verifying environment and performing prerequisite checks...
--------------------------------------------------------------------------------
Start OOP by Prereq process.
Launch OOP...
Oracle Interim Patch Installer version 12.2.0.1.28
Copyright (c) 2023, Oracle Corporation. All rights reserved.
Oracle Home : /d01/app/19c/grid
Central Inventory : /d01/app/oraInventory
from : /d01/app/19c/grid/oraInst.loc
OPatch version : 12.2.0.1.28
OUI version : 12.2.0.7.0
Log file location : /d01/app/19c/grid/cfgtoollogs/opatch/opatch2023-05-28_14-54-32PM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 33529556
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 = '/d01/app/19c/grid')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '33529556' to OH '/d01/app/19c/grid'
ApplySession: Optional component(s) [ oracle.has.db.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.rhp.db, 19.0.0.0.0...
Patching component oracle.has.common, 19.0.0.0.0...
Patching component oracle.has.rsf, 19.0.0.0.0...
Patching component oracle.has.crs, 19.0.0.0.0...
Patching component oracle.xag, 19.0.0.0.0...
Patching component oracle.has.crs.cvu, 19.0.0.0.0...
Patching component oracle.has.cvu, 19.0.0.0.0...
Patching component oracle.has.db, 19.0.0.0.0...
Patching component oracle.rhp.common, 19.0.0.0.0...
Patching component oracle.rhp.crs, 19.0.0.0.0...
Patching component oracle.has.common.cvu, 19.0.0.0.0...
Patch 33529556 successfully applied.
Sub-set patch [29585399] has become inactive due to the application of a super-set patch [33529556].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /d01/app/19c/grid/cfgtoollogs/opatch/opatch2023-05-28_14-54-32PM_1.log
OPatch succeeded.
grid@cbspr:~$
/d01/app/19c/grid/OPatch/opatch apply -oh /d01/app/19c/grid -local /d01/soft/gpatch/33509923/33534448
grid@cbspr:~$ /d01/app/19c/grid/OPatch/opatch apply -oh /d01/app/19c/grid -local /d01/soft/gpatch/33509923/33534448
Oracle Interim Patch Installer version 12.2.0.1.28
Copyright (c) 2023, Oracle Corporation. All rights reserved.
Oracle Home : /d01/app/19c/grid
Central Inventory : /d01/app/oraInventory
from : /d01/app/19c/grid/oraInst.loc
OPatch version : 12.2.0.1.28
OUI version : 12.2.0.7.0
Log file location : /d01/app/19c/grid/cfgtoollogs/opatch/opatch2023-05-28_14-58-26PM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 33534448
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 = '/d01/app/19c/grid')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '33534448' to OH '/d01/app/19c/grid'
Patching component oracle.usm, 19.0.0.0.0...
Patch 33534448 successfully applied.
Sub-set patch [29517247] has become inactive due to the application of a super-set patch [33534448].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /d01/app/19c/grid/cfgtoollogs/opatch/opatch2023-05-28_14-58-26PM_1.log
OPatch succeeded.
grid@cbspr:~$
/d01/app/19c/grid/OPatch/opatch apply -oh /d01/app/19c/grid -local /d01/soft/gpatch/33509923/33239955
grid@cbspr:~$ /d01/app/19c/grid/OPatch/opatch apply -oh /d01/app/19c/grid -local /d01/soft/gpatch/33509923/33239955
Oracle Interim Patch Installer version 12.2.0.1.28
Copyright (c) 2023, Oracle Corporation. All rights reserved.
Oracle Home : /d01/app/19c/grid
Central Inventory : /d01/app/oraInventory
from : /d01/app/19c/grid/oraInst.loc
OPatch version : 12.2.0.1.28
OUI version : 12.2.0.7.0
Log file location : /d01/app/19c/grid/cfgtoollogs/opatch/opatch2023-05-28_14-59-37PM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 33239955
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 = '/d01/app/19c/grid')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '33239955' to OH '/d01/app/19c/grid'
Patching component oracle.tomcat.crs, 19.0.0.0.0...
Patch 33239955 successfully applied.
Sub-set patch [29401763] has become inactive due to the application of a super-set patch [33239955].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /d01/app/19c/grid/cfgtoollogs/opatch/opatch2023-05-28_14-59-37PM_1.log
OPatch succeeded.
/d01/app/19c/grid/OPatch/opatch apply -oh /d01/app/19c/grid -local /d01/soft/gpatch/33509923/33575402
grid@cbspr:~$ /d01/app/19c/grid/OPatch/opatch apply -oh /d01/app/19c/grid -local /d01/soft/gpatch/33509923/33575402
Oracle Interim Patch Installer version 12.2.0.1.28
Copyright (c) 2023, Oracle Corporation. All rights reserved.
Oracle Home : /d01/app/19c/grid
Central Inventory : /d01/app/oraInventory
from : /d01/app/19c/grid/oraInst.loc
OPatch version : 12.2.0.1.28
OUI version : 12.2.0.7.0
Log file location : /d01/app/19c/grid/cfgtoollogs/opatch/opatch2023-05-28_15-00-31PM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 33575402
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 = '/d01/app/19c/grid')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '33575402' to OH '/d01/app/19c/grid'
Patching component oracle.wlm.dbwlm, 19.0.0.0.0...
Patch 33575402 successfully applied.
Log file location: /d01/app/19c/grid/cfgtoollogs/opatch/opatch2023-05-28_15-00-31PM_1.log
OPatch succeeded.
grid@cbspr:~$
root@cbspr:~#
root@cbspr:~# /d01/app/19c/grid/rdbms/install/rootadd_rdbms.sh
root@cbspr:~#
root@cbspr:~#
root@cbspr:~# /d01/app/19c/grid/crs/install/rootcrs.sh -postpatch
Using configuration parameter file: /d01/app/19c/grid/crs/install/crsconfig_params
The log of current session can be found at:
/d01/app/grid/crsdata/cbspr/crsconfig/crs_postpatch_apply_inplace_cbspr_2023-05-28_03-02-55PM.log
2023/05/28 15:03:12 CLSRSC-329: Replacing Clusterware entries in file '/etc/inittab'
Oracle Clusterware active version on the cluster is [19.0.0.0.0]. The cluster upgrade state is [NORMAL]. The cluster active patch level is [2965637783].
SQL Patching tool version 19.14.0.0.0 Production on Sun May 28 15:06:37 2023
Copyright (c) 2012, 2021, Oracle. All rights reserved.
Log file for this invocation: /d01/app/grid/cfgtoollogs/sqlpatch/sqlpatch_48269_2023_05_28_15_06_37/sqlpatch_invocation.log
Connecting to database...OK
Gathering database info...done
Note: Datapatch will only apply or rollback SQL fixes for PDBs
that are in an open state, no patches will be applied to closed PDBs.
Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation
(Doc ID 1585822.1)
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.14.0.0.0 Release_Update 211229021203: Installed
PDB CDB$ROOT:
Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 28-MAY-23 12.54.05.778045 PM
PDB GIMR_DSCREP_10:
Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 28-MAY-23 01.03.25.354752 PM
PDB PDB$SEED:
Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 28-MAY-23 01.03.25.354752 PM
Adding patches to installation queue and performing prereq checks...done
Installation queue:
For the following PDBs: CDB$ROOT PDB$SEED GIMR_DSCREP_10
No interim patches need to be rolled back
Patch 33515361 (Database Release Update : 19.14.0.0.220118 (33515361)):
Apply from 19.3.0.0.0 Release_Update 190410122720 to 19.14.0.0.0 Release_Update 211229021203
No interim patches need to be applied
Installing patches...
Patch installation complete. Total patches installed: 3
Validating logfiles...done
Patch 33515361 apply (pdb CDB$ROOT): SUCCESS
logfile: /d01/app/grid/cfgtoollogs/sqlpatch/33515361/24574896/33515361_apply__MGMTDB_CDBROOT_2023May28_15_07_29.log (no errors)
Patch 33515361 apply (pdb PDB$SEED): SUCCESS
logfile: /d01/app/grid/cfgtoollogs/sqlpatch/33515361/24574896/33515361_apply__MGMTDB_PDBSEED_2023May28_15_12_14.log (no errors)
Patch 33515361 apply (pdb GIMR_DSCREP_10): SUCCESS
logfile: /d01/app/grid/cfgtoollogs/sqlpatch/33515361/24574896/33515361_apply__MGMTDB_GIMR_DSCREP_10_2023May28_15_12_14.log (no errors)
Automatic recompilation incomplete; run utlrp.sql to revalidate.
PDBs: GIMR_DSCREP_10 PDB$SEED
SQL Patching tool complete on Sun May 28 15:23:20 2023
2023/05/28 15:24:46 CLSRSC-4015: Performing install or upgrade action for Oracle Trace File Analyzer (TFA) Collector.
2023/05/28 15:24:48 CLSRSC-672: Post-patch steps for patching GI home successfully completed.
root@cbspr:~# 2023/05/28 15:26:47 CLSRSC-4003: Successfully patched Oracle Trace File Analyzer (TFA) Collector.
root@cbspr:~#
root@cbspr:~#
root@cbspr:~# /d01/app/19c/grid/bin/crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE cbspr STABLE
ora.MGMT.GHCHKPT.advm
OFFLINE OFFLINE cbspr STABLE
ora.helper
OFFLINE OFFLINE cbspr IDLE,STABLE
ora.mgmt.ghchkpt.acfs
OFFLINE OFFLINE cbspr STABLE
ora.net1.network
ONLINE ONLINE cbspr STABLE
ora.ons
ONLINE ONLINE cbspr STABLE
ora.proxy_advm
ONLINE ONLINE cbspr STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
1 ONLINE ONLINE cbspr STABLE
2 ONLINE OFFLINE STABLE
3 ONLINE OFFLINE STABLE
ora.CDATA.dg(ora.asmgroup)
1 ONLINE ONLINE cbspr STABLE
2 OFFLINE OFFLINE STABLE
3 OFFLINE OFFLINE STABLE
ora.FRA.dg(ora.asmgroup)
1 ONLINE ONLINE cbspr STABLE
2 OFFLINE OFFLINE STABLE
3 OFFLINE OFFLINE STABLE
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE cbspr STABLE
ora.MGMT.dg(ora.asmgroup)
1 ONLINE ONLINE cbspr STABLE
2 OFFLINE OFFLINE STABLE
3 OFFLINE OFFLINE STABLE
ora.MGMTLSNR
1 ONLINE ONLINE cbspr 169.254.30.116 10.64
.130.42,STABLE
ora.OCRVOTE.dg(ora.asmgroup)
1 ONLINE ONLINE cbspr STABLE
2 OFFLINE OFFLINE STABLE
3 OFFLINE OFFLINE STABLE
ora.REDO1.dg(ora.asmgroup)
1 ONLINE ONLINE cbspr STABLE
2 OFFLINE OFFLINE STABLE
3 OFFLINE OFFLINE STABLE
ora.REDO2.dg(ora.asmgroup)
1 ONLINE ONLINE cbspr STABLE
2 OFFLINE OFFLINE STABLE
3 OFFLINE OFFLINE STABLE
ora.REDO3.dg(ora.asmgroup)
1 ONLINE ONLINE cbspr STABLE
2 OFFLINE OFFLINE STABLE
3 OFFLINE OFFLINE STABLE
ora.asm(ora.asmgroup)
1 ONLINE ONLINE cbspr Started,STABLE
2 OFFLINE OFFLINE STABLE
3 OFFLINE OFFLINE STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
1 ONLINE ONLINE cbspr STABLE
2 OFFLINE OFFLINE STABLE
3 OFFLINE OFFLINE STABLE
ora.cbspr.vip
1 ONLINE ONLINE cbspr STABLE
ora.cvu
1 ONLINE ONLINE cbspr STABLE
ora.mgmtdb
1 ONLINE ONLINE cbspr Open,STABLE
ora.qosmserver
1 ONLINE ONLINE cbspr STABLE
ora.rhpserver
1 OFFLINE OFFLINE STABLE
ora.scan1.vip
1 ONLINE ONLINE cbspr STABLE
--------------------------------------------------------------------------------
root@cbspr:~#
root@cbspr:~#
grid@cbspr:~$ cd $ORACLE_HOME/OPatch
grid@cbspr:/d01/app/19c/grid/OPatch$
grid@cbspr:/d01/app/19c/grid/OPatch$ ./opatch lspatches
33575402;DBWLM RELEASE UPDATE 19.0.0.0.0 (33575402)
33239955;TOMCAT RELEASE UPDATE 19.0.0.0.0 (33239955)
33534448;ACFS RELEASE UPDATE 19.14.0.0.0 (33534448)
33529556;OCW RELEASE UPDATE 19.14.0.0.0 (33529556)
33515361;Database Release Update : 19.14.0.0.220118 (33515361)
OPatch succeeded.
grid@cbspr:/d01/app/19c/grid/OPatch$
-=== in case of error ==
root@badbdr-test:~# /d01/app/19c/grid/bin/crsctl start has
CRS-6706: Oracle Clusterware Release patch level ('2965637783') does not match Software patch level ('2676783881'). Oracle Clusterware cannot be started.
CRS-4000: Command Start failed, or completed with errors.
root@badbdr-test:~# /d01/app/19c/grid/crs/install/roothas.sh -unlock
Using configuration parameter file: /d01/app/19c/grid/crs/install/crsconfig_params
The log of current session can be found at:
/d01/app/grid/crsdata/badbdr-test/crsconfig/haunlock__2022-12-12_11-23-59PM.log
2022/12/12 23:24:11 CLSRSC-347: Successfully unlock /d01/app/19c/grid
root@badbdr-test:~# /d01/app/19c/grid/bin/clscfg -localpatch
clscfg: EXISTING configuration version 0 detected.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
root@badbdr-test:~# /d01/app/19c/grid/crs/install/roothas.sh -lock
Using configuration parameter file: /d01/app/19c/grid/crs/install/crsconfig_params
The log of current session can be found at:
/d01/app/grid/crsdata/badbdr-test/crsconfig/halock__2022-12-12_11-27-23PM.log
2022/12/12 23:27:26 CLSRSC-329: Replacing Clusterware entries in file '/etc/inittab'
root@badbdr-test:~# /d01/app/19c/grid/bin/crsctl start has
CRS-4123: Oracle High Availability Services has been started.
root@badbdr-test:~#
--=== oracle patching ===
root@cbspr:/d01/app/oracle/product/19c/db_1# mv OPatch OPatch_28may23
root@cbspr:/d01/app/oracle/product/19c/db_1#
-bash-5.1$ scp -r OPatch root@10.11.1.131:/d01/app/oracle/product/19c/db_1/
Password:
oot@cbspr:/d01/app/oracle/product/19c/db_1# chown -R oracle:oinstall OPatch
root@cbspr:/d01/app/oracle/product/19c/db_1# chmod -R 775 OPatch
root@cbspr:/d01/app/oracle/product/19c/db_1#
root@cbspr:/d01/app/oracle/product/19c/db_1# cd OPatch
root@cbspr:/d01/app/oracle/product/19c/db_1/OPatch# ls -ld
drwxrwxr-x 15 oracle oinstall 29 May 28 15:43 .
root@cbspr:/d01/app/oracle/product/19c/db_1/OPatch#
/d01/app/oracle/product/19c/db_1/OPatch
unzip p6880880_210000_SOLARIS64.zip in Oracle home [/d01/app/oracle/product/19c/db_1]
--- create database through DBCA
-- then connect ==
oracle@cbspr:~$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Sun May 28 17:58:50 2023
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>
SQL>
SQL> conn c##cbsowner/Ba#2021#Core#131
Connected.
SQL>
SQL> grant DV_PATCH_ADMIN to sys container=all;
Grant succeeded.
SQL>
oracle@cbspr:~$
oracle@cbspr:~$ /d01/app/oracle/product/19c/db_1/OPatch/opatch version
OPatch Version: 12.2.0.1.28
OPatch succeeded.
oracle@cbspr:~$
oracle@cbspr:~$
oracle@cbspr:~$ srvctl stop scan_listener
oracle@cbspr:~$
oracle@cbspr:~$ srvctl stop listener
oracle@cbspr:~$
oracle@cbspr:~$ srvctl stop database -d cbsdb
oracle@cbspr:~$
oracle@cbspr:~$ cd /d01/soft/gpatch/
oracle@cbspr:/d01/soft/gpatch$ ls
33509923 p33509923_190000_SOLARIS64.zip PatchSearch.xml
oracle@cbspr:/d01/soft/gpatch$
oracle@cbspr:/d01/soft/gpatch$ cd 33509923/
oracle@cbspr:/d01/soft/gpatch/33509923$ ls
33239955 33515361 33529556 33534448 33575402 automation bundle.xml README.html README.txt
oracle@cbspr:/d01/soft/gpatch/33509923$ cd 33515361
oracle@cbspr:/d01/soft/gpatch/33509923/33515361$
oracle@cbspr:/d01/soft/gpatch/33509923/33515361$ pwd
/d01/soft/gpatch/33509923/33515361
oracle@cbspr:/d01/soft/gpatch/33509923/33515361$
oracle@cbspr:/d01/soft/gpatch/33509923/33515361$
oracle@cbspr:~$ cd /d01/soft/gpatch/
oracle@cbspr:/d01/soft/gpatch$ ls
33509923 p33509923_190000_SOLARIS64.zip PatchSearch.xml
oracle@cbspr:/d01/soft/gpatch$
oracle@cbspr:/d01/soft/gpatch$ cd 33509923/
oracle@cbspr:/d01/soft/gpatch/33509923$ ls
33239955 33515361 33529556 33534448 33575402 automation bundle.xml README.html README.txt
oracle@cbspr:/d01/soft/gpatch/33509923$ cd 33515361
oracle@cbspr:/d01/soft/gpatch/33509923/33515361$
oracle@cbspr:/d01/soft/gpatch/33509923/33515361$ pwd
/d01/soft/gpatch/33509923/33515361
oracle@cbspr:/d01/soft/gpatch/33509923/33515361$
oracle@cbspr:/d01/soft/gpatch/33509923/33515361$ pwd
/d01/soft/gpatch/33509923/33515361
oracle@cbspr:/d01/soft/gpatch/33509923/33515361$
oracle@cbspr:/d01/soft/gpatch/33509923/33515361$ cd
oracle@cbspr:~$
oracle@cbspr:~$ cd $ORACLE_HOME/OPatch
oracle@cbspr:/d01/app/oracle/product/19c/db_1/OPatch$ pwd
/d01/app/oracle/product/19c/db_1/OPatch
oracle@cbspr:/d01/app/oracle/product/19c/db_1/OPatch$
oracle@cbspr:/d01/app/oracle/product/19c/db_1/OPatch$ cd /d01/soft/gpatch/33509923/33515361
oracle@cbspr:/d01/soft/gpatch/33509923/33515361$
oracle@cbspr:/d01/soft/gpatch/33509923/33515361$ /d01/app/oracle/product/19c/db_1/OPatch/opatch apply
Oracle Interim Patch Installer version 12.2.0.1.28
Copyright (c) 2023, Oracle Corporation. All rights reserved.
Oracle Home : /d01/app/oracle/product/19c/db_1
Central Inventory : /d01/app/oraInventory
from : /d01/app/oracle/product/19c/db_1/oraInst.loc
OPatch version : 12.2.0.1.28
OUI version : 12.2.0.7.0
Log file location : /d01/app/oracle/product/19c/db_1/cfgtoollogs/opatch/opatch2023-05-28_18-06-31PM_1.log
Verifying environment and performing prerequisite checks...
--------------------------------------------------------------------------------
Start OOP by Prereq process.
Launch OOP...
Oracle Interim Patch Installer version 12.2.0.1.28
Copyright (c) 2023, Oracle Corporation. All rights reserved.
Oracle Home : /d01/app/oracle/product/19c/db_1
Central Inventory : /d01/app/oraInventory
from : /d01/app/oracle/product/19c/db_1/oraInst.loc
OPatch version : 12.2.0.1.28
OUI version : 12.2.0.7.0
Log file location : /d01/app/oracle/product/19c/db_1/cfgtoollogs/opatch/opatch2023-05-28_18-07-00PM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 33515361
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 = '/d01/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 '33515361' to OH '/d01/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.network.cman, 19.0.0.0.0 ] , [ oracle.rdbms.tg4sybs, 19.0.0.0.0 ] , [ oracle.rdbms.tg4msql, 19.0.0.0.0 ] , [ oracle.rdbms.tg4ifmx, 19.0.0.0.0 ] , [ oracle.oid.client, 19.0.0.0.0 ] , [ oracle.rdbms.tg4tera, 19.0.0.0.0 ] , [ oracle.net.cman, 19.0.0.0.0 ] , [ oracle.xdk.companion, 19.0.0.0.0 ] , [ oracle.ons.eons.bwcompat, 19.0.0.0.0 ] , [ oracle.options.olap, 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.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.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.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.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.rsf, 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.rdbms.crs, 19.0.0.0.0...
Patching component oracle.rdbms.drdaas, 19.0.0.0.0...
Patching component oracle.xdk.xquery, 19.0.0.0.0...
Patching component oracle.network.client, 19.0.0.0.0...
Patching component oracle.javavm.server, 19.0.0.0.0...
Patching component oracle.rdbms.rman, 19.0.0.0.0...
Patching component oracle.xdk.rsf, 19.0.0.0.0...
Patching component oracle.rdbms.hsodbc, 19.0.0.0.0...
Patching component oracle.odbc, 19.0.0.0.0...
Patching component oracle.precomp.rsf, 19.0.0.0.0...
Patching component oracle.rdbms.lbac, 19.0.0.0.0...
Patching component oracle.oraolap.api, 19.0.0.0.0...
Patching component oracle.rdbms.dv, 19.0.0.0.0...
Patching component oracle.ldap.ssl, 19.0.0.0.0...
Patching component oracle.ons, 19.0.0.0.0...
Patching component oracle.ovm, 19.0.0.0.0...
Patching component oracle.ctx.atg, 19.0.0.0.0...
Patching component oracle.dbdev, 19.0.0.0.0...
Patching component oracle.mgw.common, 19.0.0.0.0...
Patching component oracle.ldap.client, 19.0.0.0.0...
Patching component oracle.ons.ic, 19.0.0.0.0...
Patching component oracle.oraolap, 19.0.0.0.0...
Patching component oracle.oraolap.dbscripts, 19.0.0.0.0...
Patching component oracle.ctx.rsf, 19.0.0.0.0...
Patching component oracle.sdo.locator, 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.rdbms.install.plugins, 19.0.0.0.0...
Patching component oracle.xdk.parser.java, 19.0.0.0.0...
Patching component oracle.rdbms.scheduler, 19.0.0.0.0...
Patching component oracle.rdbms.hs_common, 19.0.0.0.0...
Patching component oracle.dbtoolslistener, 19.0.0.0.0...
Patching component oracle.ldap.rsf.ic, 19.0.0.0.0...
Patching component oracle.network.listener, 19.0.0.0.0...
Patching component oracle.nlsrtl.rsf, 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 33515361 successfully applied.
Sub-set patch [29517242] has become inactive due to the application of a super-set patch [33515361].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /d01/app/oracle/product/19c/db_1/cfgtoollogs/opatch/opatch2023-05-28_18-07-00PM_1.log
OPatch succeeded.
oracle@cbspr:/d01/soft/gpatch/33509923/33515361$
oracle@cbspr:~$ /d01/app/oracle/product/19c/db_1/OPatch
-bash: /d01/app/oracle/product/19c/db_1/OPatch: Is a directory
oracle@cbspr:~$
oracle@cbspr:~$ cd /d01/app/oracle/product/19c/db_1/OPatch
oracle@cbspr:/d01/app/oracle/product/19c/db_1/OPatch$
oracle@cbspr:/d01/app/oracle/product/19c/db_1/OPatch$ ./datapatch -verbose
SQL Patching tool version 19.14.0.0.0 Production on Mon May 29 10:11:54 2023
Copyright (c) 2012, 2021, Oracle. All rights reserved.
Log file for this invocation: /d01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_21728_2023_05_29_10_11_54/sqlpatch_invocation.log
Connecting to database...OK
Gathering database info...done
Note: Datapatch will only apply or rollback SQL fixes for PDBs
that are in an open state, no patches will be applied to closed PDBs.
Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation
(Doc ID 1585822.1)
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.14.0.0.0 Release_Update 211229021203: Installed
PDB CDB$ROOT:
Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 28-MAY-23 05.29.47.087320 PM
PDB PDB$SEED:
Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 28-MAY-23 05.40.31.105263 PM
PDB STLBAS:
Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 28-MAY-23 05.40.31.105263 PM
Adding patches to installation queue and performing prereq checks...done
Installation queue:
For the following PDBs: CDB$ROOT PDB$SEED STLBAS
No interim patches need to be rolled back
Patch 33515361 (Database Release Update : 19.14.0.0.220118 (33515361)):
Apply from 19.3.0.0.0 Release_Update 190410122720 to 19.14.0.0.0 Release_Update 211229021203
No interim patches need to be applied
Installing patches...
Patch installation complete. Total patches installed: 3
Validating logfiles...done
Patch 33515361 apply (pdb CDB$ROOT): SUCCESS
logfile: /d01/app/oracle/cfgtoollogs/sqlpatch/33515361/24574896/33515361_apply_CBSDB_CDBROOT_2023May29_10_12_49.log (no errors)
Patch 33515361 apply (pdb PDB$SEED): SUCCESS
logfile: /d01/app/oracle/cfgtoollogs/sqlpatch/33515361/24574896/33515361_apply_CBSDB_PDBSEED_2023May29_10_20_05.log (no errors)
Patch 33515361 apply (pdb STLBAS): SUCCESS
logfile: /d01/app/oracle/cfgtoollogs/sqlpatch/33515361/24574896/33515361_apply_CBSDB_STLBAS_2023May29_10_20_05.log (no errors)
Automatic recompilation incomplete; run utlrp.sql to revalidate.
PDBs: PDB$SEED STLBAS
SQL Patching tool complete on Mon May 29 10:26:28 2023
oracle@cbspr:/d01/app/oracle/product/19c/db_1/OPatch$
