Solved

Upgrading from Oracle 8i to 10G

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

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

821 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