• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1206
  • Last Modified:

Upgrading from Oracle 8i to 10G

Well, I finally need to bite the bullet and upgrade my clients from 8i to 10g.  Is there anyone that can give me some tips as to what problems I may run across?
0
Randy Rich
Asked:
Randy Rich
1 Solution
 
NicksonKohCommented:
Hi Jaax,

If your Oracle are on Windows Server OS, you might want to watch out that Oracle 10g can only installed on W2000 onwards. I would recommend that you use Win 2003. Consider a clean upgrade, i.e. setup everything from scratch on a new server. Personally, this has been my favourite approach as it is less risky and the new setup will be more optimally set up.

With a new server, you can also do a trial setup first and test the application for problems. Once all the problems have been solved, you can safely migrate over the old database to this new database where you would probably close the database from any user usage.

Cheers,
NicksonKoh
0
 
gattu007Commented:
Upgrade Clients to the Current Release

You can upgrade any or all of your Oracle8i, Oracle9i, or Oracle Database 10g clients to the new Oracle Database 10g release. The Oracle Database 10g client can be used to access your Oracle8i, Oracle 9i, and Oracle 10g databases.

http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14238/intro.htm#sthref31
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
oleggoldCommented:
May I suggest You see case studies first:
http://www.dbspecialists.com/presentations/case_study_10g.html
0
 
Mark GeerlingsDatabase AdministratorCommented:
I disagree with this staement: "The Oracle Database 10g client can be used to access your Oracle8i, Oracle 9i, and Oracle 10g databases."

That is *NOT* what we experienced!  For us, an Oracle10.1 client can only connect to Oracle9 or Oracle10 databases, *NOT* to an Oracle8.1 database.
0
 
gattu007Commented:
u can connect still connect from 10g client to 8i server...... It was supported.... but not recommended...

chk this metalink note

Subject:       Client / Server / Interoperability Support Between Different Oracle Versions
        Doc ID:       Note:207303.1
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now