ORACLE_OCM USER

I installed Oracle 10g 10.2.0.1 , then installed patch set 2 (10.2.0.3) into that same ORACLE_HOME and did NOT enable OCM during the patch set installation. After applying CPU patch I have noticed ORACLE_OCM user has been created on my database.

Now there is the oracle_ocm account and scheduler jobs setup to gather information.

Apparently we have revoked the inherited privileges(EXECUTE privileges on UTL_FILE and DBMS_SCHEDULER) for ORACLE_OCM user, As part of it we get the following errors the alert_log indicating the lack of privileges.

ORA-12012: error on auto execute of job 52

ORA-04068: existing state of packages has been discarded

ORA-04063: package body "ORACLE_OCM.<package name>" has errors

ORA-06508: PL/SQL: could not find program unit being called

To resolve these errors, we must grant the missing EXECUTE privilege to the ORACLE_OCM user.

The big question is, how do I safely get rid of all OCM components? Also is it necessary to have ORACLE_OCM user created on db. Can I drop the user, If I drop will it impact any of my database components please suggest

Thanks in advance!

Regards,
Naga

--
http://www.freelists.org/webpage/oracle-l