From Lisa.Koivu@Fairfieldresorts.com Wed, 18 Jun 2003 09:00:34 -0700 From: "Koivu, Lisa" Date: Wed, 18 Jun 2003 09:00:34 -0700 Subject: Upgrade gotchas - 8.1.7.4->9.2.0.3 on Windows Message-ID: MIME-Version: 1.0 Content-Type: text/html Title: Upgrade gotchas - 8.1.7.4->9.2.0.3 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: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com 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).