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

Home -> Community -> Usenet -> c.d.o.tools -> Enterprise Manager And LINUX

Enterprise Manager And LINUX

From: W. Marshall Cline <wmc_at_iref.org>
Date: Mon, 13 Aug 2001 17:15:11 GMT
Message-ID: <3B780AA9.A9957B1F@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 - 12:15:11 CDT

Original text of this message

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