Solved

Upgrading from Oracle 8i to 10G

Posted on 2007-03-24
7
1,191 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
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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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 34

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Article by: Swadhin
From the Oracle SQL Reference (http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/queries006.htm) we are told that a join is a query that combines rows from two or more tables, views, or materialized views. This article provides a glimps…
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…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

746 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now