Set the Compatiable Parameter to the Actual Version you Upgraded and not to any patch rel that was rel later on.
HTH Best Regards, Ganesh R DID : +65-6215-8413 HP : +65-9067-8474 =========================================== Live to learn... forget... and learn again. =========================================== -----Original Message----- Lisa Sent: Wednesday, June 04, 2003 10:40 PM To: Multiple recipients of list ORACLE-L Oh-My-Gosh. Worry free? I just upgraded another 8.1.7.4 database to 9.2. When I set the COMPATIBLE parm to 9.0.2 (or 9.2, which would make sense) I get really messy errors: ORA-00402: database changes by release 9.0.1.3.0 cannot be used by release 135294976 ORA-01571: redo version 9.0.2.0.0 incompatible with ORACLE version 8.1.7.0.0 So then I tried to set it back to 8.1.7, or comment out COMPATIBLE altogether, and I get the same type of error. It won't open at all. I tried initiating recovery. This database is in noarc mode. It starts looking for arclogs that *do not* exist. I also tried to drop the redo log groups and recreate them. Still, no dice. Again, unbreakable my FUNDAMENT. So has anyone seen this before? I opened a tar yesterday and promptly confused support. Lisa -----Original Message----- Sent: Wednesday, June 04, 2003 7:45 AM To: Multiple recipients of list ORACLE-L "Trade SQL Server for Oracle9i Database and get up to 100% license credit and peace of mind. Tired of applying patches? Frustrated with managing mulitple database servers? In the time it takes you to apply all Microsoft's patches to your servers, you can successfully migrate your database to Oracle9i Database and be worry-free. " >From http://www.oracle.com/start/linuxsqlserver/intro.html?src=1764462&Act=16 I don't understand PR of Oracle. The RDBMS has so much properties which are much more better implemented in Oracle than in MS SQL and they choose 'patching' which *** on both servers. JP -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jan Pruner 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). -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ganesh Raja 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).