Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Upgrade gotchas -> on Windows

Upgrade gotchas -> on Windows

From: Koivu, Lisa <>
Date: Wed, 18 Jun 2003 09:00:34 -0700
Message-ID: <>

Title: Upgrade gotchas -> on Windows

Thought I'd let you know since a couple of people are planning upgrades to 9.2 on Windows (that I've heard from) - here's the gotchas I ran into with my upgrade.  The databases were fine but other stuff broke, of course.

After upgrading, there's crap left in the registry that refers to the older version of Oracle.  Backup Exec doesn't like that.  I had to delete the old oracle_home out of the registry and reboot. Suddenly all my backups were working.  Of course I only run one oracle_home so I was able to remove this entry without consequence.

Also, the install doesn't set the right path for SQLPATH:  it sets it to a unix directory, \dbs.  Once I changed it to OH\bin, my perl scripts were able to connect to sqlplus. They were failing before...

It also doesn't set ORA_sid_PWFILE at all.  This value needs to be there and be correct if you want to run startup without specifying the pfile on the command line.

I'm not getting any emails from the list for some reason so I don't know if this will be well received... but I hope this helps at least one person. 

Lisa Koivu

Oracle Database Stressmonkey    

Fairfield Resorts, Inc.

5259 Coconut Creek Parkway

Ft. Lauderdale, FL, USA  33063

Office: 954-935-4117  

Fax:    954-935-3639

Cell:    954-683-4459

"The sender believes that this E-Mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission.  By reading the message and opening any attachments, the recipient accepts full responsibility for taking proactive and remedial action about viruses and other defects. The sender's business entity is not liable for any loss or damage arising in any way from this message or its attachments."
Please see the official ORACLE-L FAQ:
Author: Koivu, Lisa

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: [EMAIL PROTECTED] (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 Wed Jun 18 2003 - 11:00:34 CDT

Original text of this message