Re: Get list of databases

Robert,

I don't know if a way exists. First, I don't know .NET, but I do have some limited Oracle knowledge. My answer is from an Oracle perspective (not .NET), maybe Microsoft did some cool coding and has what you desire.

Oracle doesn't offer "straight forward" method. Oracle listeners / servers do NOT have to register themselves in a centralized area on a network. Several of my clients use procedures to help with the process. In the end, a web page lists each database and its "current status" (as of 5-10 minutes ago).

One of my clients had a problem with over 30 Oracle servers running. I installed Oracle centralized naming (ONAMES) for them. In the end, we ended up registering with ONAMES only the production servers and testing servers. The developer servers didn't get into the list.

You might want to look at:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndotnet/ht ml/manprooracperf.asp It does NOT answer your question directly, though. I'm not a Microsoft expert but (it seems to me) .NET is depending upon Oracle networking to make the final connection.

One method to centralize your Oracle servers using Oracle networking is ONAMES. To get the .NET interface you desire might still require some local coding. It certainly will require procedures to keep ONAMES up to date.

This doesn't mean what you desire doesn't exist. I just don't know about it after 5 years of Oracle experience and passing my 8i and 9i certification tests.

Please let me know what you discover / decide.

Bertram Moshier
Oracle Certified Professional 8i and 9i DBA

http://www.bmoshier.net/bertram

"Robert Vabo" <rvabo_at_msn.com> wrote in message news:3ddb83a0_at_news.wineasy.se...
> How can I use .NET to retrieve a list of all Oracle services on my network
?
> --
> Regards
> Robert Vabo
> Gecko AS
> www.gecko.no
>
>
Received on Wed Nov 20 2002 - 18:41:22 CET