Can Oracle client 8.0 connect to Oracle 10g?

[seekoksin]

Hi,

Can anyone advise whether application running on Oracle 8 client be able to connect to Oracle 10g?? This is because of the legacy application that will be connecting to a new oracle, oracle 10g..

Thks

 

[SantaMufasa]

Seekoksin,

What happened when you tried to connect 8i client to 10g instance?

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
“Beware of those that seek to protect you from harm or risk. The cost will be your freedoms and your liberty.”

 

[seekoksin]

SantaMufasa,

I've yet to try. It will be nice to know before moving the current database of 9i to 10g.

 

[KenCunningham]

I don't think you could cause any problem simply by trying it.

I want to be good, is that not enough?

 

[ChrisHunt]

I think his point is that he doesn't currently have a 10g connection to try it with. He wants to know if it will continue to work after he's upgraded the target app from 9i to 10g.

My guess is that it will work, but you won't know until you try it.



-- Chris Hunt
Webmaster & Tragedian
Extra Connections Ltd

 

[Turkbear]

Hi,
If it connects to 9i it should also connect to 10g.

Can't the client be updated as well?





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[karluk]

Just because your Oracle 8 client connects successfully to an existing 9i database, there is no reason to assume that it will continue to work vs. a 10g database. Oracle gradually drops support for obsolete software, including old versions of Oracle client.

The relevant Metalink document is 207303.1, which provides a support matrix for various combinations of Oracle client and Oracle RDBMS. For 8i client and 10g RDBMS, I see that 8.1.7 client connecting to 10.2 database used to be a supported configuation before 8.1.7 went out of extended support. No earlier version of 8i client has ever been supported vs. 10g database.

So, if your client software is 8.1.6 or earlier, you would have to get lucky to have your client connections continue to work once you upgrade to 10g database. If you happen to be using 8.1.7 client, there is a much better chance that it will continue to work. However, if you do have a problem, you will get absolutely no help from Oracle support other than advice to upgrade your client. That includes routine 10g patching after you upgrade. Every time you patch your database will be an adventure in guessing whether your 8i client will continue to work. Rather than setting traps for yourself down the road, I strongly suggest that you incorporate a client upgrade as part of your 10g migration planning.