Re: ORACLE_OCM USER
- From: Nagaraj S <nagaraj.chk@xxxxxxxxx>
- To: Stefan Knecht <knecht.stefan@xxxxxxxxx>
- Date: Thu, 12 Feb 2009 20:51:39 +0530
Thanks Stefan. The note is very usefull to me.
On Thu, Feb 12, 2009 at 6:59 PM, Stefan Knecht <knecht.stefan@xxxxxxxxx>wrote:
> See metalink note *736837.1
>
> Cheers
>
> Stefan
>
>
> *=========================
>
> Stefan P Knecht
> CEO & Founder
> s@xxxxxxxx
>
> 10046 Consulting GmbH
> Schwarzackerstrasse 29
> CH-8304 Wallisellen
> Switzerland
>
> Phone +41-(0)8400-10046
> Cell +41 (0) 79 571 36 27
> info@xxxxxxxx
> http://www.10046.ch
>
> =========================
>
>
>
> On Thu, Feb 12, 2009 at 2:22 PM, Nagaraj S <nagaraj.chk@xxxxxxxxx> wrote:
>
>> Hi Gurus,
>>
>> 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
>>
>
>
Other related posts:
