Posts by Ramkumar M

EXPDP Hangs at Processing object type SCHEMA_EXPORT/STATISTICS/MARKER

We got a request to do a schema refresh, We prepared the parfile as below $cat DEV_SCHEMA.par  directory=MY_DIR dumpfile=DEV_SCHEMA_%u.dmp logfile=DEV_SCHEMA.log SCHEMAS=DEV_SCHEMA1,DECSCHEMA01 estimate=statistics parallel=8 filesize=2G and ran in background as $ nohup…

Read More

JSON_TABLE Query Fails with ORA-7445

Patch for  JSON_TABLE Query Fails with ORA-7445 [__intel_ssse3_rep_memcpy] (Doc ID 2311377.1) Prerequisite : Install OCT Patch : Patch 28662603 – Database Oct 2018 Release Update 12.2.0.1.181016 Make sure Database and listener are…

Read More

opatch prereq CheckConflictAgainstOHWithDetail Shows multiple HOME

When i got a request to apply a patch, i did a prereq check and faced the below error. RAM:oracle$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./ Oracle Interim Patch Installer version…

Read More