I recently had to face such a problem. For those who give up, the answer is below 🙂 exec dbms_Stats.gather_schema_stats(‘TESTSCHEMA’); ERROR at line 1:ORA-20000: Schema ” TESTSCHEMA” does not exist or insufficient privilegesORA-06512: at “SYS.DBMS_STATS”, line 38330ORA-06512: at “SYS.DBMS_STATS”, line 38289ORA-06512: at “SYS.DBMS_STATS”, line 8593ORA-06512: at “SYS.DBMS_STATS”, line 38172ORA-06512: at “SYS.DBMS_STATS”, line 38317ORA-06512: at line […]

Sub Title: Step-by-Step Guide: Applying Update 17 Patch on Oracle Enterprise Manager Cloud Control 13.5 Software Reference: Cloud Control Advanced Installation and Configuration Guide We previously had an infrastructure running Oracle Enterprise Manager Cloud Control 13.2 version on Solaris OS. Upon upgrading our database version from 12 to 19c, we encountered numerous errors due to […]