OraFAQ Forum: Client Tools » Client Sql*Plus version

Home » Other » Client Tools » Client Sql*Plus version

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

Client Sql*Plus version [message #596836]

Thu, 26 September 2013 11:33

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.......

Report message to a moderator

Re: Client Sql*Plus version [message #596839 is a reply to message #596836]

Thu, 26 September 2013 11:47

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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

Report message to a moderator

Re: Client Sql*Plus version [message #596840 is a reply to message #596836]

Thu, 26 September 2013 11:56

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

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

Lalit Kumar B
Messages: 3174
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

Report message to a moderator

Re: Client Sql*Plus version [message #596859 is a reply to message #596855]

Thu, 26 September 2013 15:00

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

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

Lalit Kumar B
Messages: 3174
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

Report message to a moderator

Re: Client Sql*Plus version [message #596863 is a reply to message #596862]

Thu, 26 September 2013 15:22

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: Client Sql*Plus version [message #596894 is a reply to message #596863]

Fri, 27 September 2013 05:18

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....

Report message to a moderator

Re: Client Sql*Plus version [message #596895 is a reply to message #596894]

Fri, 27 September 2013 05:31

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

dumpbin.exe is not included in a standard Windows install. I believe it comes with Visual Studio.

Report message to a moderator

Re: Client Sql*Plus version [message #596896 is a reply to message #596894]

Fri, 27 September 2013 05:32

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

Yes, you missed the sentence Michels wrote after the part you just have run.

Report message to a moderator

Re: Client Sql*Plus version [message #596901 is a reply to message #596896]

Fri, 27 September 2013 06:23

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.....

Report message to a moderator

Re: Client Sql*Plus version [message #596903 is a reply to message #596901]

Fri, 27 September 2013 06:33

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

Can we see the output please?

Report message to a moderator

Re: Client Sql*Plus version [message #596904 is a reply to message #596903]

Fri, 27 September 2013 06:35

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....

Report message to a moderator

Re: Client Sql*Plus version [message #596906 is a reply to message #596904]

Fri, 27 September 2013 06:40

ThomasG
Messages: 3212
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.

Report message to a moderator

Re: Client Sql*Plus version [message #596907 is a reply to message #596906]

Fri, 27 September 2013 06:47

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, 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.

Report message to a moderator

Re: Client Sql*Plus version [message #596908 is a reply to message #596906]

Fri, 27 September 2013 06:52

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.......

Report message to a moderator

Re: Client Sql*Plus version [message #596911 is a reply to message #596908]

Fri, 27 September 2013 07:41

ThomasG
Messages: 3212
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

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.......

Report message to a moderator

Re: Client Sql*Plus version [message #596913 is a reply to message #596912]

Fri, 27 September 2013 08:11

ThomasG
Messages: 3212
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

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........

Report message to a moderator

Re: Client Sql*Plus version [message #596925 is a reply to message #596920]

Fri, 27 September 2013 09:23

ThomasG
Messages: 3212
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

Report message to a moderator

Re: Client Sql*Plus version [message #597126 is a reply to message #596925]

Tue, 01 October 2013 04:40

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.......

Report message to a moderator

Re: Client Sql*Plus version [message #597142 is a reply to message #597126]

Tue, 01 October 2013 05:53

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

Senior Member
Account Moderator

Quote:

but i got it by another way:

Thank to let us know.

Report message to a moderator

Re: Client Sql*Plus version [message #597148 is a reply to message #597142]

Tue, 01 October 2013 06:08

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...........

Report message to a moderator

Re: Client Sql*Plus version [message #597152 is a reply to message #597148]

Tue, 01 October 2013 06:38

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

Senior Member
Account Moderator

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

Report message to a moderator

Re: Client Sql*Plus version [message #597320 is a reply to message #597152]

Thu, 03 October 2013 03:27

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........

Report message to a moderator

Re: Client Sql*Plus version [message #597329 is a reply to message #597320]

Thu, 03 October 2013 05:07

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

Senior Member
Account Moderator

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

Report message to a moderator

Previous Topic:	Excel import
Next Topic:	sqlplus command execution

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 06 13:02:00 CST 2025