Amit's Oracle DBA Blog: Apply Patching 33515361 Oracle 19c Database Release Update 19.14.0.0.0

Apply Patching 33515361 Oracle 19c Database Release Update 19.14.0.0.0

Description:-

This article we are going to see steps used to apply the latest Oracle 19c Database Release Update Patch 33515361: DATABASE RELEASE UPDATE 19.14.0.0.0

The environment is single instance database.

Note:-

1) Review readme file on Patch 32904851 – Database Release Update 19.12.0.0.210720
2) Download patch p32904851_190000_Linux-x86-64.zip
3) Make sure the opatch version is minimum 12.2.0.1.25

Step:-1 Download the Patch from oracle support

p33515361_190000_Linux-x86-64.zip
p6880880_200000_Linux-x86-64.zip

Step:-2 Copied the patch to DB Server

cp p33515361_190000_Linux-x86-64.zip /backup
cp p6880880_200000_Linux-x86-64.zip /backup

[root@rac8 backup]# chown -R oracle:oinstall 33515361

[root@rac8 backup]# chmod -R 775 33515361

Step:-3 Upgrade Opatch Tool

[oracle@rac8 OPatch]$ ./opatch version

OPatch Version: 12.2.0.1.17

OPatch succeeded.

Backup the backup of OPatch

[oracle@rac8 19.3.0.0]$

[oracle@rac8 19.3.0.0]$ mv OPatch/ OPatch_bkp
[oracle@rac8 19.3.0.0]$
[oracle@rac8 backup]$ ls -lrt
total 1489664
drwxrwxr-x 5 oracle oinstall 4096 Jan 13 11:44 33515361
-rw-rw-r-- 1 root root 1178757 Jan 18 14:36 PatchSearch.xml
-rwxr-xr-x 1 root root 1373118192 Feb 7 13:01 p33515361_190000_Linux-x86-64.zip
-rwxrwxr-x 1 oracle oinstall 122883929 Feb 7 13:03 p6880880_200000_Linux-x86-64.zip
-rwxr-xr-x 1 root root 195306 Feb 7 13:04 p29213893_121020_Generic.zip
[oracle@rac8 backup]$
[oracle@rac8 backup]$
[oracle@rac8 backup]$
[oracle@rac8 backup]$ cp p6880880_200000_Linux-x86-64.zip $ORACLE_HOME/
[oracle@rac8 backup]$

[oracle@rac8 19.3.0.0]$ unzip p6880880_200000_Linux-x86-64.zip

[oracle@rac8 19.3.0.0]$ cd OPatch

[oracle@rac8 OPatch]$

[oracle@rac8 OPatch]$ ls -rlt

total 200
drwxr-x--- 6 oracle oinstall 4096 Jan 5 14:23 jre
-rw-r----- 1 oracle oinstall 27 Jan 9 19:24 version.txt
drwxr-x--- 2 oracle oinstall 4096 Jan 9 19:24 scripts
-rw-r----- 1 oracle oinstall 2980 Jan 9 19:24 README.txt
drwxr-xr-x 2 oracle oinstall 4096 Jan 9 19:24 private
-rw-r----- 1 oracle oinstall 3177 Jan 9 19:24 operr_readme.txt
-rwxr-x--- 1 oracle oinstall 4218 Jan 9 19:24 operr.bat
-rwxr-x--- 1 oracle oinstall 3159 Jan 9 19:24 operr
-rw-r----- 1 oracle oinstall 2551 Jan 9 19:24 opatch.pl
-rwxr-x--- 1 oracle oinstall 4290 Jan 9 19:24 opatch_env.sh
-rwxr-x--- 1 oracle oinstall 16554 Jan 9 19:24 opatch.bat
-rwxr-x--- 1 oracle oinstall 49873 Jan 9 19:24 opatch
drwxr-x--- 5 oracle oinstall 4096 Jan 9 19:24 ocm
-rwxr-x--- 1 oracle oinstall 23550 Jan 9 19:24 emdpatch.pl
-rwxr-x--- 1 oracle oinstall 627 Jan 9 19:24 datapatch.bat
-rwxr-x--- 1 oracle oinstall 589 Jan 9 19:24 datapatch
drwxr-x--- 2 oracle oinstall 4096 Jan 9 19:24 config
drwxr-x--- 4 oracle oinstall 4096 Jan 9 19:24 opatchprereqs
drwxr-x--- 2 oracle oinstall 4096 Jan 9 19:24 jlib
drwxr-x--- 3 oracle oinstall 4096 Jan 9 19:29 plugins
drwxr-x--- 3 oracle oinstall 4096 Jan 9 19:29 oracle_common
drwxr-x--- 2 oracle oinstall 4096 Jan 9 19:29 oplan
-rwxr-x--- 1 oracle oinstall 393 Jan 9 19:29 opatchauto.cmd
-rwxr-x--- 1 oracle oinstall 1763 Jan 9 19:29 opatchauto
drwxr-x--- 9 oracle oinstall 4096 Jan 9 19:29 modules
drwxr-x--- 2 oracle oinstall 4096 Jan 9 19:29 docs
drwxr-x--- 7 oracle oinstall 4096 Jan 9 19:29 auto

