Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Can Oracle client 8.0 connect to Oracle 10g?
- Thread starter seekoksin
- Start date
SantaMufasa
Technical User
Seekoksin,
What happened when you tried to connect 8i client to 10g instance?
![[santa]](/data/assets/smilies/santa.gif "[santa] [santa]")
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.”
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.”
- Thread starter
- #3
KenCunningham
Technical User
I don't think you could cause any problem simply by trying it.
I want to be good, is that not enough?
I want to be good, is that not enough?
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
My guess is that it will work, but you won't know until you try it.
-- Chris Hunt
Webmaster & Tragedian
Extra Connections Ltd
![[profile]](/data/assets/smilies/profile.gif "[profile] [profile]")
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.
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.
- Status
Similar threads
