Re: Oracbe 920 Server and Management Server: database recognition fails.

Two things:

Your listener.ora on the box where the true database resides MUST have the true database listed in its SID_LIST section. If you are only using automatic instance registration, it won't get discovered. Second, if you discover that the SID_LIST is missing it's easy enough to put back, but that requires a listener re-start. And if the listener gets restarted, you'll need to re-start the agent as well.

Incidentally, make friends with the ORACLE_HOME\network\agent directory. If the agent has trouble re-starting, delete all the '*.q' files in that directory before having another re-start attempt (they get created at agent startup). And also have a look inside the services.ora file in that directory: if the agent knows about databases, they are listed here. If they are listed in services.ora, then the Enterprise Manager discovery process will definitely discover them (ie, I find it quicker to check a text file than to launch the entire console wondering whether it will work this time!).

Regards
HJR "André Hartmann" <andrehartmann_at_hotmail.com> wrote in message news:3e3fa7d1$0$6081$af6e1991_at_news.completel.de...
> Hi,
>
> I have installed Oracle920 server on Windows 2000 and I run Oracle
> Management Server 920 on a different Windows2000 server. Now I added the
new
> node to the Management Server but it did not recognize the database
instance
> on the new computer (the database instance is running fine, I checked
that).
>
> Management Server only recognized the listener and the HTTP Server on
the
> new Oracle 920 Server computer. What can be wrong, can you help me ? I am
> lost...
>
> Thanks
>
> Andre
> :)
>
>
>
Received on Tue Feb 04 2003 - 12:30:08 CST