Re: Database Discovery Tool?

Congrats on the promo!

SQueaL Server's Enterprise Manager (2000) or Management Studio (2005) will be able to discover most servers for you. I believe the SS Browser service has to be active on each server for this to work, but don't quote me on that -- I'm newish to SQueaL Server.

For Oracle, unless you're using Grid Control and agents are deployed on every server, you may well be out of luck. You *may* be able portscan for every server in your organization (e.g. using "nmap") to determine if a listener is running. You could then attempt to tnsping those servers. YMMV

Just a thought or two. GL!

Rich

> Hi,
>
> I've just received a promotion and now have responsibility for all my
> organizations databases. Since the position was gapped for about 3
> months I am trying to find out what is out there. The list I have hasn't
> been updated in about 2 years. Is there a tool which I can deploy to
> find and report on servername and dbname? I need to do this both for
> Oracle and MS SQL. After that I'm starting on licenses.
>
> Don Freeman

--
http://www.freelists.org/webpage/oracle-l