OraFAQ Forum: Windows » Ora 10g Client Question on W2k8

Home » Infrastructure » Windows » Ora 10g Client Question on W2k8 (Windows 2008 Standard)

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

Ora 10g Client Question on W2k8 [message #516132]

Fri, 15 July 2011 03:36

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

Report message to a moderator

Re: Ora 10g Client Question on W2k8 [message #516133 is a reply to message #516132]

Fri, 15 July 2011 03:39

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

Report message to a moderator

Re: Ora 10g Client Question on W2k8 [message #516134 is a reply to message #516133]

Fri, 15 July 2011 03:45

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

Report message to a moderator

Re: Ora 10g Client Question on W2k8 [message #516136 is a reply to message #516134]

Fri, 15 July 2011 03:51

Littlefoot
Messages: 21825
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

Report message to a moderator

Re: Ora 10g Client Question on W2k8 [message #516138 is a reply to message #516136]

Fri, 15 July 2011 03:52

6910p
Messages: 3
Registered: July 2011
Location: uk

Junior Member

Thanks again LittleFoot

a big help this morning.

Report message to a moderator

Re: Ora 10g Client Question on W2k8 [message #516139 is a reply to message #516138]

Fri, 15 July 2011 03:53

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

Report message to a moderator

Re: Ora 10g Client Question on W2k8 [message #516183 is a reply to message #516139]

Fri, 15 July 2011 06:45

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

Code: [Select all] [Show/ hide]

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Aug 17 19:08:20 CDT 2025