[oracle@rac8 OPatch]$

[oracle@rac8 OPatch]$ ./opatch version

OPatch Version: 12.2.0.1.29

OPatch succeeded.

[oracle@rac8 OPatch]$

Step:-4 Check Patches status before apply using below query

Before proceeding check the component status and invalids,

Component check:

SET LINESIZE 500
SET PAGESIZE 1000
SET SERVEROUT ON
SET LONG 2000000
COLUMN action_time FORMAT A12
COLUMN action FORMAT A10
COLUMN comments FORMAT A30
COLUMN description FORMAT A60
COLUMN namespace FORMAT A20
COLUMN status FORMAT A10

SELECT TO_CHAR(action_time, 'YYYY-MM-DD') AS action_time,action,status,
description,patch_id FROM sys.dba_registry_sqlpatch ORDER by action_time;

Identifying Invalid Objects before patching

COLUMN object_name FORMAT A30
SELECT owner,
object_type,
object_name,
status
FROM dba_objects
WHERE status = 'INVALID'
ORDER BY owner, object_type, object_name;

Step 5:- Shutdown Database and Listener

SQL> shut 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.11.0.0.0

[grid@rac8 ~]$ lsnrctl stop LISTENER

LSNRCTL for Linux: Version 18.0.0.0.0 - Production on 07-FEB-2022 13:47:23
Copyright (c) 1991, 2018, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rac8.samik.com)(PORT=1521)))
The command completed successfully

Step:-6 Take Backup of ORACLE_HOME and Database (Rollback plan)

cd $ORACLE_HOME
tar -cvf oracle_home_07FEB_2022.tar $ORACLE_HOME

Connect with rman take full backup

Step:-7 Apply RU patch on ORACLE_HOME 19c

Run OPatch command to check if enough free space is available in the database home:

[oracle@rac8 33515361]$ $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /home/oracle/patch_list_dbhome.txt

Oracle Interim Patch Installer version 12.2.0.1.29

PREREQ session

Oracle Home : /u01/app/oracle/product/19.3.0.0

Central Inventory : /u01/app/oraInventory

from : /u01/app/oracle/product/19.3.0.0/oraInst.loc

OPatch version : 12.2.0.1.29

OUI version : 12.2.0.7.0

Log file location : /u01/app/oracle/product/19.3.0.0/cfgtoollogs/opatch/opatch2022-02-07_13-55-06PM_1.log

Invoking prereq "checksystemspace"

Prereq "checkSystemSpace" passed.

OPatch succeeded.

Run pre-check to see if the patches conflict with the installed home binaries.

[oracle@rac8 33515361]$
[oracle@rac8 33515361]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /backup/33515361

Oracle Interim Patch Installer version 12.2.0.1.29
Copyright (c) 2022, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/oracle/product/19.3.0.0
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/19.3.0.0/oraInst.loc
OPatch version : 12.2.0.1.29
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.3.0.0/cfgtoollogs/opatch/opatch2022-02-07_13-57-22PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
[oracle@rac8 33515361]$

