Objetct SYS.DBMS_MEMOPTIMIZE and SYS.DBMS_MEMOPTIMIZE_ADMIN is Invalid In PDB during MIGRATION (Doc ID 2894530.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

Objetct SYS.DBMS_MEMOPTIMIZE is invalid in PDB but is VALID on CDB.

  CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
  3 THAZY9U MIGRATE YES
SQL>
SQL> alter session set "_oracle_script"=true;

Session altered.

SQL> alter package SYS.DBMS_MEMOPTIMIZE compile package;

Warning: Package altered with compilation errors.

SQL> show errors;
No errors.
SQL> alter package SYS.DBMS_MEMOPTIMIZE_ADMIN compile package;

Warning: Package altered with compilation errors.

SQL> show errors;
No errors.

Incident dump trace file must show below details

LibraryHandle:  Address=0x6d0f9258 Hash=0 LockMode=X PinMode=X LoadLockMode=0 Status=VALD

          ObjectName:  Name=THAZY9U.SYS.DBMS_MEMOPTIMIZE_LIB 

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.