Upgrading Oracle on Windows 2000
I am preparing an Oracle upgrade from 8.1.7.4 to 9.2.0.5 on a Windows 2000 environment. The server has 3 instances on it, and the possibility of upgrading them one at a time is a real one. My question is, is it OK to just run the upgrade assistant against each database one at a time, and let it worry about things like ORACLE_HOME, or is it more complicated than that?
Software/Hardware used:
Software/Hardware used:
ASKED:
October 18, 2004 5:30 PM
UPDATED:
October 29, 2004 3:53 PM
RELATED QUESTIONS
- upgrading from oracle 8i to oracle 9i from windows 2000 server to windows server 2003
- Upgrade path for Windows 2000 Adv Server to Windows Server 2008R2
- Getting error while insert in forms 6i application
- Clock gaining time - Windows 2000 Server Domain Controller on Site only!
- P2V migration of Windows server 2000 (no shadow copy service)
Answer Wiki:
Hate to pass out the RTFM message, but a good read of the upgrade manual will answer all of those questions. But generally speaking what your suggesting is absolutely doable and a good idea. The upgrade process for one database can take a significant amount of time, on the order of an hour or more per database instance. DBUA will update all of the appriopriate environment variables which makes it easy (BTDT and enjoyed it). One MAJOR warning. Be absolutely certain that there are ZERO invalid Java objects in a database before using the upgrade assistant. All it takes is one and your tubed. If you can't recompile and validate that object your stuck with doing a manual upgrade or recreating the database. I've done one manual upgrade, you don't want to.
To see all answers submitted to the Answer Wiki: View Answer History.
Earlier this year, I had the same problem. If you read migration guide, it suggests that using dbua is an easy way to upgrade. So, I created a sample db of 8.1.7 and tried upgrading it. It worked fine. However, when I tried with our actual test database it failed with error. In my opinion, you should first install Oracle 9.2 with starter database and study it. Then create an empty database of 9.2 and import schema n data using 8.1.7 export dump. This is the best and clean way to upgrade and reorganize your database. You can do the same with other instances.
Let me know if you have any upgrade related questions.
Kamal Saini
I agree with Kamal. One question you need to answer before doing the upgrade is what impact will it have on the application or user interface that makes use of the database? Is it a third party app like PeopleSoft or is it an Oracle app or is it internally developed? If it is third party or internally developed you need to make sure that it supports 9.0.2.5. DBUA may be an easier upgrade path, but once you’ve upgraded the db there is no going back. To allow for testing of your environment using 9.0.2.5, the safe bet is to create a 9i db and import your schema from your 8i db. This will allow user acceptance testing to take place without destroying your current db.
Stephen Jones