RE: Database Discovery Tool?

Be careful of running a portscan- Many companes have specific policy about that...failure to adhere to the policy could get you fired.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Rich Jesse Sent: Monday, November 05, 2007 12:44 PM To: dofreeman_at_state.pa.us
Cc: oracle-l
Subject: 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


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