[oracle@rac8 33515361]$ pwd
/backup/33515361
[oracle@rac8 33515361]$
[oracle@rac8 33515361]$
[oracle@rac8 33515361]$ ls -lrt
total 92
drwxrwxr-x 35 oracle oinstall 4096 Jan 13 11:44 files
-rwxrwxr-x 1 oracle oinstall 21 Jan 13 11:44 README.txt
drwxrwxr-x 3 oracle oinstall 4096 Jan 13 11:44 etc
drwxrwxr-x 3 oracle oinstall 4096 Jan 13 11:44 custom
-rwxrwxr-x 1 oracle oinstall 76004 Jan 18 13:07 README.html
[oracle@rac8 33515361]$

[oracle@rac8 33515361]$ $ORACLE_HOME/OPatch/opatch apply

Oracle Interim Patch Installer version 12.2.0.1.29

Oracle Home : /u01/app/oracle/product/19.3.0.0

Central Inventory : /u01/app/oraInventory

from : /u01/app/oracle/product/19.3.0.0/oraInst.loc

OPatch version : 12.2.0.1.29

OUI version : 12.2.0.7.0

Log file location : /u01/app/oracle/product/19.3.0.0/cfgtoollogs/opatch/opatch2022-02-07_14-04-15PM_1.log

Verifying environment and performing prerequisite checks...

OPatch continues with these patches: 33515361

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.3.0.0')

Is the local system ready for patching? [y|n]

User Responded with: Y

Backing up files...

Applying interim patch '33515361' to OH '/u01/app/oracle/product/19.3.0.0'

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.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: /u01/app/oracle/product/19.3.0.0/cfgtoollogs/opatch/opatch2022-02-07_14-04-15PM_1.log

OPatch succeeded.

[oracle@rac8 33515361]$

[oracle@rac8 33515361]$ tail -500f /u01/app/oracle/product/19.3.0.0/cfgtoollogs/opatch/opatch2022-02-07_14-04-15PM_1.log

[Feb 7, 2022 2:04:15 PM] [INFO] CAS Dynamic Loading :

CasClasspathLoader: Opatch path to be searched for cas jars :/u01/app/oracle/product/19.3.0.0/OPatch/jlib

CasClasspathLoader : Non CAS based Home

[Feb 7, 2022 2:04:15 PM] [INFO] CUP_LOG: Trying to load HomeOperations object

[Feb 7, 2022 2:04:16 PM] [INFO] CUP_LOG: HomeOperations object created. CUP1.0 is enabled

[Feb 7, 2022 2:04:16 PM] [INFO] OPatch invoked as follows: 'apply -invPtrLoc /u01/app/oracle/product/19.3.0.0/oraInst.loc '

[Feb 7, 2022 2:04:16 PM] [INFO] Runtime args: [-Xmx3072m, -XX:+HeapDumpOnOutOfMemoryError, -XX:HeapDumpPath=/u01/app/oracle/product/19.3.0.0/cfgtoollogs/opatch, -DCommonLog.LOG_SESSION_ID=, -DCommonLog.COMMAND_NAME=apply, -DOPatch.ORACLE_HOME=/u01/app/oracle/product/19.3.0.0, -DOPatch.DEBUG=false, -DOPatch.MAKE=false, -DOPatch.RUNNING_DIR=/u01/app/oracle/product/19.3.0.0/OPatch, -DOPatch.MW_HOME=, -DOPatch.WL_HOME=, -DOPatch.COMMON_COMPONENTS_HOME=, -DOPatch.OUI_LOCATION=/u01/app/oracle/product/19.3.0.0/oui, -DOPatch.FMW_COMPONENT_HOME=, -DOPatch.OPATCH_CLASSPATH=, -DOPatch.WEBLOGIC_CLASSPATH=, -DOPatch.SKIP_OUI_VERSION_CHECK=, -DOPatch.NEXTGEN_HOME_CHECK=false, -DOPatch.PARALLEL_ON_FMW_OH=]

[Feb 7, 2022 2:04:16 PM] [INFO] Heap in use : 27 MB

Total memory: 117 MB

Free memory : 89 MB

Max memory : 2731 MB

