Results 1 to 6 of 6
  1. #1
    Join Date
    Aug 2009
    Posts
    8

    Unanswered: Discover Oracle on Network

    Hi, I have a large estate of Oracle and SQL Server to manage, I can discover the SQL stuff fairly well via the OSQL -l command that returns a list of SQL installations from the network, its not perfect but I cant find an equivalent for Oracle, ok I know most of it but I want to spt those old dev servers hanging around or whether someone has installed Oracle databases on a client machine !

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    I am unaware of any Oracle s/w which does what you desire

    >whether someone has installed Oracle databases on a client machine
    I run Oracle RDBMS on my laptop without the listener.
    The only way you'd know it was on my laptop would be to actually logon & issue some OS commands looking for typical Oracle files.

    I really don't think that any sort of actual inventory would be worth the time it would take to research & record results.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Nov 2003
    Posts
    2,934
    Provided Answers: 12
    Quote Originally Posted by anacedent
    I run Oracle RDBMS on my laptop without the listener.
    And even if you did, you could have a firewall that prevented connections to it from the outside.

    but I want to spt those old dev servers hanging around
    You could try to telnet to the default port but that won't discover those installations that are using a different port.

    I don't think there is a sure-fire way to identify an Oracle installation from the "outside"

  4. #4
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    If you have SMS on the network, you can get SMS to report on the existence, or non-existence of a particular file. Some DLL from the Oracle installation directory should do. Won't help much for *NIX machines, though.

  5. #5
    Join Date
    Feb 2009
    Posts
    62
    That just leaves you the problem of finding where Oracle might have been installed on a given box.

  6. #6
    Join Date
    Aug 2009
    Posts
    8
    I asked our Marimba (SMS type thing) administrator to provide a list, looks quite useful and has turned up some suprises but its quite a manual process to go through them now.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •