Database Administrator's blog: 19c Oracle Home Patching

====19c Oracle Home Patching=======

/u01/app/oracle/product/19.0.0/dbhome_1/OPatch/opatch version

[oracle@remit19c OPatch]$

[oracle@remit19c OPatch]$ /u01/app/oracle/product/19.0.0/dbhome_1/OPatch/opatch version

OPatch Version: 12.2.0.1.17

OPatch succeeded.

[oracle@remit19c OPatch]$

>> Need to change Opatch version for 19c patching

[oracle@remit19c dbhome_1]$ mv OPatch/ 15oct23_OPatch

[oracle@remit19c dbhome_1]$

[oracle@remit19c dbhome_1]$ cd 15oct23_OPatch

[oracle@remit19c 15oct23_OPatch]$

[oracle@remit19c 15oct23_OPatch]$ cd OPatch/

-bash: cd: OPatch/: No such file or directory

[oracle@remit19c 15oct23_OPatch]$

>> Copy OPatch file to Oracle Home directory

[oracle@remit19c dbhome_1]$ cd OPatch/

[oracle@remit19c OPatch]$

[oracle@remit19c OPatch]$ ls -ld

drwxr-xr-x. 15 oracle oinstall 4096 Oct 15 16:12 .

[oracle@remit19c OPatch]$

[oracle@remit19c dbhome_1]$ chmod -R 775 OPatch/

[oracle@remit19c dbhome_1]$

[oracle@remit19c dbhome_1]$ /u01/app/oracle/product/19.0.0/dbhome_1/OPatch/opatch version

OPatch Version: 12.2.0.1.33

OPatch succeeded.

[oracle@remit19c dbhome_1]$

[oracle@remit19c dbhome_1]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Sun Oct 15 16:17:11 2023

Version 19.3.0.0.0

Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.3.0.0.0

SQL> show parameter db_uni

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

db_unique_name string remit

SQL>

[oracle@remit19c dbhome_1]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Sun Oct 15 16:18:31 2023

Version 19.3.0.0.0

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>

SQL> exit

Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.3.0.0.0

[oracle@remit19c dbhome_1]$

[oracle@remit19c dbhome_1]$ lsnrctl stop

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 15-OCT-2023 16:19:44

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=remit19c)(PORT=1521)))

The command completed successfully

[oracle@remit19c dbhome_1]$

>> Copy p34416665_190000_Linux-x86-64 patch file to /u01/soft/OraHome_Patch and unzip

[oracle@remit19c OraHome_Patch]$ ls -ltr

total 2551360

drwxr-x---. 8 oracle oinstall 159 Oct 17 2022 34416665

-rw-rw-r--. 1 oracle oinstall 1762911 Oct 19 2022 PatchSearch.xml

-rwxrwxr-x. 1 oracle oinstall 2610825269 Oct 15 16:26 p34416665_190000_Linux-x86-64.zip

[oracle@remit19c OraHome_Patch]$

[oracle@remit19c OraHome_Patch]$ cd 34416665

[oracle@remit19c 34416665]$ ls

33575402 34419443 34428761 34444834 34580338 automation bundle.xml README.html README.txt

[oracle@remit19c 34416665]$

[oracle@remit19c 34416665]$ cd 34428761

[oracle@remit19c 34428761]$ pwd

/u01/soft/OraHome_Patch/34416665/34428761

[oracle@remit19c 34428761]$

/u01/app/oracle/product/19.0.0/dbhome_1/OPatch/opatch apply

[oracle@remit19c 34416665]$ cd 34419443

[oracle@remit19c 34419443]$ pwd

/u01/soft/OraHome_Patch/34416665/34419443

[oracle@remit19c 34419443]$

[oracle@remit19c 34419443]$ /u01/app/oracle/product/19.0.0/dbhome_1/OPatch/opatch apply

[oracle@remit19c 34416665]$ cd 34419443

[oracle@remit19c 34419443]$ pwd

/u01/soft/OraHome_Patch/34416665/34419443

[oracle@remit19c 34419443]$

[oracle@remit19c 34419443]$ /u01/app/oracle/product/19.0.0/dbhome_1/OPatch/opatch apply

