Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Upgrade: 8.1.7->9.2 on Windows

Re: Upgrade: 8.1.7->9.2 on Windows

From: Thomas Day <>
Date: Fri, 23 May 2003 07:06:41 -0800
Message-ID: <>

I'm right in the middle of doing the same thing. You can install oracle 9.2 with the 8.1.7 database up and running. I have not been successful in using the GUI to upgrade the 8.1.7 database (and the installer will want to upgrade any database that it finds). We are creating a new database in 9.2 --- we don't care about current data (or can easily recreate it).

                      "Koivu, Lisa"                                                                                                    
                      <Lisa.Koivu              To:      Multiple recipients of list ORACLE-L <>                    
                      @Fairfieldresort         cc:                                                                                     
            >                   Subject: Upgrade: 8.1.7->9.2 on Windows                                                 
                      Sent by: root                                                                                                    
                      05/22/2003 06:18                                                                                                 
                      Please respond                                                                                                   
                      to ORACLE-L                                                                                                      

Hello all,

I'm working on an upgrade, my first major one on Windows (w2k)

The docs I've read aren't specific about when to actually install the software. So here's what I've done:

  1. Prepare the databases as directed in Note 159657.1
  2. Shut the db's down, install the software into a different oracle home
  3. Bring db's up and run the proper upgrade script (in this case, u0801070.sql)

And then follow the remainder of the directions in this note.

My question is, can I install the software ahead of time, with the databases up and available? Yes, I know, "try it out", I'll try it with the next upgrade test on the next host. But if someone has been there/done that, I would appreciate any pointers.

I'm a moron when it comes to windows. Or should I say I am a MONKEY when it comes to windows

Thanks everyone

Lisa Koivu
Fairfield Resorts, Inc.
5259 Coconut Creek Parkway
Ft. Lauderdale, FL, USA 33063
Office: 954-935-4117
Fax: 954-935-3639
Cell: 954-683-4459


Please see the official ORACLE-L FAQ:

Author: Thomas Day

Fat City Network Services    -- 858-538-5051
San Diego, California        -- Mailing list and web hosting services
To REMOVE yourself from this mailing list, send an E-Mail message to: (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri May 23 2003 - 10:06:41 CDT

Original text of this message