| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Shite of the day
Hi Ganesh,
Thanks for your reply. Still, no dice. Now it thinks it's in recovery and I can't force it to do an incomplete recovery with OPEN RESETLOGS. The brilliant response I got from support is "Restore from backup and try again"
Lovely. This is the second upgrade I have tried to complete and failed miserably at. This is NOT giving me a warm fuzzy about upgrading production.
Lisa
(Can one more thing go wrong today? Please?)
-----Original Message-----
Sent: Wednesday, June 04, 2003 1:38 PM
To: Multiple recipients of list ORACLE-L
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
-----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).
--
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 Thu Jun 05 2003 - 05:28:13 CDT
 |
 |