Re: Q: Using OEM to discover 2 databases on 1 server
From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Mon, 27 Feb 2006 00:19:51 +0100
Message-ID: <9qd402ljrolcub2ls96cngsgd6ed8j3vks_at_4ax.com>
Date: Mon, 27 Feb 2006 00:19:51 +0100
Message-ID: <9qd402ljrolcub2ls96cngsgd6ed8j3vks_at_4ax.com>
[Quoted] 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.
-- Sybrand Bakker, Senior Oracle DBAReceived on Mon Feb 27 2006 - 00:19:51 CET