Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle server Upgrade from 9.0 to 9.2 on Windows 2003
Personally, I'd install 9.2 in a second Oracle Home and then upgrade the
database. Once it is all done, feel free to remove the 9.0 software in
that home. You'll use the DBUA in the 9.2 home, not the 9.0 one!
HTH,
Brian
Wade Chy wrote:
>
> Hi All,
> I am trying to upgrade an Oracle server running 9.0 on Win 2003. I do
> not want to keep 2 Oracle Homes for 9.0 and 9.2. I would rather
> uninstall 9.0 using oui. I will import the data from production
> database from export files. What will be my best (easy, hassle free)
> course of action:
>
> 1. Shutdown the current 9.0 instance
> 2. Drop the current 9.0 db
> 3. Uninstall the current 9.0 executibls using oui
> 4. Install the 9.2 executibles
> 5. Create new db instance
> 6. Import the data from export files
>
> Is this a good idea? Or should I have 2 Oracle Homes by installing 9.2
> and upgrade the 9.0 db using dbua? Only problem is I cant find the
> dbua in the current 9.0 setup. Your advice / experience / feedback
> will really appreciated. Thanx in advance.
-- =================================================================== Brian Peasland dba_at_remove_spam.peasland.com Remove the "remove_spam." from the email address to email me. "I can give it to you cheap, quick, and good. Now pick two out of the three"Received on Wed Nov 05 2003 - 15:16:53 CST