[Feb 7, 2022 2:04:16 PM] [INFO] Oracle Home : /u01/app/oracle/product/19.3.0.0

Central Inventory : /u01/app/oraInventory

from : /u01/app/oracle/product/19.3.0.0/oraInst.loc

OPatch version : 12.2.0.1.29

OUI version : 12.2.0.7.0

OUI location : /u01/app/oracle/product/19.3.0.0/oui

Log file location : /u01/app/oracle/product/19.3.0.0/cfgtoollogs/opatch/opatch2022-02-07_14-04-15PM_1.log

[Feb 7, 2022 2:04:16 PM] [INFO] Patch history file: /u01/app/oracle/product/19.3.0.0/cfgtoollogs/opatch/opatch_history.txt

[Feb 7, 2022 2:04:18 PM] [INFO] [OPSR-TIME] Loading raw inventory

[Feb 7, 2022 2:04:18 PM] [INFO] [OPSR-MEMORY] Loaded all components from inventory. Heap memory in use: 25 (MB)

[Feb 7, 2022 2:04:18 PM] [INFO] [OPSR-MEMORY] Loaded all one offs from inventory. Heap memory in use: 26 (MB)

[Feb 7, 2022 2:04:18 PM] [INFO] [OPSR-TIME] Raw inventory loaded successfully

[Feb 7, 2022 2:04:18 PM] [INFO] NApply::no CAS enabled, OPatch runs with legacy process.

[Feb 7, 2022 2:04:18 PM] [INFO] Verifying environment and performing prerequisite checks...

[Feb 7, 2022 2:04:18 PM] [INFO] [OPSR-TIME] Running prerequisite checks

[Feb 7, 2022 2:04:18 PM] [INFO] opatch-external.jar is in /u01/app/oracle/product/19.3.0.0/OPatch/jlib/opatch-external.jar

[Feb 7, 2022 2:04:19 PM] [INFO] [OPSR-TIME] Loading cooked inventory

[Feb 7, 2022 2:04:19 PM] [INFO] [OPSR-MEMORY] : Loading cooked one offs. Heap memory used 70 (MB)

[Feb 7, 2022 2:04:19 PM] [INFO] [OPSR-MEMORY] : Loaded cooked oneoffs. Heap memory used : 89 (MB)

[Feb 7, 2022 2:04:19 PM] [INFO] [OPSR-TIME] Cooked inventory loaded successfully

[Feb 7, 2022 2:04:22 PM] [INFO] Checking if Oracle Home has components required by patches...

[Feb 7, 2022 2:04:22 PM] [INFO] CheckMissingComps: Cached file does not exist or is invalid, re-build prereq result.

[Feb 7, 2022 2:04:22 PM] [INFO] Checking conflict among patches...

[Feb 7, 2022 2:04:22 PM] [INFO] Running prereq checkConflictAmongPatchesWithDetail

[Feb 7, 2022 2:04:26 PM] [INFO] Following patches can be applied: 33515361

[Feb 7, 2022 2:04:26 PM] [INFO] Following patches are not required:

[Feb 7, 2022 2:04:26 PM] [INFO] Following patches are auto rollbackable:

[Feb 7, 2022 2:04:26 PM] [INFO] Finished checking prereq checkConflictAmongPatchesWithDetail

[Feb 7, 2022 2:04:26 PM] [INFO] Conflict checking amongst patches PASSED

[Feb 7, 2022 2:04:26 PM] [INFO] Checking conflicts against Oracle Home...

[Feb 7, 2022 2:04:26 PM] [INFO] Running prereq checkConflictAgainstOHWithDetail

[Feb 7, 2022 2:04:26 PM] [INFO] CUP_LOG: Found pi CUP 33515361 is a superset of poh CUP: 29517242

[Feb 7, 2022 2:04:31 PM] [INFO] Following patches can be applied: 33515361

[Feb 7, 2022 2:04:31 PM] [INFO] Following patches are not required:

[Feb 7, 2022 2:04:31 PM] [INFO] Following patches are auto rollbackable:

[Feb 7, 2022 2:04:31 PM] [INFO] Finished checking prereq checkConflictAgainstOHWithDetail

