Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Enterprise Manager And LINUX
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
![]() |
![]() |