OraFAQ Forum: Performance Tuning » Oracle : Client version

Home » RDBMS Server » Performance Tuning » Oracle : Client version < Database version. (8.1.7 vs 10gxe)

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

Oracle : Client version < Database version. [message #503395]

Fri, 15 April 2011 04:21

SAKOURA
Messages: 52
Registered: June 2010
Location: France

Member

Hi evreybody,

A client is installed with a 8.1.7 version of Oracle and it can access and run with a db using an 10gxe version.
If I upgrade my client (10g or 11g), is there any improvement of performances in term of access to data?

Thx in advance for your replies.
Sak.

Report message to a moderator

Re: Oracle : Client version < Database version. [message #503397 is a reply to message #503395]

Fri, 15 April 2011 04:42

cookiemonster
Messages: 13958
Registered: September 2008
Location: Rainy Manchester

Senior Member

Probably not.
However you probably will have issues with your version of sqlplus not recognising valid syntax so you should upgrade to the correct version regardless.

Report message to a moderator

Re: Oracle : Client version < Database version. [message #503399 is a reply to message #503397]

Fri, 15 April 2011 05:26

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

Senior Member
Account Moderator

You also have a better security level with a higher level of client.
8i can be easily hacked in our days, this is why 11g no more supports it.

Regards
Michel

Report message to a moderator

Re: Oracle : Client version < Database version. [message #503400 is a reply to message #503399]

Fri, 15 April 2011 05:31

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

Senior Member
Account Moderator

By the way, I checked on Metalink, 10.2 (and so XE) does not support it either.

Regards
Michel

Report message to a moderator

Re: Oracle : Client version < Database version. [message #503413 is a reply to message #503400]

Fri, 15 April 2011 06:46

SAKOURA
Messages: 52
Registered: June 2010
Location: France

Member

Hello,
Thanks a lot for the replies but a the connection succeded from a client 8.1.7 to a db which is a 10gxe.
Sak.

Report message to a moderator

Re: Oracle : Client version < Database version. [message #503414 is a reply to message #503413]

Fri, 15 April 2011 06:48

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

Senior Member
Account Moderator

It succeeds but it is not guaranted that it will always work and will have no problem with the connection.

Regards
Michel

Report message to a moderator

Re: Oracle : Client version < Database version. [message #503415 is a reply to message #503414]

Fri, 15 April 2011 06:50

SAKOURA
Messages: 52
Registered: June 2010
Location: France

Member

Hello,
Well, I understand. Thanks a lot for your reply.
Have a nice day.
Sak.

Report message to a moderator

Previous Topic:	Query Hanging with Sequential Read or Latch free Waits
Next Topic:	Max and delete statment talking lot of time

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 20:29:37 CST 2024