[Feb 7, 2022 2:04:32 PM] [INFO] Execution of 'sh /backup/33515361/custom/scripts/init -apply 33515361 ':

[Feb 7, 2022 2:04:32 PM] [INFO] Return Code = 0

[Feb 7, 2022 2:04:32 PM] [INFO] Execution of ' Command and arguments of init script is restricted to be viewed in log file ':

Return Code = 0

[Feb 7, 2022 2:04:34 PM] [INFO] Running prerequisite checks...

[Feb 7, 2022 2:04:34 PM] [INFO] Space Needed : 5880.463MB

[Feb 7, 2022 2:04:36 PM] [INFO] Prereq checkPatchApplicableOnCurrentPlatform Passed for patch : 33515361

[Feb 7, 2022 2:04:38 PM] [INFO] Start fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/lib/libasmclntsh19.so at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Finish fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/lib/libasmclntsh19.so at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Start fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/lib/libclntsh.so.19.1 at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Finish fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/lib/libclntsh.so.19.1 at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Start fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/lib/libagtsh.so.1.0 at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Finish fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/lib/libagtsh.so.1.0 at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Start fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/lib/libsqlplus.so at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Finish fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/lib/libsqlplus.so at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Start fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/lib/libclntsh.so.18.1 at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Finish fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/lib/libclntsh.so.18.1 at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Start fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/sdk/proc at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Finish fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/sdk/proc at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Start fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/sdk/procob at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Finish fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/sdk/procob at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Start fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/ctx/bin/ctxhx at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Finish fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/ctx/bin/ctxhx at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Start fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/amdu at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Finish fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/amdu at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Start fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/kfed at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Finish fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/kfed at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Start fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/kfod at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Finish fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/kfod at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Start fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/oracle at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Finish fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/oracle at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Start fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/orion at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Finish fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/orion at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Start fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/renamedg at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Finish fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/renamedg at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Start fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/extjob at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Finish fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/extjob at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Start fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/extjobo at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Finish fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/extjobo at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Start fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/setasmgid at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Finish fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/setasmgid at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Start fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/rman at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Finish fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/rman at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Start fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/wrap at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Finish fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/wrap at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Start fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/plshprof at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Finish fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/plshprof at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Start fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/lsnrctl at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Finish fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/lsnrctl at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Start fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/tnslsnr at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Finish fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/tnslsnr at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Start fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/procob at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Finish fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/procob at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Start fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/ctxkbtc at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Finish fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/ctxkbtc at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Start fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/ctxlc at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Finish fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/ctxlc at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Start fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/ctxload at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Finish fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/ctxload at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Start fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/dgmgrl at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Finish fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/dgmgrl at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Start fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/orapwd at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Finish fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/orapwd at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Start fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/tstshm at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Finish fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/tstshm at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Start fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/sqlldr at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Finish fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/sqlldr at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Start fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/wrc at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Finish fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/wrc at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Start fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/expdp at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Finish fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/expdp at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Start fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/tkprof at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Finish fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/tkprof at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Start fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/kgmgr at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Finish fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/kgmgr at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Start fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/ldapsearch at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Finish fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/ldapsearch at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Start fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/sbttest at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Finish fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/sbttest at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Start fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/nid at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Finish fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/nid at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Start fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/impdp at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Finish fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/impdp at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Start fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/tnsping at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Finish fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/tnsping at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Start fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/trcldr at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Finish fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/trcldr at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Start fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/dg4pwd at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] Finish fuser command /sbin/fuser /u01/app/oracle/product/19.3.0.0/bin/dg4pwd at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:04:38 PM] [INFO] OPatch continues with these patches: 33515361

[Feb 7, 2022 2:04:38 PM] [INFO] Do you want to proceed? [y|n]

[Feb 7, 2022 2:04:38 PM] [INFO] Start to wait for user-input at Mon Feb 07 14:04:38 IST 2022

[Feb 7, 2022 2:05:32 PM] [INFO] Finish waiting for user-input at Mon Feb 07 14:05:32 IST 2022

[Feb 7, 2022 2:05:32 PM] [INFO] User Responded with: Y

