Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to find version and arch of Oracle client installed

iinfiFeb 21 2011 — edited Oct 18 2011
Hi all

I have sles 10 sp2 x86_64 on which oracle client 10.2 is installed. this installation was not done by me!
so i dont know what version/architecture (32/64 bit) mode of the oracle client is installed on the client.

from sqlplus -V i get only the version which is installed and not whether it is 32 or 64 bit. how can i find that out.

sqlplus -V
SQL*Plus: Release 10.2.0.1.0 - Production

with a bit of googling i found only the below link which says 10g client 32-bit cannot be installed on a 64 bit system.

i read this Installing 32-bit RDBMS Client software on x86_64 Linux. [ID 1075717.1]
Installing 32-bit RDBMS Client software on x86_64 Linux.
The only release of 32-bit RDBMS Client software that will properly install on an x86_64 Linux OS system is 11gR2 (aka 11.2.0.x)

    * 9iR2 (aka 9.2.0.x) 32-bit RDBMS Client software will NOT install on any x86_64 Linux OS system.
    * 10gR1 (aka 10.1.0.x) 32-bit RDBMS Client software will NOT install on any x86_64 Linux OS system.
    * 10gR2 (aka 10.2.0.x) 32-bit RDBMS Client software will NOT install on any x86_64 Linux OS system.
    * 11gR1 (aka 11.1.0.x) 32-bit RDBMS Client software will NOT install on any x86_64 Linux OS system.

The answer to "why", is that the 11gR2 Client software is the first version that includes syntax so that a 32-bit object is linked.
can someone please throw more light on this?
This post has been answered by ora_tech on Feb 21 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 15 2011
Added on Feb 21 2011
6 comments
17,878 views