How To Find Oracle Client Version In Unix

1. How to find exact oracle version on oracle client

   Howdy,

   How tin can I discover the exact oracle version on the customer software. I would like to know if it is 8.1.7.3.0 or 8.1.seven.4.0 etc

   Here's the directories in that path

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

   I could non notice annihilation that would aid under lib

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

   Thanks
   Vj

   ---

2. Run up the installer and look at installed products?!

   Dime bars anyone...

   ---

3. flake similar an armadillo....

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

   ---

4. SAP kernel uses this oracle client. The oracle client is extracted/unpacked from the SAP website, that'southward how the client gets installed, so I cannot run the installer nor can invoke sqlplus.

   any ideas?

   ---

5. Originally posted by bazza
   Stitch the installer and look at installed products?!

   Dime confined anyone...

   I'one thousand not sure what they are, but if you could run one over that would be neat.
   I'm in Pittsburgh.

   Nugpot, I would guess that people don't patch Oracle clients very frequently, unless they need to for a specific effect. Have you looked in "C:\Programme Files\Oracle\Inventory\logs"?
   Otherwise you could merely ask the vendor.

   this space intentionally left bare

   ---

6. Originally posted by gandolf989
   Accept 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. 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 bare

   ---

8. Originally posted by gandolf989
   I'm not sure what they are, just if you lot could run one over that would be smashing.
   I'one thousand in Pittsburgh.
   

   Its a chocolate bar, smooth on the outside crisis on the inside (those in the UK at least volition remmeber the adverts for it)

   ---

9. Originally posted by davey23uk
   Its a chocolate bar, smooth on the exterior crunch on the within (those in the UK at least volition remmeber the adverts for it)

   Cool. Hopefully Bazza pops over with the Chocolate soon every bit I exit work in 30 minutes.

   this infinite intentionally left blank

   ---

10. Originally posted by Nugpot
    SAP kernel uses this oracle customer. The oracle client is extracted/unpacked from the SAP website, that'due south how the client gets installed, and then I cannot run the installer nor can invoke sqlplus.

    any ideas?

    If SAP, and so the oracle client is in relation with the SAP kernel. In additional, from the path itself, yes u are right that, we deceit determine.

    Even so, sm51, release info should exist able to provide u. Or other tcodes.

    Cheers

    ---

Source: https://www.dbasupport.com/forums/showthread.php?46643-How-to-find-exact-oracle-version-on-oracle-client

Posted by: hillneho1973.blogspot.com

Share this post