[Feb 7, 2022 2:05:33 PM] [INFO] OPatchSessionHelper::sortOnOverlay() Sorting is not needed

[Feb 7, 2022 2:05:33 PM] [INFO] [OPSR-TIME] All checks passed.

[Feb 7, 2022 2:05:33 PM] [INFO] Need to look only in the OUI based Oracle Home to configure OCM

[Feb 7, 2022 2:05:33 PM] [INFO] Current working directory is : /u01/app/oracle/product/19.3.0.0/OPatch

[Feb 7, 2022 2:05:33 PM] [INFO] OPatch is generic, it is not bundled with OCM.

[Feb 7, 2022 2:05:33 PM] [INFO] opatch-external.jar is in /u01/app/oracle/product/19.3.0.0/OPatch/jlib/opatch-external.jar

[Feb 7, 2022 2:05:33 PM] [INFO] You selected -local option, hence OPatch will patch the local system only.

[Feb 7, 2022 2:05:33 PM] [INFO] Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.

(Oracle Home = '/u01/app/oracle/product/19.3.0.0')

[Feb 7, 2022 2:05:33 PM] [INFO] Is the local system ready for patching? [y|n]

[Feb 7, 2022 2:05:33 PM] [INFO] Start to wait for user-input at Mon Feb 07 14:05:33 IST 2022

[Feb 7, 2022 2:05:36 PM] [INFO] Finish waiting for user-input at Mon Feb 07 14:05:36 IST 2022

[Feb 7, 2022 2:05:36 PM] [INFO] User Responded with: Y

[Feb 7, 2022 2:05:36 PM] [INFO] Backing up files...

[Feb 7, 2022 2:05:36 PM] [INFO] OUI-67117:Backing up files affected by the patch 'NApply' for restore. This might take a while...

Step:-8 Startup the Database and Listener

[grid@rac8 ~]$ lsnrctl start LISTENER

LSNRCTL for Linux: Version 18.0.0.0.0 - Production on 07-FEB-2022 14:24:13

Starting /u02/app/18.3.0/grid/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 18.0.0.0.0 - Production

System parameter file is /u02/app/18.3.0/grid/network/admin/listener.ora

Log messages written to /u02/app/grid/diag/tnslsnr/rac8/listener/alert/log.xml

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rac8.samik.com)(PORT=1521)))

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rac8.samik.com)(PORT=1521)))

STATUS of the LISTENER

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

Alias LISTENER

Version TNSLSNR for Linux: Version 18.0.0.0.0 - Production

Start Date 07-FEB-2022 14:24:14

Uptime 0 days 0 hr. 0 min. 1 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u02/app/18.3.0/grid/network/admin/listener.ora

Listener Log File /u02/app/grid/diag/tnslsnr/rac8/listener/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rac8.samik.com)(PORT=1521)))

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

Services Summary...

Service "SAMIT" has 1 instance(s).

Instance "SAMIT", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

[oracle@rac8 33515361]$ echo $ORACLE_SID

SAMIT

[oracle@rac8 33515361]$

[oracle@rac8 33515361]$ sqlplus '/as sysdba'

SQL*Plus: Release 19.0.0.0.0 - Production on Mon Feb 7 14:25:06 2022

Version 19.14.0.0.0

Connected to an idle instance.

SQL> startup;

ORACLE instance started.

Total System Global Area 2147481648 bytes

Fixed Size 8898608 bytes

Variable Size 520093696 bytes

Database Buffers 1610612736 bytes

Redo Buffers 7876608 bytes

Database mounted.

Database opened.

SQL>

Step:-9 Execute post patch steps and run datapatch command

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

SQL Patching tool version 19.14.0.0.0 Production on Mon Feb 7 14:48:41 2022

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

Connecting to database...OK

Gathering database info...done

Bootstrapping registry and package to current versions...done

ORA19: Error in bootstrap log /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_58219_2022_02_07_14_48_41/bootstrap1_ORA19.log:

-> Error at line 137: script sqlpatch_bootstrap.sql

- ORA-04042: procedure, function, package, or package body does not exist

Error: prereq checks failed!

