Re: DB Instance Invisible in Oracle Management Server

Have you used the Navigate - Discover Node tool? (Can't remember the specific name off the top of my head right now, but it's close to that).

Although it says 'discover nodes', it actually discovers the databases on a specified node.

That tool only works if the Intelligent Agent on your box is running, too.

Oh, and the intelligent agent needs to have worked out what was created on the box: you may need to stop and re-start the agent service to get it to pick up on recently-created databases. You can always look in ORACLE_HOME\network\agent at a file called services.ora. If that mentions your three databases, then the agent is aware of them. And if the agent is aware of them, then a 'discover nodes' in OEM will get them listed.

Things get more interesting when your agent doesn't discover things, but I'll leave that for another day. Except to say that the agent finds out [Quoted] about things by parsing the listener.ora, and specifically looking for an explicit SID_LIST in the init.ora. If (unfortunately) you are relying *only* on dynamic instance regsitration with the Listener, then the agent won't discover what is running, services.ora won't list your databases, and 'discover nodes' will turn up empty-handed.

Regards
HJR "wang wei" <wang999wei_at_hotmail.com> wrote in message news:c1b90bbc.0301170246.45e9ed3b_at_posting.google.com...
> Hullo All,
>
> I created three database instances using Oracle Database
> Configuration Assistant on my local machine. None of them is visible
> when I connect to my Management Server installed on the same machine.
> However, the node (my machine), the data repository and the first
> database instatnce created during the installation are there. I'm
> using Windows 2000 SP3. Can anyone help? Thanks very much!
>
> WW
Received on Fri Jan 17 2003 - 21:01:49 CET