Error: ORA-04063
OEM Error when assigning an email id to SYS user:
Internal error. ORA-04063: package body "SYSMAN.EMD_NOTIFICATION" has errors ORA-06508: PL/SQL: could not find program unit being called: "SYSMAN.EMD_NOTIFICATION" ORA-06512: at "SYSMAN.MGMT_PREFERENCES", line 1536 ORA-06512: at line 1
Cause:
Oracle policy recommends taking away the execute privilege on UTL_SMTP from PUBLIC. This takes away the privileges from SYSMAN as well. SYSMAN needs execute on UTL_SMTP and UTL_TCP to send notifications.
Workaround:
1. Log into the repository database as sys:
grant execute on sys.utl_smtp to sysman; grant execute on sys.utl_tcp to sysman;
2. Compile:
alter package sysman.emd_notification compile;
References: