RE: Database Discovery Tool?

  • From: "Crisler, Jon" <Jon.Crisler@xxxxxxx>
  • To: <rjoralist@xxxxxxxxxxxxxxxxxxxxx>, <dofreeman@xxxxxxxxxxx>
  • Date: Mon, 5 Nov 2007 15:13:04 -0500

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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Rich Jesse
Sent: Monday, November 05, 2007 12:44 PM
To: dofreeman@xxxxxxxxxxx
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


Other related posts: