I was trying to configure DataPurge database components(BPMS free trail 10.1 on windows). But got the following error.
CREATE DATABASEMANAGEMENT [25.0] FAILED
CDC ERROR [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-04063: package body “IBO_BAM.OPERATION_MGMT” has errors
ORA-06508: PL/SQL: could not find program unit being called: “IBO_BAM.OPERATION_MGMT”
ORA-06512: at “IBO_BAM.SWAPOPS”, line 1880
ORA-06512: at line 6
Anybody faced the above issue ? any solution/suggestions?
Im searching for 10.1 fixes , If I find any solution I will post here.
solved the issue after granting the access to utl_smtp package.
grant execute on sys.utl_smtp to ibo_bam;
this works for most components which contain this package except for Optimize.
For Optimize there additional SYS-Grants needed:
- GRANT EXECUTE ON SYS.DBMS_ALERT TO &user;
- GRANT EXECUTE ON SYS.DBMS_JOB TO &user;
- GRANT EXECUTE ON SYS.PLITBLM TO &user;
- GRANT SELECT ON SYS.V_$PARAMETER TO &user;
Remember to re-apply the creation script from DB Configurator after that to complete the creation for Optimize related tables.
This issue occurs when users are created with SYSTEM user instead of SYS as SYSTEM is not allowed to set grants for SYS-Objects.
Latest DB-Scipts Fix for 10.1 is DC_10.1_DBS_Fix3.
Holger, Thanks for the replay. Its really useful.