Upgrading Patches

Currently I am running Oracle 9i (9.2.0.1.0) and in the process of upgrading to 9.2.0.8.  Can I go straight to 8 from 1 or do I need to install another patch first?  Are there any tips or suggestions that I need to know b/f I start this procedure?  Please advise.

gdlp2004Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

NicksonKohCommented:
Hi gdlp2004,

You can go straight from 1 to 8. Advise is do it in test first before doing it for production.

Cheers
Nickson
ceecilCommented:
before you go from 9.2.0.1.0 to 9.2.0.8.0 You should first consider the implications of other components that will or may have to work with Oracle.

If this is purely Oracle, then you should not have a problem.

if you are using Oracle and a GLOBAL oracle application, then you would need to first confirm compatibilties. As of now, I don't see you having any problem. So, you can go ahead and do the patch.

Keep in mind the following.

IMPORATNT:  SHUT DOWN ALL ORACLE SERVICES before applying the patch
                     YOU MAY HAVE TO SHUTDOWN Distrubuted Transaction processing Services in Windows.

1. Back up your system, Oracle DB and control and archive files. (MUST)
2. Back up the registry and preferably the inventory under Program files\Oracle.
3. YOU CANNOT UNDO the patch after you move to a higher version number.
4. Make sure that you patch the Database server side first.
5. Make sure that you then patch each existing database after that.



Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.