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
Received on Thu Jul 06 2000 - 16:19:03 CDT
