OraFAQ Forum: Unix » Checking Oracle Client Bit & Version

Home » Infrastructure » Unix » Checking Oracle Client Bit & Version (Solaris 8)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Checking Oracle Client Bit & Version [message #330275]

Sat, 28 June 2008 13:23

teeder44
Messages: 2
Registered: June 2008

Junior Member

Hi,

How do I check the version of the installed Oracle client on Solaris 8 or 9, and whether the Oracle client is 32 bit or 64 bit?

Thanks.

teeder44

Report message to a moderator

Re: Checking Oracle Client Bit & Version [message #330276 is a reply to message #330275]

Sat, 28 June 2008 13:49

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Sorry, overlooked that you were asking about client software. For client software, go into $ORACLE_HOME and if you see a lib32 AND lib directory, then you have 64bit software. If the lib directory is the ONLY one there, then you have 32bit software.

[Updated on: Sat, 28 June 2008 14:14]

Report message to a moderator

Re: Checking Oracle Client Bit & Version [message #330311 is a reply to message #330275]

Sun, 29 June 2008 05:55

savlon99
Messages: 22
Registered: June 2008
Location: Bangladesh

Junior Member

How to Identify OS or Oracle 64 bit or 32 bit on Unix
---------------------------------------------------------------
It is very common question which version of oracle I need to install. 32 bit or 64 bit? As a 64-bit operating system can support either a 32-bit database or a 64-bit database. A 32-bit operating system cannot support a 64-bit database. So, version identification of the OS is necessary prior to install oracle. The following procedure will hopefully help you.

Check whether OS is 64 bit or 32 bit.
-----------------------------------------
On Solaris,

SQL> !/usr/bin/isainfo -kv
64-bit amd64 kernel modules

SQL> !/usr/bin/isainfo -v
64-bit amd64 applications
cx16 mon sse3 pause sse2 sse fxsr mmx cmov amd_sysc cx8 tsc fpu
32-bit i386 applications
cx16 mon sse3 pause sse2 sse fxsr mmx cmov sep cx8 tsc fpu

This output tells us that solaris operating systems allow co-existence of 32-bit and 64-bit files.

On AIX,
$ getconf -a | grep KERN
$ file /usr/lib/boot/unix*
On Linux,

On HP-UX,
/usr/bin/ getconf KERNEL_BITS
/usr/bin/file /stand/vmunix

On linux,

$uname -a
Linux debian 2.6.18-4-686 #1 SMP Wed May 9 23:03:12 UTC 2007 i686 GNU/Linux

If the output is x86_64 then 64-bit and i686 or similar for 32-bit.

On windows,

Start>All Programs>accessories> System Tools>System Information>look for under System summary.

Or start>run>dixdiag>Then check for WHQL digital signature.

Determine of whether Oracle Software is 32 bit or 64 bit.
--------------------------------------------------------------------------------
Method 1:
--------------
Go to $ORACLE_HOME/bin and see.

# cd $ORACLE_HOME/bin
# file oracle
oracle: ELF 64-bit LSB executable AMD64 Version 1, dynamically linked, not stripped

Here it comes 64 bit and hence oracle software is 64 bit. If the output of the "file oracle" command does not say 64-bit explicitly then you are running 32-bit Oracle.

If you had 32 bit oracle software installed then output will be like,

oracle@sol:/db/oracle/bin$ file oracle
oracle: setuid setgid ELF 32-bit LSB executable, Intel 80386, version 1 (SYSV), dynamically linked (uses shared libs), not stripped

Method 2:
----------------------
Log on to SQL*plus and see the banner.

-bash-3.00$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.2.0 - Production on Thu May 15 02:50:37 2008

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options

Method 3:Query from v$version.
-------------------------------------
sys@THERAP> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Prod
PL/SQL Release 10.2.0.2.0 - Production
CORE 10.2.0.2.0 Production
TNS for Solaris: Version 10.2.0.2.0 - Production
NLSRTL Version 10.2.0.2.0 - Production

Method 4: Check for lib, lib32
--------------------------------------

1) $ORACLE_HOME/lib32
2) $ORACLE_HOME/lib

If the two directories $ORACLE_HOME/lib32 and $ORACLE_HOME/lib are existing then it is 64 bit.

If there is only an ORACLE_HOME/lib directory then it is 32 bit client.

Report message to a moderator

Re: Checking Oracle Client Bit & Version [message #330313 is a reply to message #330311]

Sun, 29 June 2008 06:25

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

This a copy and paste of Arju's article at http://www.orafaq.com/node/2033

What a contemptible way to appropriate others' work.
I'm disgusted by this behaviour.
The only thing you win with this post is my deep scorn.
Read http://www.orafaq.com/forum/t/120989/102589/

Regards
Michel

[Updated on: Sun, 29 June 2008 06:26]

Report message to a moderator

Re: Checking Oracle Client Bit & Version [message #330329 is a reply to message #330311]

Sun, 29 June 2008 12:30

ebrian
Messages: 2794
Registered: April 2006

Senior Member

It's amazing how hard pressed folks are for recognition/attention. First off, the OP indicated they were on Solaris, why is it necessary to list AIX, HP-UX, Windows etc. platforms? In addition, the OP indicated they wanted to know the Oracle client version NOT version of O/S or Oracle server version.

I guess it comes down to what Michel already pointed out, it was easier to simply do a FULL cut & paste from another's website.

Michel Cadot wrote on Sun, 29 June 2008 07:25

What a contemptible way to appropriate others' work.
I'm disgusted by this behaviour.
The only thing you win with this post is my deep scorn.

I absolutely concur with Michel's sentiments!

Report message to a moderator

Re: Checking Oracle Client Bit & Version [message #330358 is a reply to message #330313]

Sun, 29 June 2008 21:20

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>This a copy and paste of Arju's article at http://www.orafaq.com/node/2033
Which ***seems*** to be an amalgamation of metalink notes 421453.1 and 434295.1.
Well, as I already stated in the other thread,
some code is generic. Only a few methods exists in certain cases.
But does the comments/prose and sequence of commands would be the same?
From the original article

If the two directories $ORACLE_HOME/lib32 and $ORACLE_HOME/lib are existing then it is 64 bit.

If there is only an ORACLE_HOME/lib directory then it is 32 bit client.

From metalink note 434295.1

If the two directories $ORACLE_HOME/lib32 and $ORACLE_HOME/lib are existing then it is 64 bit client.
If there is only an ORACLE_HOME/lib directory then it is 32 bit client.

[Updated on: Sun, 29 June 2008 21:25]

Report message to a moderator

Re: Checking Oracle Client Bit & Version [message #330360 is a reply to message #330358]

Sun, 29 June 2008 22:09

ebrian
Messages: 2794
Registered: April 2006

Senior Member

I've seen quite a few articles on Arju's website that are a direct cut & paste from other's responses/code on orafaq forums (compare this to this). As Mahesh indicated in another thread, although plagiarism from a public forum would not typically be construed as a violation of intellectual property, at the very least it shows lack of forum etiquette, lack of RESPECT and calls into question one's status of Moderator on a forum !

Report message to a moderator