Re: Enterprise Manager on LINUX

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 Mon Aug 13 2001 - 23:29:42 CEST