ORACLE 19c DATABASE PSU PATCH & ROLLBACK
Oracle regularly makes patches available to upgrade features, enhance security, or fix problems with supported software. The major types of patches are: ... Security Patch Updates (SPU) - a cumulative collection of security bug fixes. SPUs were formerly known as Critical Patch Updates (CPU).
Step 1- Download the latest patch
·
Search PSU latest patch and download
it from oracle support you are using 19c please select 12.2 & higher
·
Mention the version 19.0.0
·
Select latest release patch in this demo
we are using OCT – 2021 (19.13.0.0)
·
If you are using Linux environment
make sure the version and os to be downloaded. Verify the downloaded patch
file.
·
Open the README file for check suitable
Opatch version
·
In the README file in that it will
mentioned OPATCH version to be suitable for the patching.
·
Download the OPatch mention the version
release and suitable environment
·
move the opatch latest version file in
ORACLE_HOME location
Step 2- check Opatch utility
·
Opatch utility available in
ORACLE_HOME/OPatch location make sure about the patch version
[oracle@vignesh OPatch]$ opatch
version
OPatch Version: 12.2.0.1.17
OPatch succeeded.
[oracle@vignesh OPatch]$
·
Verify the version in README file if
not suitable move that OPatch folder in backup location.
·
After that unzip the latest opatch
utility in ORACLE_HOME location.
·
Once extraction will complete it will
create OPatch folder automatically.
[oracle@vignesh OPatch]$ opatch
version
OPatch Version: 12.2.0.1.27
OPatch succeeded.
[oracle@vignesh OPatch]$
·
Now the latest utility can be updated.
·
Step 3- PSU patch prechecks
·
Move the downloaded file in oracle
server if any location the space available
·
Unzip the patch file in location
after that it will created folder by using that patch ID number
[oracle@vignesh ~]$ cd /u01/Patch/
[oracle@vignesh Patch]$ ls
p33192793_190000_Linux-x86-64
[oracle@vignesh Patch]$ unzip p33192793_190000_Linux-x86-64
[oracle@vignesh Patch]$ ls
33192793 PatchSearch.xml
[oracle@vignesh Patch]$ cd
33192793
[oracle@vignesh 33192793]$ ls
custom etc
files README.html README.txt
[oracle@vignesh 33192793]$
Step 4- Export Path
·
If we export the path mention the
location we can access the OPatch utility in all over the database so that we
used the path.
export
ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1
export PATH=$ORACLE_HOME/OPatch:$PATH
Step 5- shutdown database and listener
Step 6- RU patch apply
ERROR---*******---- if you are facing error execute the
fuser and error process it shows as id please kill the process and do patching.
[oracle@vignesh 33192793]$ opatch apply
Oracle Interim Patch Installer
version 12.2.0.1.27
Copyright (c) 2021, Oracle
Corporation. All rights reserved.
Oracle Home :
/u01/app/oracle/product/19.0.0/dbhome_1
Central Inventory :
/u01/app/oraInventory
from :
/u01/app/oracle/product/19.0.0/dbhome_1/oraInst.loc
OPatch version : 12.2.0.1.27
OUI version : 12.2.0.7.0
Log file location :
/u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2021-11-12_09-52-42AM_1.log
Verifying environment and performing
prerequisite checks...
Prerequisite check
"CheckActiveFilesAndExecutables" failed.
The details are:
Following active executables are not
used by opatch process :
/u01/app/oracle/product/19.0.0/dbhome_1/bin/oracle
Following active executables are used
by opatch process :
UtilSession failed: Prerequisite
check "CheckActiveFilesAndExecutables" failed.
Log file location:
/u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2021-11-12_09-52-42AM_1.log
OPatch failed with error code 73
[oracle@vignesh 33192793]$ fuser
/u01/app/oracle/product/19.0.0/dbhome_1/bin/oracle
/u01/app/oracle/product/19.0.0/dbhome_1/bin/oracle: 717e
719e 721e 723e
727e 729e 733e
736e 738e 741e
743e 745e 747e
750e 752e 754e
756e 758e 760e
762e 764e 766e
768e 770e 774e
776e 780e 782e
791e 798e 800e
802e 804e 806e
808e 810e 812e
816e 821e 823e
829e 833e 835e
1014e 1018e 1020e
1025e 1029e 1522e
1961e 2243e 2587e
3634e 4318e
[oracle@vignesh 33192793]$ kill -9
717 733 1961
[oracle@vignesh 33192793]$ opatch
apply
Oracle Interim Patch Installer
version 12.2.0.1.27
Copyright (c) 2021, Oracle
Corporation. All rights reserved.
Oracle Home :
/u01/app/oracle/product/19.0.0/dbhome_1
Central Inventory :
/u01/app/oraInventory
from :
/u01/app/oracle/product/19.0.0/dbhome_1/oraInst.loc
OPatch version : 12.2.0.1.27
OUI version : 12.2.0.7.0
Log file location :
/u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2021-11-12_09-54-32AM_1.log
Verifying environment and performing
prerequisite checks...
OPatch continues with these
patches: 33192793
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/19.0.0/dbhome_1')
Is the local system ready for
patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '33192793' to
OH '/u01/app/oracle/product/19.0.0/dbhome_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.ons.eons.bwcompat, 19.0.0.0.0 ] , [ oracle.oid.client, 19.0.0.0.0 ] , [
oracle.rdbms.tg4ifmx, 19.0.0.0.0 ] , [ oracle.options.olap.api, 19.0.0.0.0 ] ,
[ oracle.net.cman, 19.0.0.0.0 ] , [ oracle.options.olap, 19.0.0.0.0 ] , [
oracle.rdbms.tg4sybs, 19.0.0.0.0 ] , [ oracle.rdbms.tg4tera, 19.0.0.0.0 ] , [
oracle.ons.cclient, 19.0.0.0.0 ] , [ oracle.rdbms.tg4msql, 19.0.0.0.0 ] , [
oracle.xdk.companion, 19.0.0.0.0 ] , [ oracle.network.cman, 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.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.rdbms.install.common, 19.0.0.0.0...
Patching component oracle.nlsrtl.rsf,
19.0.0.0.0...
Patching component
oracle.rdbms.install.plugins, 19.0.0.0.0...
Patching component oracle.rdbms.lbac,
19.0.0.0.0...
Patching component oracle.mgw.common,
19.0.0.0.0...
Patching component oracle.xdk.rsf,
19.0.0.0.0...
Patching component oracle.oraolap,
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 33192793 successfully applied.
Sub-set patch [29517242] has become
inactive due to the application of a super-set patch [33192793].
Please refer to Doc ID 2161861.1 for
any possible further required actions.
Log file location:
/u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2021-11-12_09-54-32AM_1.log
OPatch succeeded.
Step 7-execute post installation scripts
·
Check the status in dba_registry
group it will not updated do the post installation script
SQL> select
VERSION_FULL,STATUS,COUNT(*) from dba_registry group by VERSION_FULL,STATUS;
VERSION_FULL STATUS COUNT(*)
------------------------------
-------------------------------------------- ----------
19.3.0.0.0 LOADING 1
19.3.0.0.0
VALID 13
19.3.0.0.0
OPTION OFF 1
·
Connect the server and start the database after that exit
and run it ./datapatch –verbose command in patch location
[oracle@vignesh OPatch]$ ./datapatch
-verbose
SQL Patching tool version 19.13.0.0.0
Production on Fri Nov 12 08:24:07 2021
Copyright (c) 2012, 2021,
Oracle. All rights reserved.
Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_25662_2021_11_12_08_24_07/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.13.0.0.0 Release_Update 211004165050: Installed
SQL registry:
Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 13-SEP-21
11.12.17.197202 PM
Adding patches to installation queue
and performing prereq checks...done
Installation queue:
No interim patches need to be rolled back
Patch 33192793 (Database Release Update : 19.13.0.0.211019 (33192793)):
Apply from 19.3.0.0.0 Release_Update 190410122720 to 19.13.0.0.0
Release_Update 211004165050
No interim patches need to be applied
Installing patches...
Patch installation complete. Total patches installed: 1
Validating logfiles...done
Patch 33192793 apply: SUCCESS
logfile:
/u01/app/oracle/cfgtoollogs/sqlpatch/33192793/24462514/33192793_apply_LIVEDB_2021Nov12_08_25_07.log
(no errors)
SQL Patching tool complete on Fri Nov
12 08:38:59 2021
Connect database and check the
compatibility version it can be updated
SQL> select
VERSION_FULL,STATUS,COUNT(*) from dba_registry group by VERSION_FULL,STATUS;
VERSION_FULL STATUS COUNT(*)
------------------------------
-------------------------------------------- ----------
19.13.0.0.0 VALID 13
19.13.0.0.0 OPTION
OFF 1
19.13.0.0.0
LOADING 1
Step 8- Startup the Database and Listener
Step 9 -Check the dba_registry_sqlpatch
SQL> SET
LINESIZE 200
SET PAGESIZE 200
COLUMN action_time
FORMAT A20
COLUMN action
FORMAT A20
COLUMN namespace
FORMAT A20
COLUMN version
FORMAT A10
COLUMN comments
FORMAT A30
COLUMN
bundle_series FORMAT A10
select description,
action, to_char(action_time,'DD/MM/RR HH24:MI:SS') action_date, ' ' version
from dba_registry_sqlpatch;
DESCRIPTION ACTION
ACTION_DATE VERSION
----------------------------------------------------------------------------------------------------
-------------------- ----------------- ----------
Database Release Update :
19.3.0.0.190416 (29517242) APPLY
13/09/21 23:12:17
Database Release Update :
19.13.0.0.211019 (33192793) APPLY
12/11/21 08:38:58
*************************************************************************
ROLL BACK PATCHING
Sometimes you need to roll back the applied Oracle database
PSU (Patch Set Update) for whatever the reason is. So you need to know how
to de-install the patch applied in quick and
swift way especially if you are doing it in production environment.
Step 1- shut down db and listener
Step 2- in ORACLE_HOME/Opatch location run
rollback command
Mention
the patch id to be rollbacked
[oracle@vignesh OPatch]$ opatch
rollback -id 33192793
Oracle Interim Patch Installer
version 12.2.0.1.27
Copyright (c) 2021, Oracle
Corporation. All rights reserved.
Oracle Home :
/u01/app/oracle/product/19.0.0/dbhome_1
Central Inventory :
/u01/app/oraInventory
from :
/u01/app/oracle/product/19.0.0/dbhome_1/oraInst.loc
OPatch version : 12.2.0.1.27
OUI version : 12.2.0.7.0
Log file location :
/u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2021-11-12_09-12-56AM_1.log
Patches will be rolled back in the
following order:
33192793
The following patch(es) will be
rolled back: 33192793
Please shutdown Oracle instances
running out of this ORACLE_HOME on the local system.
(Oracle Home =
'/u01/app/oracle/product/19.0.0/dbhome_1')
Is the local system ready for
patching? [y|n]
Y
User Responded with: Y
Rolling back patch 33192793...
RollbackSession rolling back interim
patch '33192793' from OH '/u01/app/oracle/product/19.0.0/dbhome_1'
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...
Deleting "qesxldsb.o" from
archive "/u01/app/oracle/product/19.0.0/dbhome_1/lib/libcommon19.a"
Deleting "qesdsbc.o" from
archive "/u01/app/oracle/product/19.0.0/dbhome_1/lib/libcommon19.a"
Deleting "skfparity.o" from
archive "/u01/app/oracle/product/19.0.0/dbhome_1/lib/libcommon19.a"
Deleting "kubsbdcore.o"
from archive
"/u01/app/oracle/product/19.0.0/dbhome_1/lib/libclient19.a"
Deleting "kubsorccore.o"
from archive "/u01/app/oracle/product/19.0.0/dbhome_1/lib/libclient19.a"
Deleting "kubsorcpb.o" from
archive "/u01/app/oracle/product/19.0.0/dbhome_1/lib/libclient19.a"
Deleting "kubsutl.o" from
archive "/u01/app/oracle/product/19.0.0/dbhome_1/lib/libclient19.a"
Deleting "kubsbufio.o" from
archive "/u01/app/oracle/product/19.0.0/dbhome_1/lib/libclient19.a"
Deleting "kubsorcppd.o"
from archive
"/u01/app/oracle/product/19.0.0/dbhome_1/lib/libclient19.a"
Deleting "kubsbd.o" from
archive "/u01/app/oracle/product/19.0.0/dbhome_1/lib/libclient19.a"
Deleting "kpuadg.o" from
archive "/u01/app/oracle/product/19.0.0/dbhome_1/lib/libclient19.a"
Deleting "kubscrf.o" from
archive "/u01/app/oracle/product/19.0.0/dbhome_1/lib/libclient19.a"
Deleting "skgrlib_ipcdat.o"
from archive "/u01/app/oracle/product/19.0.0/dbhome_1/lib/libgeneric19.a"
Deleting "kgoms.o" from
archive "/u01/app/oracle/product/19.0.0/dbhome_1/lib/libgeneric19.a"
Deleting "qsodamd.o" from
archive "/u01/app/oracle/product/19.0.0/dbhome_1/lib/libgeneric19.a"
Deleting "skgzfndd.o" from
archive "/u01/app/oracle/product/19.0.0/dbhome_1/lib/libgeneric19.a"
Deleting "skgrlib.o" from
archive "/u01/app/oracle/product/19.0.0/dbhome_1/lib/libgeneric19.a"
Deleting "qcpi8.o" from
archive "/u01/app/oracle/product/19.0.0/dbhome_1/lib/libgeneric19.a"
Deleting "skgzibr.o" from
archive "/u01/app/oracle/product/19.0.0/dbhome_1/lib/libgeneric19.a"
Deleting "qsodalob.o" from
archive "/u01/app/oracle/product/19.0.0/dbhome_1/lib/libgeneric19.a"
Deleting "skgzepclib.o"
from archive "/u01/app/oracle/product/19.0.0/dbhome_1/lib/libgeneric19.a"
Patching component oracle.rdbms.util,
19.0.0.0.0...
Patching component oracle.rdbms,
19.0.0.0.0...
Deleting "kcert.o" from
archive "/u01/app/oracle/product/19.0.0/dbhome_1/lib/libserver19.a"
Deleting "ksmpgaum.o" from
archive "/u01/app/oracle/product/19.0.0/dbhome_1/lib/libserver19.a"
Deleting "kubsbufio.o" from
archive "/u01/app/oracle/product/19.0.0/dbhome_1/lib/libserver19.a"
Deleting "kbclgdr.o" from
archive "/u01/app/oracle/product/19.0.0/dbhome_1/lib/libserver19.a"
Deleting "kqro.o" from
archive "/u01/app/oracle/product/19.0.0/dbhome_1/lib/libserver19.a"
Deleting "kpoxcd.o" from
archive "/u01/app/oracle/product/19.0.0/dbhome_1/lib/libserver19.a"
Deleting "hcsbtmpl.o" from
archive "/u01/app/oracle/product/19.0.0/dbhome_1/lib/libserver19.a"
Deleting "ktbdat.o" from
archive "/u01/app/oracle/product/19.0.0/dbhome_1/lib/libserver19.a"
Deleting "kbcs.o" from
archive "/u01/app/oracle/product/19.0.0/dbhome_1/lib/libserver19.a"
Deleting "hcscalctsg.o"
from archive "/u01/app/oracle/product/19.0.0/dbhome_1/lib/libserver19.a"
Deleting "hcscalctpl.o"
from archive
"/u01/app/oracle/product/19.0.0/dbhome_1/lib/libserver19.a"
Deleting "kpdbapx.o" from
archive "/u01/app/oracle/product/19.0.0/dbhome_1/lib/libserver19.a"
Deleting "hcscalctoz.o" from
archive "/u01/app/oracle/product/19.0.0/dbhome_1/lib/libserver19.a"
Deleting "kge.o" from
archive "/u01/app/oracle/product/19.0.0/dbhome_1/lib/libserver19.a"
Deleting "kubsd.o" from
archive "/u01/app/oracle/product/19.0.0/dbhome_1/lib/libserver19.a"
Deleting "qjsntrans.o" from
archive "/u01/app/oracle/product/19.0.0/dbhome_1/lib/libserver19.a"
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.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.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.network.listener, 19.0.0.0.0...
Patching component
oracle.network.client, 19.0.0.0.0...
Patching component oracle.ctx.rsf,
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.xdk,
19.0.0.0.0...
Patching component oracle.ons.ic,
19.0.0.0.0...
Patching component oracle.xdk.xquery,
19.0.0.0.0...
Patching component
oracle.rdbms.drdaas, 19.0.0.0.0...
Patching component
oracle.javavm.server, 19.0.0.0.0...
Patching component oracle.ovm,
19.0.0.0.0...
Patching component oracle.dbdev,
19.0.0.0.0...
Patching component oracle.rdbms.dv,
19.0.0.0.0...
Patching component
oracle.precomp.rsf, 19.0.0.0.0...
Patching component oracle.ctx.atg,
19.0.0.0.0...
Patching component
oracle.ldap.security.osdt, 19.0.0.0.0...
Patching component
oracle.ldap.client, 19.0.0.0.0...
Patching component
oracle.ldap.rsf.ic, 19.0.0.0.0...
Patching component oracle.xdk.parser.java,
19.0.0.0.0...
Patching component
oracle.oraolap.dbscripts, 19.0.0.0.0...
Patching component oracle.odbc,
19.0.0.0.0...
Patching component
oracle.sdo.locator, 19.0.0.0.0...
Patching component
oracle.dbtoolslistener, 19.0.0.0.0...
Patching component oracle.ons,
19.0.0.0.0...
Patching component
oracle.oraolap.api, 19.0.0.0.0...
Patching component
oracle.rdbms.hsodbc, 19.0.0.0.0...
Patching component oracle.rdbms.rman,
19.0.0.0.0...
Patching component
oracle.rdbms.install.common, 19.0.0.0.0...
Patching component oracle.nlsrtl.rsf,
19.0.0.0.0...
Patching component
oracle.rdbms.install.plugins, 19.0.0.0.0...
Patching component oracle.rdbms.lbac,
19.0.0.0.0...
Patching component oracle.mgw.common,
19.0.0.0.0...
Patching component oracle.xdk.rsf,
19.0.0.0.0...
Deleting "jzntrans.o" from
archive "/u01/app/oracle/product/19.0.0/dbhome_1/lib/libxml19.a"
Deleting "jznpathval.o"
from archive "/u01/app/oracle/product/19.0.0/dbhome_1/lib/libxml19.a"
Patching component oracle.oraolap,
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...
RollbackSession removing interim
patch '33192793' from inventory
Inactive sub-set patch [29517242] has
become active due to the rolling back of a super-set patch [33192793].
Please refer to Doc ID 2161861.1 for
any possible further required actions.
Log file location: /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2021-11-12_09-12-56AM_1.log
OPatch succeeded.
[oracle@vignesh OPatch]$
Step 3- run the ./datapatch –verbose command it will be updated
Step 4- connect and check in database level
[oracle@vignesh ~]$ . livedb.env
[oracle@vignesh ~]$ sqlplus / as
sysdba
SQL*Plus: Release 19.0.0.0.0 -
Production on Fri Nov 12 09:39:25 2021
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> SET LINESIZE 200
SET PAGESIZE 200
COLUMN action_time FORMAT A20
COLUMN action FORMAT A20
COLUMN namespace FORMAT A20
COLUMN version FORMAT A10
COLUMN comments FORMAT A30
COLUMN bundle_series FORMAT A10
select description, action,
to_char(action_time,'DD/MM/RR HH24:MI:SS') action_date, ' ' version
from dba_registry_sqlpatch;
DESCRIPTION ACTION
ACTION_DATE VERSION
----------------------------------------------------------------------------------------------------
-------------------- ----------------- ----------
Database Release Update :
19.3.0.0.190416 (29517242) APPLY 13/09/21 23:12:17
Database Release Update :
19.13.0.0.211019 (33192793) APPLY 12/11/21 08:38:58
Database Release Update :
19.13.0.0.211019 (33192793) ROLLBACK 12/11/21 09:35:24
SQL>
Important commands:
opatch version
opatch apply
opatch lsinventory
opatch rollback –id
./ datapatch -verbose
No comments:
Post a Comment