While upgrading the Enforce system of DLP from 14.0.x to 14.5, 14.6, 15.0, 15.1 the upgrader fails just after the pre-checks complete. The sql_error.txt log file indicates it failed at step: Drop Foreign Keys.
TASK_ID : 3
TASK_NAME : Drop Foreign Keys
BATCH_NUM : 1
ERROR_TYPE : FATAL
ERRANT_STMT :
ERROR : ORA-06508: PL/SQL: could not find program unit being called
Additonally check %Oracle_Home%/diag/rdmbs/<instance>/trace/<instance>_ora_####.trc file for the following error
ORA-00600: internal error code, arguments: [KGL-heap-size-exceeded]. This should also exist in the oracle alert log.
PGA_AGGREGATE_LIMIT Should be set to either 0 or a limit set by an Oracle DBA. Setting this to 0 will allow Oracle to adjust this size automatically as needed, while we have Automatic Memory Management enabled.
Before you perform any of the below activities on your DB, perform a backup of your DB (your DLP database install/upgrade guide will have specific backup instructions)
If you have any reservations or questions about this process, please contact your Symantec Technical Support team.
To display the current value of the PGA_AG parameters, log into oracle as the protect user
Run the following command to show the parameters:
show parameter pga_ag
The output should look something like this:
PGA_AGGREGATE_TARGET is the parameter that can prevent the upgrade from completing.
Set the it to '0' or at a level deemed appropriate by the DBA, generall between 10B and 4G -1.
alter system set pga_aggregate_target=0 scope=both;
If the DBA wishes to revert the pga_aggregate_target value to its previous values after the upgrade is complete, they can do so. But please note these steps may need to be repeated if another upgrade is performed.
Set PGA_AGGREGATE_TARGET to '0' or at a level deemed appropriate by the DBA through the spfile.
conn / as sysdba
SQL> CREATE PFILE=’D:\oracle\product\11.2.0.4\db_1\database\PFILEPROTECT.ORA’ FROM SPFILE;
SQL> SHUTDOWN IMMEDIATE
SQL> STARTUP FORCE PFILE=’D:\oracle\product\11.2.0.4\db_1\database\PFILEPROTECT.ORA’
SQL> SHOW PARAMETER PGA_AGGREGATE_TARGET
SQL> SHUTDOWN IMMEDIATE
SQL> CREATE SPFILE=’D:\oracle\product\11.2.0.4\db_1\database\SPFILEPROTECT.ORA’ FROM PFILE=’D:\oracle\product\11.2.0.4\db_1\database\PFILEPROTECT.ORA’;
SQL> STARTUP
SQL> SHOW PARAMETER PGA_AGGREGATE_TARGET