Category: Oracle Database

Significance of EVENT initialization parameter in Oracle 19c Database

~ aninditakar ~ Leave a comment

While upgrading Oracle E-Business Suite to R12.2.11, we faced an issue which highlights the aftermath of the “event” initialization parameter being absent at CDB level. sqlplus -s APPS/***** @/d01/apps/PDBSID/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql ‘/d01/apps/PDBSID/fs1/EBSapps/appl/xdp/12.0.0/patch/115/sql/XDPMIGFX.sql ‘ Connected. PL/SQL procedure successfully completed. DECLARE * ERROR at line 1: ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at … Continue reading Significance of EVENT initialization parameter in Oracle 19c Database

Oracle Database 19c pre-upgrade Checklist

~ aninditakar ~ Leave a comment

Every few years, organizations face the challenge of not only upgrading their databases from to long term release versions, but also to eliminate as much downtime as feasible, in the process. In this era when businesses are expected to provide uninterrupted services, an outage of any degree directly impacts their users and revenue.Taking advantage of … Continue reading Oracle Database 19c pre-upgrade Checklist