Re: ORACLE_OCM USER
- From: Nagaraj S <nagaraj.chk@xxxxxxxxx>
- To: Stefan Knecht <knecht.stefan@xxxxxxxxx>
- Date: Thu, 12 Feb 2009 23:56:04 +0530
Also is it possible to "turning off or disabling" the jobs/user
creation while applying the Quarterly CPU patched as it keep creating
ORACLE_OCM user.
Regards,
Naga
On Thu, Feb 12, 2009 at 8:51 PM, Nagaraj S <nagaraj.chk@xxxxxxxxx> wrote:
> 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:
