Results 1 to 6 of 6
  1. #1
    Join Date
    Oct 2003
    Posts
    93

    Unanswered: Oracle Client version in SQL Server

    We have Oracle Client installed in lot of our SQL Servers for Linked Servers.
    I can go to each SQL Server and check the Oracle Client version by running SQLPLUS or check under Providers for Linked Servers if OraOleDB.Oracle exists.
    There are more than 200 SQL Servers so the process is very tedious if done manually for each server.

    Iis there some query like @@version etc to find the Oracle Client Version ? Then I can put in a vbscript and run it across a list of SQL Servers.

    thanks in advance !!

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Did you try posting this question in the Oracle subforum?
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Oct 2003
    Posts
    93
    I have 4 Oracle DBA's in my Group. They couldn't answer it. .
    Its more of a SQL Server requirement. So I thought someone else have had this problem before.

  4. #4
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    You may need to develop a powershell script to go out, and check the version of an executable file (say sqlplus.exe).

  5. #5
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Another approach would be if you have SCCM, you may be able to have that run sqlplus -V on each machine, or just do a software inventory.

  6. #6
    Join Date
    Oct 2003
    Posts
    93
    I will try running sqlplus -V via vbscript.

    thanks

Posting Permissions

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