Home » Infrastructure » Windows » Ora 10g Client Question on W2k8 (Windows 2008 Standard)
Ora 10g Client Question on W2k8 [message #516132] Fri, 15 July 2011 03:36 Go to next message
6910p
Messages: 3
Registered: July 2011
Location: uk
Junior Member
Hi,

Hope i've put this in the correct area.

We currently have a windows 2008 server running our virtulization administration application (VCenter server 4.0) which uses a 10g client 32bit ODBC driver to connect to our 10g database server. This is the emulated 32bit driver in sysWOW64 folder.

I need to upgrade VCenter, which needs to use the 64bit 10g ODBC driver. Have installed the 102010_win64_x64_client on a test server which gives me the correct 64 bit driver.

My question is can i install two clients onto the same windows 2008 server without causing operational issues while i run pre upgrade checks?

Thanks
Re: Ora 10g Client Question on W2k8 [message #516133 is a reply to message #516132] Fri, 15 July 2011 03:39 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As far as I can tell - yes, you can. Just make sure to put each of them into its own Oracle Home (i.e. directory).
Re: Ora 10g Client Question on W2k8 [message #516134 is a reply to message #516133] Fri, 15 July 2011 03:45 Go to previous messageGo to next message
6910p
Messages: 3
Registered: July 2011
Location: uk
Junior Member
Many thanks

Is there a way i can find out execatly what version my existing Oracle 10g client (i.e. that uses the 32bit driver). Want to install both on a test server.

thanks
Re: Ora 10g Client Question on W2k8 [message #516136 is a reply to message #516134] Fri, 15 July 2011 03:51 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
M:\>sqlplus scott/tiger@ora11

SQL*Plus: Release 10.2.0.1.0 - Production on Pet Srp 15 10:49:57 2011

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options


SQL>

Red - client version
Blue - server version
Re: Ora 10g Client Question on W2k8 [message #516138 is a reply to message #516136] Fri, 15 July 2011 03:52 Go to previous messageGo to next message
6910p
Messages: 3
Registered: July 2011
Location: uk
Junior Member
Thanks again LittleFoot

a big help this morning.
Re: Ora 10g Client Question on W2k8 [message #516139 is a reply to message #516138] Fri, 15 July 2011 03:53 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Also, if you run Oracle Universal Installer (OUI), it should display exact versions of all Oracle products you installed so far.
Re: Ora 10g Client Question on W2k8 [message #516183 is a reply to message #516139] Fri, 15 July 2011 06:45 Go to previous message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
SQL*Plus: Release 10.2.0.3.0 - Production on Fri Jul 15 17:08:26 2011

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


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

ind>  select '&&_O_VERSION' as "Oracle server Version" from dual ;
old   1:  select '&&_O_VERSION' as "Oracle server Version" from dual
new   1:  select 'Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options' as "Oracle server Version" from dual

Oracle server Version
--------------------------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options


1 row selected.

ind> select '&_SQLPLUS_RELEASE' "client version" from dual;
old   1: select '&_SQLPLUS_RELEASE' "client version" from dual
new   1: select '1002000300' "client version" from dual

client ver
----------
1002000300

1 row selected.

[Updated on: Fri, 15 July 2011 06:48]

Report message to a moderator

Previous Topic: how to run dos command from sqlplus window
Next Topic: isqlplussvc.exe error
Goto Forum:
  


Current Time: Thu Mar 28 03:25:55 CDT 2024