Failure during bootstrap

Prereq check failed, exiting without installing any patches.

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

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

for information on how to resolve the above errors.

SQL Patching tool complete on Mon Feb 7 14:48:50 2022

[oracle@rac8 OPatch]$

[oracle@rac8 OPatch]$ ./datapatch

SQL Patching tool version 19.14.0.0.0 Production on Mon Feb 7 20:32:26 2022

Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_32779_2022_02_07_20_32_26/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.14.0.0.0 Release_Update 211225122123: Installed

SQL registry:

No release update patches installed

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

Installation queue:

No interim patches need to be rolled back

Patch 33515361 (Database Release Update : 19.14.0.0.220118 (33515361)):

Apply from 19.1.0.0.0 Feature Release to 19.14.0.0.0 Release_Update 211225122123

No interim patches need to be applied

Installing patches...

Patch installation complete. Total patches installed: 1

Validating logfiles...done

Patch 33515361 apply: WITH ERRORS

logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/33515361/24589353/33515361_apply_ORA19T_2022Feb07_20_33_26.log (errors)

-> Error at line 214633: script rdbms/admin/prvtxdbz.plb

- Warning: Trigger created with compilation errors.

-> Error at line 214640: script rdbms/admin/prvtxdbz.plb

- 4/7 PL/SQL: Statement ignored

-> Error at line 214641: script rdbms/admin/prvtxdbz.plb

- 4/7 PLS-00201: identifier 'XDB.XDB_PITRIG_PKG' must be declared

-> Error at line 214642: script rdbms/admin/prvtxdbz.plb

- 6/7 PL/SQL: Statement ignored

-> Error at line 214643: script rdbms/admin/prvtxdbz.plb

- 6/7 PLS-00201: identifier 'XDB.XDB_PITRIG_PKG' must be declared

-> Error at line 218920: script rdbms/admin/catxdbtm.sql

- ORA-06550: line 46, column 15:

- PLS-00201: identifier 'XDB.DBMS_CSX_INT' must be declared

- ORA-06550: line 46, column 5:

- PL/SQL: Statement ignored

-> Error at line 220720: script rdbms/admin/prvtsodautil.plb

- Warning: Package Body created with compilation errors.

-> Error at line 220727: script rdbms/admin/prvtsodautil.plb

- 10/5 PL/SQL: SQL Statement ignored

-> Error at line 220729: script rdbms/admin/prvtsodautil.plb

- 21/5 PL/SQL: SQL Statement ignored

-> Error at line 220731: script rdbms/admin/prvtsodautil.plb

- 34/7 PL/SQL: SQL Statement ignored

-> Error at line 220733: script rdbms/admin/prvtsodautil.plb

- 41/7 PL/SQL: SQL Statement ignored

-> Error at line 220738: script rdbms/admin/prvtsodautil.plb

- 63/5 PL/SQL: SQL Statement ignored

-> Error at line 220740: script rdbms/admin/prvtsodautil.plb

- 74/5 PL/SQL: SQL Statement ignored

-> Error at line 220742: script rdbms/admin/prvtsodautil.plb

- 87/5 PL/SQL: SQL Statement ignored

-> Error at line 220747: script rdbms/admin/prvtsodautil.plb

- 93/5 PL/SQL: SQL Statement ignored

-> Error at line 220749: script rdbms/admin/prvtsodautil.plb

- 107/5 PL/SQL: SQL Statement ignored

-> Error at line 220751: script rdbms/admin/prvtsodautil.plb

- 123/5 PL/SQL: SQL Statement ignored

-> Error at line 220996: script rdbms/admin/prvtsodadml.plb

- Warning: Package Body created with compilation errors.

-> Error at line 221003: script rdbms/admin/prvtsodadml.plb

- 0/0 PL/SQL: Compilation unit analysis terminated

-> Error at line 221004: script rdbms/admin/prvtsodadml.plb

- 13/5 PL/SQL: SQL Statement ignored

-> Error at line 221006: script rdbms/admin/prvtsodadml.plb

- 33/5 PL/SQL: SQL Statement ignored

-> Error at line 221008: script rdbms/admin/prvtsodadml.plb