Oracle Interim Patch Installer version 12.2.0.1.33

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.33

OUI version : 12.2.0.7.0

Log file location : /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2023-10-15_16-39-47PM_1.log

Verifying environment and performing prerequisite checks...

--------------------------------------------------------------------------------

Start OOP by Prereq process.

Launch OOP...

Oracle Interim Patch Installer version 12.2.0.1.33

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.33

OUI version : 12.2.0.7.0

Log file location : /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2023-10-15_16-40-23PM_1.log

Verifying environment and performing prerequisite checks...

OPatch continues with these patches: 34419443

Do you want to proceed? [y|n]

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]

User Responded with: Y

Backing up files...

Applying interim patch '34419443' 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.options.olap.api, 19.0.0.0.0 ] , [ oracle.sdo.companion, 19.0.0.0.0 ] , [ oracle.ons.eons.bwcompat, 19.0.0.0.0 ] , [ oracle.rdbms.tg4msql, 19.0.0.0.0 ] , [ oracle.oid.client, 19.0.0.0.0 ] , [ oracle.ons.cclient, 19.0.0.0.0 ] , [ oracle.rdbms.tg4sybs, 19.0.0.0.0 ] , [ oracle.network.cman, 19.0.0.0.0 ] , [ oracle.net.cman, 19.0.0.0.0 ] , [ oracle.options.olap, 19.0.0.0.0 ] , [ oracle.rdbms.tg4tera, 19.0.0.0.0 ] , [ oracle.rdbms.tg4ifmx, 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.ordim.jai, 19.0.0.0.0...

Patching component oracle.bali.jewt, 11.1.1.6.0...

Patching component oracle.bali.ewt, 11.1.1.6.0...

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.blaslapack, 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.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.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.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.precomp.common.core, 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.oci, 19.0.0.0.0...

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

Patching component oracle.network.client, 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.ldap.client, 19.0.0.0.0...

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

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

Patching component oracle.oraolap.dbscripts, 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.mgw.common, 19.0.0.0.0...

Patching component oracle.ctx.rsf, 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.sdo.locator, 19.0.0.0.0...

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

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

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

Patching component oracle.install.deinstalltool, 19.0.0.0.0...

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

Patching component oracle.rdbms.hs_common, 19.0.0.0.0...

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

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

Patching component oracle.dbtoolslistener, 19.0.0.0.0...

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

Patching component oracle.rdbms.hsodbc, 19.0.0.0.0...

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

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

Patching component oracle.oraolap, 19.0.0.0.0...

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

Patching component oracle.odbc, 19.0.0.0.0...

Patching component oracle.ovm, 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 34419443 successfully applied.

Sub-set patch [29517242] has become inactive due to the application of a super-set patch [34419443].

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/opatch2023-10-15_16-40-23PM_1.log

OPatch succeeded.

[oracle@remit19c 34419443]$

[oracle@remit19c 34416665]$ cd 34444834

[oracle@remit19c 34444834]$

[oracle@remit19c 34444834]$ pwd

/u01/soft/OraHome_Patch/34416665/34444834

[oracle@remit19c 34444834]$

[oracle@remit19c 34416665]$ cd 34444834

[oracle@remit19c 34444834]$

[oracle@remit19c 34444834]$ pwd

/u01/soft/OraHome_Patch/34416665/34444834

[oracle@remit19c 34444834]$

[oracle@remit19c 34444834]$ /u01/app/oracle/product/19.0.0/dbhome_1/OPatch/opatch apply

Oracle Interim Patch Installer version 12.2.0.1.33

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.33

OUI version : 12.2.0.7.0

Log file location : /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2023-10-15_16-48-15PM_1.log

Verifying environment and performing prerequisite checks...

--------------------------------------------------------------------------------

Start OOP by Prereq process.

Launch OOP...

Oracle Interim Patch Installer version 12.2.0.1.33

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.33

OUI version : 12.2.0.7.0

Log file location : /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2023-10-15_16-48-47PM_1.log

Verifying environment and performing prerequisite checks...

OPatch continues with these patches: 34444834

Do you want to proceed? [y|n]

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]

