Re: Q: Using OEM to discover 2 databases on 1 server

Thanks for the pointers! it worked. I put the updated information in appropriate files and changed to connection information in the tnsnames.ora file. Works great.

On Mon, 27 Feb 2006 00:19:51 +0100, Sybrand Bakker <gooiditweg_at_nospam.demon.nl> wrote:

>On Sun, 26 Feb 2006 09:37:41 +0000, Jim Smith
><jim_at_jimsmith.demon.co.uk> wrote:
>
>>I think there is also a problem in 9.2 where the agent can't find
>>instances unless they are in listener.ora. That is, it doesn't recognise
>>autoregistered instances. If Sybrand's suggestion doesn't work, do it
>>again, but add the instance to tnsnames.ora and restart the listener
>>before restarting the agent.
>
>Not quite. OIA won't recognise the service_name = syntax.
>Instances need to be in listener.ora with the connect_data=(sid=<sid>)
>syntax.
>Also OP may need to put the listener address in tnsnames.ora.