Re: How to upgrade to Oracle9i

"Satish" <chavasatish_at_hotmail.com> wrote in message news:9df60736.0110121053.668c46b2_at_posting.google.com...
> Hi,
>
> I want to upgrade my current database(8.0.5 on WinNT) to 9i.
>
> Though i installed Oracle i never done upgrades in the past.Could
> someone help me with information on how to upgrade to 9i.
>
> 1)If i install 9i into a different Oracle_Home,should i change
> anything
> on the client apllications.
> 2)Can i use "DB Name" and "Connect string" (default names) same as the
> old
> database?
>
> 3)Documention says,inorder to upgrade to 9i, an Oracle8 database must
> be atleast realeas8.0.6, is that true?
>
> Are there any issues i should be aware of.
>
> I really appreciate any help.
>
>
> Thank you
> Satish

1. You will need to change the ORACLE_HOME on any local running APPS and the entry on your listener.ora. You of course will need to test your applications to ensure nothing is going to break!
2. Yes. The database can have the same names.
3. If the docs say 8.06 then you had betterupgrade to 8.0.6 prior to going to 9i. If you try it you will probably break something and support will probably not be able to help.

Make sure you testthe upgreade on a test server.

Stephen C. Ashmore
Brainbench MVP for Oracle Administration http://www.brainbench.com Received on Fri Oct 12 2001 - 11:36:26 CDT