User Responded with: Y

Backing up files...

Applying interim patch '34444834' to OH '/u01/app/oracle/product/19.0.0/dbhome_1'

ApplySession: Optional component(s) [ oracle.has.crs, 19.0.0.0.0 ] , [ oracle.has.cvu, 19.0.0.0.0 ] , [ oracle.xag, 19.0.0.0.0 ] , [ oracle.rhp.crs, 19.0.0.0.0 ] , [ oracle.has.crs.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, 19.0.0.0.0...

Patching component oracle.has.rsf, 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.has.common.cvu, 19.0.0.0.0...

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

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

Patch 34444834 successfully applied.

Sub-set patch [29585399] has become inactive due to the application of a super-set patch [34444834].

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/opatch2023-10-15_16-48-47PM_1.log

OPatch succeeded.

[oracle@remit19c 34444834]$

/u01/app/oracle/product/19.0.0/dbhome_1/OPatch/

[oracle@remit19c 34444834]$ cd /u01/app/oracle/product/19.0.0/dbhome_1/OPatch/

[oracle@remit19c OPatch]$

[oracle@remit19c OPatch]$ pwd

/u01/app/oracle/product/19.0.0/dbhome_1/OPatch

[oracle@remit19c OPatch]$

[oracle@remit19c OPatch]$ ./datapatch -verbose

SQL Patching tool version 19.17.0.0.0 Production on Sun Oct 15 16:52:32 2023

Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_3085826_2023_10_15_16_52_32/sqlpatch_invocation.log

Connecting to database...

Error: prereq checks failed!

Database connect failed with: ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

Linux-x86_64 Error: 2: No such file or directory

Additional information: 4475

Additional information: 2010175339 (DBD ERROR: OCISessionBegin)

Please refer to MOS Note 1609718.1 and/or the invocation log

/u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_3085826_2023_10_15_16_52_32/sqlpatch_invocation.log

for information on how to resolve the above errors.

SQL Patching tool complete on Sun Oct 15 16:52:32 2023

[oracle@remit19c OPatch]$

[oracle@remit19c OPatch]$ lsnrctl start

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 15-OCT-2023 16:53:02

Starting /u01/app/oracle/product/19.0.0/dbhome_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 19.0.0.0.0 - Production

System parameter file is /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/listener.ora

Log messages written to /u01/app/oracle/diag/tnslsnr/remit19c/listener/alert/log.xml

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=remit19c)(PORT=1521)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=remit19c)(PORT=1521)))

STATUS of the LISTENER

------------------------

Alias LISTENER

Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production

Start Date 15-OCT-2023 16:53:02

Uptime 0 days 0 hr. 0 min. 0 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/listener.ora

