Solved

Upgrading from Oracle 8i to 10G

Posted on 2007-03-24
7
1,196 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 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

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.

Question has a verified solution.

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

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
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…
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

831 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