How to find exact oracle version on oracle client
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: How to find exact oracle version on oracle client

  1. #1
    Join Date
    Feb 2001
    Posts
    128

    How to find exact oracle version on oracle client

    Hi,

    How can I find the exact oracle version on the client software. I would like to know if it is 8.1.7.3.0 or 8.1.7.4.0 etc

    Here's the directories in that path

    % pwd
    /oracle/client/81x_64
    % ls
    jdbc lib ocommon

    I could not find anything that would help under lib

    % cd lib
    % ls
    libclntsh.so libclntsh.so.8.0 libocijdbc8.so libocijdbc8_g.so libwtc8.so

    Thanks
    Vj

  2. #2
    Join Date
    Jul 2002
    Posts
    335
    Run up the installer and look at installed products?!

    Dime bars anyone...

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    bit like an armadillo....


    anyway, launch the client and it will tell you the version

  4. #4
    Join Date
    Feb 2001
    Posts
    128
    SAP kernel uses this oracle client. The oracle client is extracted/unpacked from the SAP website, that's how the client gets installed, so I cannot run the installer nor can invoke sqlplus.

    any ideas?

  5. #5
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,997
    Originally posted by bazza
    Run up the installer and look at installed products?!

    Dime bars anyone...
    I'm not sure what they are, but if you could run one over that would be great.
    I'm in Pittsburgh.

    Nugpot, I would guess that people don't patch Oracle clients very often, unless they need to for a specific issue. Have you looked in "C:\Program Files\Oracle\Inventory\logs"?
    Otherwise you could just ask the vendor.
    this space intentionally left blank

  6. #6
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by gandolf989
    Have you looked in "C:\Program Files\Oracle\Inventory\logs"?
    Ahem... Isn't it obvious he uses some variant of unix?
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  7. #7
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,997
    Originally posted by jmodic
    Ahem... Isn't it obvious he uses some variant of unix?
    It was obvious. Whoops, my bad.

    What about looking at "$ORACLE_BASE/oraInventory/logs"?
    this space intentionally left blank

  8. #8
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    Originally posted by gandolf989
    I'm not sure what they are, but if you could run one over that would be great.
    I'm in Pittsburgh.
    Its a chocolate bar, smooth on the outside crunch on the inside (those in the UK at least will remmeber the adverts for it)

  9. #9
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,997
    Originally posted by davey23uk
    Its a chocolate bar, smooth on the outside crunch on the inside (those in the UK at least will remmeber the adverts for it)
    Cool. Hopefully Bazza pops over with the Chocolate soon as I leave work in 30 minutes.
    this space intentionally left blank

  10. #10
    Join Date
    Oct 2002
    Posts
    391
    Originally posted by Nugpot
    SAP kernel uses this oracle client. The oracle client is extracted/unpacked from the SAP website, that's how the client gets installed, so I cannot run the installer nor can invoke sqlplus.

    any ideas?
    If SAP, then the oracle client is in relation with the SAP kernel. In additional, from the path itself, yes u are right that, we cant determine.


    However, sm51, release info should be able to provide u. Or other tcodes.

    Cheers

Posting Permissions

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



Click Here to Expand Forum to Full Width