Listener Log File /u01/app/oracle/diag/tnslsnr/remit19c/listener/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=remit19c)(PORT=1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

The listener supports no services

The command completed successfully

[oracle@remit19c OPatch]$

[oracle@remit19c OPatch]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Sun Oct 15 16:53:07 2023

Version 19.17.0.0.0

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 5519702544 bytes

Fixed Size 9148944 bytes

Variable Size 989855744 bytes

Database Buffers 4513071104 bytes

Redo Buffers 7626752 bytes

Database mounted.

Database opened.

SQL>

SQL> alter pluggable database all open;

Pluggable database altered.

SQL>

SQL> exit

Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.17.0.0.0

[oracle@remit19c OPatch]$

[oracle@remit19c OPatch]$ ./datapatch -verbose

SQL Patching tool version 19.17.0.0.0 Production on Sun Oct 15 16:54:11 2023

Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_3086307_2023_10_15_16_54_11/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.17.0.0.0 Release_Update 220924224051: Installed

PDB CDB$ROOT:

Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 15-OCT-23 03.15.13.885441 PM

PDB FRPSPDB:

Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 15-OCT-23 03.20.45.807833 PM

PDB PDB:

Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 15-OCT-23 03.20.45.807833 PM

PDB PDB$SEED:

Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 15-OCT-23 03.20.45.807833 PM

Adding patches to installation queue and performing prereq checks...done

Installation queue:

For the following PDBs: CDB$ROOT PDB$SEED PDB FRPSPDB

No interim patches need to be rolled back

Patch 34419443 (Database Release Update : 19.17.0.0.221018 (34419443)):

Apply from 19.3.0.0.0 Release_Update 190410122720 to 19.17.0.0.0 Release_Update 220924224051

No interim patches need to be applied

Installing patches...

Patch installation complete. Total patches installed: 4

Validating logfiles...done

Patch 34419443 apply (pdb CDB$ROOT): SUCCESS

logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/34419443/24972075/34419443_apply_REMIT_CDBROOT_2023Oct15_16_55_09.log (no errors)

Patch 34419443 apply (pdb PDB$SEED): SUCCESS

logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/34419443/24972075/34419443_apply_REMIT_PDBSEED_2023Oct15_17_02_29.log (no errors)

Patch 34419443 apply (pdb PDB): SUCCESS

logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/34419443/24972075/34419443_apply_REMIT_PDB_2023Oct15_17_02_29.log (no errors)

Patch 34419443 apply (pdb FRPSPDB): SUCCESS

logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/34419443/24972075/34419443_apply_REMIT_FRPSPDB_2023Oct15_17_02_29.log (no errors)

Automatic recompilation incomplete; run utlrp.sql to revalidate.

PDBs: FRPSPDB PDB PDB$SEED

SQL Patching tool complete on Sun Oct 15 17:09:07 2023

[oracle@remit19c OPatch]$

SQL> set linesize 500

SQL>

SQL> col comp_name for a30

SQL> col version for a30

SQL> col version_full for a30

SQL> col modified for a30

SQL>

SQL> col STATUS for a30

SQL>

SQL> select comp_name,version,modified,version_full,STATUS from dba_registry;

COMP_NAME VERSION MODIFIED VERSION_FULL STATUS

------------------------------ ------------------------------ ------------------------------ ------------------------------ ------------------------------

Oracle Database Catalog Views 19.0.0.0.0 15-OCT-2023 15:22:19 19.17.0.0.0 VALID

Oracle Database Packages and T 19.0.0.0.0 15-OCT-2023 15:22:19 19.17.0.0.0 VALID

ypes

Oracle Real Application Cluste 19.0.0.0.0 17-APR-2019 02:03:49 19.17.0.0.0 OPTION OFF

JServer JAVA Virtual Machine 19.0.0.0.0 15-OCT-2023 15:22:22 19.17.0.0.0 VALID

Oracle XDK 19.0.0.0.0 15-OCT-2023 15:22:22 19.17.0.0.0 VALID

Oracle Database Java Packages 19.0.0.0.0 15-OCT-2023 15:22:22 19.17.0.0.0 VALID

OLAP Analytic Workspace 19.0.0.0.0 15-OCT-2023 15:22:22 19.17.0.0.0 VALID

COMP_NAME VERSION MODIFIED VERSION_FULL STATUS

------------------------------ ------------------------------ ------------------------------ ------------------------------ ------------------------------

Oracle XML Database 19.0.0.0.0 15-OCT-2023 15:22:20 19.17.0.0.0 VALID

Oracle Workspace Manager 19.0.0.0.0 15-OCT-2023 15:22:22 19.17.0.0.0 VALID

Oracle Text 19.0.0.0.0 15-OCT-2023 15:22:22 19.17.0.0.0 VALID

Oracle Multimedia 19.0.0.0.0 15-OCT-2023 15:22:22 19.17.0.0.0 VALID

Spatial 19.0.0.0.0 15-OCT-2023 16:58:13 19.17.0.0.0 LOADING

Oracle OLAP API 19.0.0.0.0 15-OCT-2023 17:01:45 19.17.0.0.0 VALID

Oracle Label Security 19.0.0.0.0 15-OCT-2023 15:22:23 19.17.0.0.0 VALID

Oracle Database Vault 19.0.0.0.0 15-OCT-2023 15:22:23 19.17.0.0.0 VALID

15 rows selected.

SQL>

Database Administrator's blog

Pages

Monday, November 6, 2023

19c Oracle Home Patching

No comments:

Post a Comment