Re: ORACLE_OCM USER
- From: Stefan Knecht <knecht.stefan@xxxxxxxxx>
- To: nagaraj.chk@xxxxxxxxx
- Date: Thu, 12 Feb 2009 14:29:16 +0100
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:
