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."
