Re: Enterprise Manager on LINUX

I use Oracle 8i (81701) on Linux (a true bastard to get working properly). The basic OEM is available but tools like the tuning pack and are not available.

They are only available for Windoze NT and Solaris

Have fun

"Marty Grinstead" <marty_grinstead_at_hotmail.com> wrote in message news:2a%d7.25722$33.5394347_at_newsrump.sjc.telocity.net...
> Hi Tony,
>
> OEM 2.2 (8.1.7 database release) and OEM 9i both are available on Linux.
>
> As for the problem in the EMCA, you are running into a bug.
>
> The best solution is to let the EMCA create the user to be the repository
> owner. If you let the EMCA create the user, it will grant the necessary
> privileges to this user. You could grant the four system privileges to
the
> existing user (even if the user already has been granted the DBA role).
>
> Marty
>
> W. Marshall Cline <wmc_at_iref.org> wrote in message
> news:3B775448.EE015E38_at_iref.org...
> >
> > Can anyone please tell me if the OEM suite is available on LINUX? Last
> > time
> > I used it - a while ago - it was strictly NT.
> > Also, on a NT installation I am attempting now, with OEM 2.1, I
> > get this peculiar message when I try to create a repository in the
> > Configuration
> > Assistant (this is at the point where it asks you to log in as a user
> > with DBA
> > privileges):
> >
> > SQL exception encountered
> > Reason ORA-24347: Warning of a NULL column
> > in an aggregate function.
> >
> > /* OracleOEM */ select decode(count(*),4,1,0) from sys.dba_role_privs
> > r, sys.dba_sys_privs p where granted_role in ('CONNECT') and
> > default_role = 'YES' and privilege in ('CREATE TRIGGER','CREATE
> > PROCEDURE','EXECUTE ANY PROCEDURE','SELECT ANY TABLE') and r.grantee =
> > p.grantee
> > and r.grantee = 'REPO'
> >
> > where REPO is the user I've created. In a SQL window however, the
> > same query returns the correct value (4 which decodes to 1). What is
> > going on?
> >
> >
> > TIA,
> >
> > Tony
> >
>
>
Received on Thu Aug 23 2001 - 06:42:45 CEST