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).
Received on Wed Jun 18 2003 - 11:00:34 CDT
