Home » SQL & PL/SQL » Client Tools » Client Sql*Plus version
Client Sql*Plus version [message #596836] Thu, 26 September 2013 11:33 Go to next message
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
Senior Member
hello guys,
greetings.i need to know my Oracle client version whether it is of 32-bit or 64-bit.

Microsoft Windows [Version 6.0.6002]
Copyright (c) 2006 Microsoft Corporation.  All rights reserved.

C:\>sqlplus -v

SQL*Plus: Release 10.2.0.1.0 - Production


C:\>


it shows me only version not bit information.
is there any other command to get it.
your help will be appreciated great.
thanks in advance.......
Re: Client Sql*Plus version [message #596839 is a reply to message #596836] Thu, 26 September 2013 11:47 Go to previous messageGo to next message
BlackSwan
Messages: 23159
Registered: January 2009
Senior Member
GOOGLE is your friend, but only when you actually use it

http://blogs.technet.com/b/windowshpc/archive/2009/03/27/how-to-tell-if-a-exe-file-is-a-32-bit-or-64-bit-application-using-dumpbin.as px
icon14.gif  Re: Client Sql*Plus version [message #596840 is a reply to message #596836] Thu, 26 September 2013 11:56 Go to previous messageGo to next message
Michel Cadot
Messages: 60016
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
E:\>dumpbin /headers %ORACLE_HOME%\bin\sqlplus.exe
Microsoft (R) COFF Binary File Dumper Version 6.00.8168
Copyright (C) Microsoft Corp 1992-1998. All rights reserved.
<...>
FILE HEADER VALUES
             14C machine (i386)
<...>
                   32 bit word machine
<...>

You have dumpbin.exe if you have any version of Visual Studio or you can download it there or there or there.

[Updated on: Thu, 26 September 2013 11:57]

Report message to a moderator

Re: Client Sql*Plus version [message #596855 is a reply to message #596836] Thu, 26 September 2013 13:41 Go to previous messageGo to next message
Lalit Kumar B
Messages: 2544
Registered: May 2013
Location: World Wide on the Web
Senior Member
neetesh87 wrote on Thu, 26 September 2013 22:03

greetings.i need to know my Oracle client version whether it is of 32-bit or 64-bit.



Issue this statement -

SQL> select distinct address from v$sql where rownum<2;

ADDRESS  
-------- 
285B4CC4 

1 rows selected


If you see a 8 byte address it is a 32 bit installation, but if you see a 16 byte address it is a 64bit installation. In the example code demonstrated above, it is a 32-bit installation.

Similar OTN forum question has been answered

Regards,
Lalit
icon13.gif  Re: Client Sql*Plus version [message #596859 is a reply to message #596855] Thu, 26 September 2013 15:00 Go to previous messageGo to next message
Michel Cadot
Messages: 60016
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
SQL> select distinct address from v$sql where rownum<2;


This is the SERVER installation NOT the CLIENT one.

[Updated on: Thu, 26 September 2013 15:01]

Report message to a moderator

Re: Client Sql*Plus version [message #596862 is a reply to message #596859] Thu, 26 September 2013 15:20 Go to previous messageGo to next message
Lalit Kumar B
Messages: 2544
Registered: May 2013
Location: World Wide on the Web
Senior Member
Oops, yes correct Michel. Address attribute of v$sql will give that of server's and NOT client's. My bad.

So, let me correct myself with a helpful post from Arju's blog - How to Identify OS or Oracle 64 bit or 32 bit

Which I actually found from this thread.

I don't know why, whenever I want to post metalink notes, I refrain myself, since I don't know whether it is OK to do in the forums.

Regards,
Lalit
Re: Client Sql*Plus version [message #596863 is a reply to message #596862] Thu, 26 September 2013 15:22 Go to previous messageGo to next message
Littlefoot
Messages: 19893
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
There's no problem in posting links to Metalink documents, but you shouldn't post documents themselves.
Re: Client Sql*Plus version [message #596894 is a reply to message #596863] Fri, 27 September 2013 05:18 Go to previous messageGo to next message
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
Senior Member
thanks a lot guys for your kind response.
but i tried after installing dumpbin :
C:\>dumpbin/headers D:\oracle\product\10.2.0\client_1\BIN\sqlplus.exe
'dumpbin' is not recognized as an internal or external command,
operable program or batch file.

C:\>


am i missing anything?
or is there any way to find out?

thanks....
Re: Client Sql*Plus version [message #596895 is a reply to message #596894] Fri, 27 September 2013 05:31 Go to previous messageGo to next message
gazzag
Messages: 388
Registered: November 2010
Location: Bristol, UK
Senior Member
dumpbin.exe is not included in a standard Windows install. I believe it comes with Visual Studio.
Re: Client Sql*Plus version [message #596896 is a reply to message #596894] Fri, 27 September 2013 05:32 Go to previous messageGo to next message
ThomasG
Messages: 3123
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Yes, you missed the sentence Michels wrote after the part you just have run.

Re: Client Sql*Plus version [message #596901 is a reply to message #596896] Fri, 27 September 2013 06:23 Go to previous messageGo to next message
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
Senior Member
thanks for your kind response mr. ThomasG

i execute above statement after downloading and executing dumpbin.exe but it couldn't help

thanks.....
Re: Client Sql*Plus version [message #596903 is a reply to message #596901] Fri, 27 September 2013 06:33 Go to previous messageGo to next message
gazzag
Messages: 388
Registered: November 2010
Location: Bristol, UK
Senior Member
Can we see the output please?
Re: Client Sql*Plus version [message #596904 is a reply to message #596903] Fri, 27 September 2013 06:35 Go to previous messageGo to next message
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
Senior Member
sure

C:\>dumpbin/headers D:\oracle\product\10.2.0\client_1\BIN\sqlplus.exe
'dumpbin' is not recognized as an internal or external command,
operable program or batch file.

C:\>



thanks....
Re: Client Sql*Plus version [message #596906 is a reply to message #596904] Fri, 27 September 2013 06:40 Go to previous messageGo to next message
ThomasG
Messages: 3123
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Where have you saved dumpbin.exe? Do a "dir dumpbin.exe" to see if you really have saved it directly under c:\

Otherwise you have to call it with the full path. Also, there has to be a space between dumpbin and /headers.
Re: Client Sql*Plus version [message #596907 is a reply to message #596906] Fri, 27 September 2013 06:47 Go to previous messageGo to next message
gazzag
Messages: 388
Registered: November 2010
Location: Bristol, UK
Senior Member
Like ThomasG says, is dumpbin.exe in your PATH? If not you either have to specify the full path or save it in the same directory that you are in.
Re: Client Sql*Plus version [message #596908 is a reply to message #596906] Fri, 27 September 2013 06:52 Go to previous messageGo to next message
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
Senior Member
sorry it was my bad, dumpbin.exe was in d:\ so it wasn't recognize but i put it in c:\ then


C:\>dumpbin /headers D:\oracle\product\10.2.0\client_1\BIN\sqlplus.exe
►8¼ : error : cannot execute LINK.EXE

C:\>



then what does it mean?
thanks.......
Re: Client Sql*Plus version [message #596911 is a reply to message #596908] Fri, 27 September 2013 07:41 Go to previous messageGo to next message
ThomasG
Messages: 3123
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Well it means that dumpbin seems to need link.exe, too. So you might have to install some sort of visual Studio to get it to run after all.

Another option would be to install the GNU File Utility.

http://gnuwin32.sourceforge.net/packages/file.htm

The interesting part that I found there is that while the 32bit sqlplus for Oracle 11.0.2 is a 32-bit Application, the 64-Bit client seems to be a Mono/.net assembly, not a native executable. (or at least get's recognized by "file" as such):

C:\>c:\Programme\GnuWin32\bin\file.exe s:\Client_11_64\sqlplus.exe
s:\Client_11_64\sqlplus.exe; PE32+ executable for MS Windows (console) 
Mono/.Net assembly

C:\>c:\Programme\GnuWin32\bin\file.exe s:\Client_11_32\sqlplus.exe
s:\Client_11_32\sqlplus.exe; PE32 executable for MS Windows (console) 
Intel 80386 32-bit
C:\>


[Updated on: Fri, 27 September 2013 07:42]

Report message to a moderator

Re: Client Sql*Plus version [message #596912 is a reply to message #596911] Fri, 27 September 2013 07:59 Go to previous messageGo to next message
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
Senior Member
thanks for your response,

but i am not able to understand that we have to install a software to know version.
actually we need to get this this thing at client end so we are not allowed to install or uninstall any thing.

so there is no shortcut or command like: sqlplus -v.

thanks.......
Re: Client Sql*Plus version [message #596913 is a reply to message #596912] Fri, 27 September 2013 08:11 Go to previous messageGo to next message
ThomasG
Messages: 3123
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
The problem might be that the 32bit and 64bit versions are probably built from the same sources, just with different compile options.

So the "Program itself" might not even know whether it was compiled into a 32bit or 64bit binary.

I just checked, and what I did find was a SQLPLUS_README file in the same directory as the sqlplus.exe, which seems to indicate how/when/where sqlplus was compiled. Perhaps that would be "good enough" of an indication for your case?

SQLPLUS Package Information 
=========================== 
Sun Oct 30 08:05:55 CDT 2011
Client Shared Library 32-bit - 11.2.0.3.0

Windows NT Version V5.2 Service Pack 2 
CPU                 : 2 - type 586, 1 Physical Cores
Process Affinity    : 0x0x00000000
Memory (Avail/Total): Ph:7185M/7799M, Ph+PgF:11206M/11690M, VA:1965M/2047M 
Operating in ORACLE_HOME environment.
Small timezone file = C:\ADE\aime_77291\oracle\oracore\zoneinfo\timezone_14.dat
Large timezone file = C:\ADE\aime_77291\oracle\oracore\zoneinfo\timezlrg_14.dat


SQLPLUS Package Information 
=========================== 
Wed Nov  2 23:11:13 CDT 2011
Client Shared Library 64-bit - 11.2.0.3.0

Windows Server 2003 Version V5.2 Service Pack 2 
CPU                 : 2 - type 8664, 2 Physical Cores
Process Affinity    : 0x0x0000000000000000
Memory (Avail/Total): Ph:6962M/7999M, Ph+PgF:8972M/9606M VM name             : VMWare Version (6)

Operating in ORACLE_HOME environment.
Small timezone file = C:\ADE\aime_79294\oracle\oracore\zoneinfo\timezone_14.dat
Large timezone file = C:\ADE\aime_79294\oracle\oracore\zoneinfo\timezlrg_14.dat

[Updated on: Fri, 27 September 2013 08:13]

Report message to a moderator

Re: Client Sql*Plus version [message #596920 is a reply to message #596913] Fri, 27 September 2013 08:50 Go to previous messageGo to next message
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
Senior Member
thanks for your reply.

but could you please tell me the exact path of SQLPLUS_README
this file on windows and how to run it because i couldnt find it.



thanks........
Re: Client Sql*Plus version [message #596925 is a reply to message #596920] Fri, 27 September 2013 09:23 Go to previous messageGo to next message
ThomasG
Messages: 3123
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
It's a text file (you can open it with notepad) that (at least on my installation) is in the same directory as sqlplus.exe

Re: Client Sql*Plus version [message #597126 is a reply to message #596925] Tue, 01 October 2013 04:40 Go to previous messageGo to next message
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
Senior Member
sorry for late reply,
and thanks to all who helped me.

ThomasG,
actually i couldn't find SQLPLUS_README text file any where which can shows "SQLPLUS Package Information".

but i got it by another way:

c:\>tnsping

TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 01-OCT-2
013 15:23:34

Copyright (c) 1997, 2005, Oracle.  All rights reserved.

TNS-03502: Insufficient arguments.  Usage:  tnsping <address> [<count>]

c:\>


i have 64-bit os. My computer-->properties

thanks.......
icon14.gif  Re: Client Sql*Plus version [message #597142 is a reply to message #597126] Tue, 01 October 2013 05:53 Go to previous messageGo to next message
Michel Cadot
Messages: 60016
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
but i got it by another way:


Thank to let us know.

Re: Client Sql*Plus version [message #597148 is a reply to message #597142] Tue, 01 October 2013 06:08 Go to previous messageGo to next message
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
Senior Member
hello guys,

i want to ask one more question:

how can we change default Sql*plus from client to server?

actually i have a 10g oracle client and 11g oracle server on my local m/c, and when i say-

C:\>sqlplus

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Oct 1 16:50:01 2013

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Enter user-name:


but i want that 11g sqlplus should be launched from cmd.

thanks...........
icon2.gif  Re: Client Sql*Plus version [message #597152 is a reply to message #597148] Tue, 01 October 2013 06:38 Go to previous messageGo to next message
Michel Cadot
Messages: 60016
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You have to install a 11g client and set your ORACLE_HOME to this new install.

Re: Client Sql*Plus version [message #597320 is a reply to message #597152] Thu, 03 October 2013 03:27 Go to previous messageGo to next message
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
Senior Member
thanks sir for your kind response,

it means that we cannot launch sqlplus from cmd,we have to manually open it ,
if we only have oracle server .is it?

thanks........
icon2.gif  Re: Client Sql*Plus version [message #597329 is a reply to message #597320] Thu, 03 October 2013 05:07 Go to previous message
Michel Cadot
Messages: 60016
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You can launch sqlplus.exe from cmd with ORACLE_HOME and PATH set to 11g Oracle home.

Previous Topic: Excel import
Next Topic: sqlplus command execution
Goto Forum:
  


Current Time: Mon Dec 22 04:11:11 CST 2014

Total time taken to generate the page: 0.10266 seconds