Using Enterprise Manager 9.2 with a 10g database?

[Clive Backham]

Is there any way to get version 9.2.0.1.0 of Enterprise Manager
running in standalone mode to talk to a 10g database? Whenever I try
to connect, it says that "SELECT ANY DICTIONARY" must have been
granted. But the DBA has checked and I do have that capability.
Therefore I'm wondering if there's just something incompatible between
9.2 EM and a 10g database (actual version is 10.2.0.3.0).

I did download and attempt to install the 10g EM, but as well as the
installation failing at the 11th hour (one of the various
"recommended" configurations couldn't run), it installed a 10g
database and loads of services, and my poor little laptop (1.8GHz CPU,
1GB RAM) just collapsed under the strain.

[Matthias Hoys]

"Clive Backham" <goo...@delback.co.uk> wrote in message
news:1193850419....@d55g2000hsg.googlegroups.com...

I had the same problems, version 9 doesn't work with 10g. But I didn't have
any problems installing the 10g Java EM on Windows XP. You can of course
always use the webbased db control ...

Matthias

[Clive Backham]

On 31 Oct, 18:47, "Matthias Hoys" <a...@spam.com> wrote:
> I had the same problems, version 9 doesn't work with 10g. But I didn't have
> any problems installing the 10g Java EM on Windows XP.

Maybe I should just confirm that I was trying to install the correct
EM. the thing I downloaded was called "Enterprise Manager 10g Grid
Control Release 2 (10.2.0.2) for Microsoft Windows (32-bit)". The
download was 1,729,778,063 bytes. Is there a smaller version of the
10g EM that doesn't include so much stuff? (I only need a few things,
like schema and instance management).

[gazzag]

On 1 Nov, 09:39, Clive Backham <goo...@delback.co.uk> wrote:
> Maybe I should just confirm that I was trying to install the correct
> EM. the thing I downloaded was called "Enterprise Manager 10g Grid
> Control Release 2 (10.2.0.2) for Microsoft Windows (32-bit)". The
> download was 1,729,778,063 bytes. Is there a smaller version of the
> 10g EM that doesn't include so much stuff? (I only need a few things,
> like schema and instance management).

Why not run the web version of EM's Database Control?

-g

[Matthias Hoys]

"Clive Backham" <goo...@delback.co.uk> wrote in message

news:1193909968....@19g2000hsx.googlegroups.com...

You have to install the 10g stand-alone Enterprise Manager, not the Grid
Control. It's on the 10g client CD, just install the client and choose
"Administrator" during the install. Then you should have it in your start
menu.

Matthias

[Lodewicus Maas]

I'm not sure if this is a 9.2.0.1 thing, but I have the 9.2.0.7 patch
applied to my Oracle home, and connect successfully to all 10G databases
in our environment, as the system/????? user, which have dba rights. On
one database system did nto work, and I had to "grant all privileges to
system" from the sys user, to be able to get it working. I don't think
it's the code that's blocking you out, but rather more stringent grant
checking in the 10G source code

Lodewicus

[Clive Backham]

On 8 Nov, 09:30, Lodewicus Maas <linux.oracle....@googlemail.com>
wrote:

> I'm not sure if this is a 9.2.0.1 thing, but I have the 9.2.0.7 patch
> applied to my Oracle home, and connect successfully to all 10G databases
> in our environment, as the system/????? user, which have dba rights. On
> one database system did nto work, and I had to "grant all privileges to
> system" from the sys user, to be able to get it working. I don't think
> it's the code that's blocking you out, but rather more stringent grant
> checking in the 10G source code

Thanks for the tip. I'll try the 9.2.0.7 patch and see if it works.
(Now all I need to do is wait for my company's Oracle contact to get
back from leave so I can get the patch from Metalink... unless anyone
here knows somewhere else to download it?)