In article <pan.2003.03.03.19.19.29.343435_at_yahoo.com.au>, howardjr2000
@yahoo.com.au says...
> On Sun, 02 Mar 2003 14:19:41 +0000, Preston Kemp wrote:
>
> > Hi all,
> >
> > I'm running 8.1.7 on Win2k. I've just installed OEM, but it's only
> > finding 1 of my 4 instances (they're all on the same server). I
> > installed the repository on 1 of the instances that isn't being found.
> > All 4 are in tnsnames.ora. I can still connect to all of them through
> > SQLPlus etc. Any ideas on how to make the other 3 appear?
>
> Yup: forget about the tnsnames.ora. Your problem is likely the
> listener.ora.
>
> For quirky reasons best known to itself, the Intelligent Agent that
> informs OEM about which databases are available to be managed isn't that
> intelligent, and simply runs off to the Listener and checks the SID_LIST
> in the listener.ora.
>
> If your databases aren't mentioned there (ie, declared statically) then
> the agent won't know about them.
>
> So: fix up your listener.ora by using the Network Configuration Manager to
> add the 3 other SIDs to the Listener's known database, and then re-start
> the Intelligent Agent. You should then be able to discover them all in
> OEM.
>
> By the way: just a tip. Instead of waiting to fire up OEM and run the
> discovery wizard, have a look in ORACLE_HOME/network/admin/agent for a
> file called services.ora. Open that up in a text editor, and see which
> SIDs are listed there. If they are in services.ora, OEM will be able to
> find them.
>
> Regards
> HJR
>
>
Brilliant, that's done the trick. Thanks Howard, you're a star!
--
Preston.
Received on Tue Mar 04 2003 - 12:16:51 CST
