Home » Infrastructure » Unix » Checking Oracle Client Bit & Version (Solaris 8)
Checking Oracle Client Bit & Version [message #330275] Sat, 28 June 2008 13:23 Go to next message
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
Re: Checking Oracle Client Bit & Version [message #330276 is a reply to message #330275] Sat, 28 June 2008 13:49 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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.
Re: Checking Oracle Client Bit & Version [message #330313 is a reply to message #330311] Sun, 29 June 2008 06:25 Go to previous messageGo to next message
Michel Cadot
Messages: 57612
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
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!
Re: Checking Oracle Client Bit & Version [message #330358 is a reply to message #330313] Sun, 29 June 2008 21:20 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10613
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 Go to previous messageGo to next message
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 !
Re: Checking Oracle Client Bit & Version [message #330374 is a reply to message #330275] Sun, 29 June 2008 23:56 Go to previous messageGo to next message
savlon99
Messages: 22
Registered: June 2008
Location: Bangladesh
Junior Member

yes..that a copy past ..but he looking answer ..i m trying to remove his work for searching ...if it is not permited thn ...ok

Re: Checking Oracle Client Bit & Version [message #330380 is a reply to message #330374] Mon, 30 June 2008 00:42 Go to previous messageGo to next message
Michel Cadot
Messages: 57612
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
yes..that a copy past ..but he looking answer ..i m trying to remove his work for searching

This is what links are for.

Regards
Michel
Re: Checking Oracle Client Bit & Version [message #331202 is a reply to message #330275] Wed, 02 July 2008 10:08 Go to previous message
teeder44
Messages: 2
Registered: June 2008
Junior Member
Thanks for the information folks!


teeder44



Previous Topic: ORA-27102.(OUT OF MEMORY)
Next Topic: could not open connection to the host, on port 23 : connection failed
Goto Forum:
  


Current Time: Sat Apr 19 03:49:28 CDT 2014

Total time taken to generate the page: 0.14352 seconds