Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: OEM Configuration(privs error)

Re: OEM Configuration(privs error)

From: ARUN K C <arun_k_c_at_hotmail.com>
Date: Thu, 06 Jul 2000 15:30:48 PDT
Message-Id: <10550.111376@fatcity.com>


can run on the same place where the database is running or on the client machine from which you login to the repository database

>From: Eric Fang <eric_fang_at_yahoo.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: OEM Configuration(privs error)
>Date: Thu, 06 Jul 2000 14:25:21 -0800
>
>Thank you all for the reply. One of the error is the
>user I used already existed, if I start with a new
>user , it's ok. My next question is, how to set the
>management server? Do I have to set OEM on the same
>machine as the Database Server?
>
>Thanks,
>
>Eric Fang
>
>--- ARUN K C <arun_k_c_at_hotmail.com> wrote:
> > if you are using oem configuration assistant then
> > you can login as sy and
> > create a new user with a different tablespace to
> > choose also
> > This I have done it and is working fine in my sun
> > solaris and nt operating
> > system
> > Well if you are going to manually going to create
> > the repository then yes
> > you will have to grant all the privilages which the
> > oem repository needs
> >
> >
> >
> > >From: "A. Bardeen" <abardeen1_at_yahoo.com>
> > >Reply-To: ORACLE-L_at_fatcity.com
> > >To: Multiple recipients of list ORACLE-L
> > <ORACLE-L_at_fatcity.com>
> > >Subject: Re: OEM Configuration(privs error)
> > >Date: Thu, 06 Jul 2000 06:05:26 -0800
> > >
> > >Eric,
> > >
> > >GRANT "CONNECT" TO "your_user";
> > >ALTER USER "your_user" DEFAULT ROLE ALL
> > >GRANT CREATE PROCEDURE TO "your_user";
> > >GRANT CREATE TRIGGER TO "your_user";
> > >GRANT EXECUTE ANY PROCEDURE TO "your_user";
> > >GRANT SELECT ANY TABLE TO "your_user";
> > >
> > >Note, the user must have these privileges granted
> > >explicitly, not through a role (e.g. DBA)
> > >
> > >See the following doc on MetaLink for more details:
> > >
> > >Note 108063.1 - "Existing user Lacks privileges or
> > >roles when creating OEM 2.1 repository"
> > >
> > >BTW, it is not recommended to use INTERNAL/SYS as
> > the
> > >OEM repository owner as this creates the OEM
> > >repository in the system tablespace.
> > >
> > >HTH,
> > >
> > >-- Anita
> > >
> > >--- ARUN K C <arun_k_c_at_hotmail.com> wrote:
> > > > I dont about hpw but one way which I have done
> > is
> > > > logged in as sys and then
> > > > create then create the repository user, this is
> > > > working fine on Sun and NT,
> > > > did you try logging in as sys
> > > >
> > > >
> > > > >From: Eric Fang <eric_fang_at_yahoo.com>
> > > > >Reply-To: ORACLE-L_at_fatcity.com
> > > > >To: Multiple recipients of list ORACLE-L
> > > > <ORACLE-L_at_fatcity.com>
> > > > >Subject: OEM Configuration(privs error)
> > > > >Date: Wed, 05 Jul 2000 17:04:56 -0800
> > > > >
> > > > >I just downloaded the lastest OEM2.1 from
> > technet.
> > > > But
> > > > >I got an error when try to run a configuration
> > > > >assistant at step 3 of 5: the user lacks one or
> > > > more
> > > > >of the privileges or roles required to create
> > and
> > > > >support a management server repository.
> > > > >What kinda privs does should this user have? (I
> > > > >granted DBA and sysadmin to this user).
> > > > >Also any idea or docs on hpw to configure the
> > > > >management server? Thanks in Advance.
> > > > >
> > > > >Eric Fang
> > > > >
> > > >
> > >__________________________________________________
> > > > >Do You Yahoo!?
> > > > >Send instant messages & get email alerts with
> > > > Yahoo! Messenger.
> > > > >http://im.yahoo.com/
> > > > >--
> > > > >Author: Eric Fang
> > > > > INET: eric_fang_at_yahoo.com
> > > > >
> > > > >Fat City Network Services -- (858) 538-5051
> > > > FAX: (858) 538-5051
> > > > >San Diego, California -- Public Internet
> > > > access / Mailing Lists
> > > >
> > >
> >
> >--------------------------------------------------------------------
> > > > >To REMOVE yourself from this mailing list, send
> > an
> > > > E-Mail message
> > > > >to: ListGuru_at_fatcity.com (note EXACT spelling
> > of
> > > > 'ListGuru') and in
> > > > >the message BODY, include a line containing:
> > UNSUB
> > > > ORACLE-L
> > > > >(or the name of mailing list you want to be
> > removed
> > > > from). You may
> > > > >also send the HELP command for other
> > information
> > > > (like subscribing).
> > > >
> > > >
> >
> >________________________________________________________________________
> > > > Get Your Private, Free E-mail from MSN Hotmail
> > at
> > > > http://www.hotmail.com
> > > >
> > > > --
> > > > Author: ARUN K C
> > > > INET: arun_k_c_at_hotmail.com
> > > >
> > > > Fat City Network Services -- (858) 538-5051
> > FAX:
> > > > (858) 538-5051
> > > > San Diego, California -- Public Internet
> > > > access / Mailing Lists
> > > >
> >
> >--------------------------------------------------------------------
> > > > To REMOVE yourself from this mailing list, send
> > an
> > > > E-Mail message
> > > > to: ListGuru_at_fatcity.com (note EXACT spelling of
> > > > 'ListGuru') and in
> > > > the message BODY, include a line containing:
> > UNSUB
> > > > ORACLE-L
> > > > (or the name of mailing list you want to be
> > removed
> > > > from). You may
> > > > also send the HELP command for other information
> > > > (like subscribing).
> > >
> > >
> > >__________________________________________________
> > >Do You Yahoo!?
> > >Send instant messages & get email alerts with
> > Yahoo! Messenger.
> > >http://im.yahoo.com/
> > >--
> > >Author: A. Bardeen
> > > INET: abardeen1_at_yahoo.com
> > >
> > >Fat City Network Services -- (858) 538-5051
> > FAX: (858) 538-5051
> > >San Diego, California -- Public Internet
> > access / Mailing Lists
> >
> >--------------------------------------------------------------------
> > >To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > >to: ListGuru_at_fatcity.com (note EXACT spelling of
> > 'ListGuru') and in
> > >the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > >(or the name of mailing list you want to be removed
> > from). You may
> > >also send the HELP command for other information
> > (like subscribing).
> >
> >
>________________________________________________________________________
> > Get Your Private, Free E-mail from MSN Hotmail at
> > http://www.hotmail.com
> >
> > --
> > Author: ARUN K C
> > INET: arun_k_c_at_hotmail.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX:
> > (858) 538-5051
> > San Diego, California -- Public Internet
> > access / Mailing Lists
> >
>--------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be removed
> > from). You may
> > also send the HELP command for other information
> > (like subscribing).
>
>
>__________________________________________________
>Do You Yahoo!?
>Send instant messages & get email alerts with Yahoo! Messenger.
>http://im.yahoo.com/
>--
>Author: Eric Fang
> INET: eric_fang_at_yahoo.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
Received on Thu Jul 06 2000 - 17:30:48 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US