- 49/5 PL/SQL: SQL Statement ignored

-> Error at line 221013: script rdbms/admin/prvtsodadml.plb

- 58/5 PL/SQL: SQL Statement ignored

-> Error at line 221015: script rdbms/admin/prvtsodadml.plb

- 69/5 PL/SQL: SQL Statement ignored

-> Error at line 221017: script rdbms/admin/prvtsodadml.plb

- 103/5 PL/SQL: SQL Statement ignored

-> Error at line 221019: script rdbms/admin/prvtsodadml.plb

- 113/12 PLS-00341: declaration of cursor 'SODACUR' is incomplete or

-> Error at line 221025: script rdbms/admin/prvtsodadml.plb

- 114/20 PL/SQL: SQL Statement ignored

-> Error at line 221575: script rdbms/admin/prvtsodacoll.plb

- Warning: Package Body created with compilation errors.

-> Error at line 221582: script rdbms/admin/prvtsodacoll.plb

- 408/7 PL/SQL: SQL Statement ignored

-> Error at line 221584: script rdbms/admin/prvtsodacoll.plb

- 415/7 PL/SQL: SQL Statement ignored

-> Error at line 221586: script rdbms/admin/prvtsodacoll.plb

- 428/5 PL/SQL: SQL Statement ignored

-> Error at line 221588: script rdbms/admin/prvtsodacoll.plb

- 2436/5 PL/SQL: SQL Statement ignored

-> Error at line 221593: script rdbms/admin/prvtsodacoll.plb

- 2521/5 PL/SQL: SQL Statement ignored

-> Error at line 221595: script rdbms/admin/prvtsodacoll.plb

- 2535/9 PL/SQL: Statement ignored

-> Error at line 221596: script rdbms/admin/prvtsodacoll.plb

- 2535/41 PLS-00364: loop index variable 'COLLECTION_REC' use is invalid

-> Error at line 221597: script rdbms/admin/prvtsodacoll.plb

- 2540/9 PL/SQL: Statement ignored

-> Error at line 221598: script rdbms/admin/prvtsodacoll.plb

- 2540/40 PLS-00364: loop index variable 'COLLECTION_REC' use is invalid

-> Error at line 222748: script rdbms/admin/prvtsodapls.plb

- Warning: Package Body created with compilation errors.

-> Error at line 222755: script rdbms/admin/prvtsodapls.plb

- 55/9 PL/SQL: SQL Statement ignored

-> Error at line 222757: script rdbms/admin/prvtsodapls.plb

- 58/7 PL/SQL: Statement ignored

-> Error at line 222758: script rdbms/admin/prvtsodapls.plb

- 58/20 PLS-00364: loop index variable 'R' use is invalid

-> Error at line 222937: script rdbms/admin/prvtgwm.sql

- 55/9 PL/SQL: SQL Statement ignored

-> Error at line 222939: script rdbms/admin/prvtgwm.sql

- 58/7 PL/SQL: Statement ignored

-> Error at line 222940: script rdbms/admin/prvtgwm.sql

- 58/20 PLS-00364: loop index variable 'R' use is invalid

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

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

for information on how to resolve the above errors.

SQL Patching tool complete on Mon Feb 7 20:35:19 2022

[oracle@rac8 OPatch]$

CON_ID ACTION_TIME PATCH_ID PATCH_TYPE ACTION DESCRIPTION SOURCE_VERSION TARGET_VERSION

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

0 2022-02-07 33515361 RU APPLY Database Release Update : 19.14.0.0.2201 19.1.0.0.0 19.14.0.0.0

18 (33515361)

Step:-10 Check opatch lsinventory and list of patches applied in ORACLE_HOME

[oracle@rac8 OPatch]$ ./opatch lspatches

33515361;Database Release Update : 19.14.0.0.220118 (33515361)

29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)

OPatch succeeded.

Amit's Oracle DBA Blog

Disclaimer

Monday, 7 February 2022

Apply Patching 33515361 Oracle 19c Database Release Update 19.14.0.0.0

No comments:

Post a Comment

How to recovery PDB when PDB database is dropped in Oracle

Labels