Solved

Upgrading from Oracle 8i to 10G

Posted on 2007-03-24
7
1,199 Views
Last Modified: 2013-12-19
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
Comment
Question by:Randy Rich
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 10

Expert Comment

by:Jaax
ID: 18787483
0
 
LVL 17

Expert Comment

by:NicksonKoh
ID: 18805011
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
 
LVL 7

Expert Comment

by:gattu007
ID: 18860760
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
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

 
LVL 21

Expert Comment

by:oleggold
ID: 18892753
May I suggest You see case studies first:
http://www.dbspecialists.com/presentations/case_study_10g.html
0
 
LVL 21

Accepted Solution

by:
oleggold earned 500 total points
ID: 18892763
0
 
LVL 35

Expert Comment

by:Mark Geerlings
ID: 19005755
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
 
LVL 7

Expert Comment

by:gattu007
ID: 19366272
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

Industry Leaders: 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!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Via a live example, show how to take different types of Oracle backups using RMAN.

737 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question