Re: Database Discovery Tool?
- From: "Rich Jesse" <rjoralist@xxxxxxxxxxxxxxxxxxxxx>
- To: dofreeman@xxxxxxxxxxx
- Date: Mon, 5 Nov 2007 11:44:02 -0600 (CST)
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
