RE: Shite of the day
Title: RE: Shite of the day The ways of man (and Oracle) are mysterious and not to be questioned, I guess. If some document said "set the COMPATIBLE parameter to 9.0.2" I would bet it's a typographical error. Good luck with your database! Let us know what happens. I've upgraded several database from 8.1.7 to 9.2.0 with no problems, if that's any consolation to you. :) -Original Message- From: Koivu, Lisa [mailto:[EMAIL PROTECTED]] Yes. But why is it asking for 9.0.2? I set it to 9.2, 8.1.7, and 9.0.2 just to give it a try. -Original Message- From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]] I guess this is a silly question, but could it be that Oracle didn't like the COMPATIBLE = 9.0.2 since there is no 9.0.2?
RE: Shite of the day
You never know. It might be the some anti-Arabic extremist got loose at Oracle. Have you tried: COMPATIBLE=IX.II..III ??? > -Original Message- > From: Seefelt, Beth [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 05, 2003 10:55 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: Shite of the day > > > > What asked for 9.0.2? Are you sure you didn't misread 9.2.0 ? > > You said you set COMPATIBLE to 9.0.2 and then started getting these > errors - > ORA-01571: redo version 9.0.2.0.0 incompatible with ORACLE version > 8.1.7.0.0 > > Sounds like maybe you ran a migrate or downgrade script with > an invalid > COMPATIBLE parameter and that's what hosed it. > > > -Original Message- > Sent: Thursday, June 05, 2003 10:20 AM > To: Multiple recipients of list ORACLE-L > > > Yes. But why is it asking for 9.0.2? I set it to 9.2, > 8.1.7, and 9.0.2 > just to give it a try. > -Original Message- > Sent: Wednesday, June 04, 2003 7:30 PM > To: Multiple recipients of list ORACLE-L > > > I guess this is a silly question, but could it be that Oracle didn't > like the COMPATIBLE = 9.0.2 since there is no 9.0.2? > I don't know how the comparison is done, but if it's a string > comparison > I wonder if there will be any bugs with the COMPATIBLE check when > version 10 comes out. > > -Original Message- > > From: Koivu, Lisa [mailto:[EMAIL PROTECTED] > > > > No. I guess by manual I mean I didn't use the gui. I ran the > > appropriate upgrade script. > > > > Gosh I hope it doesn't come to exp/imp... I can't even export > > my database. > > > > -Original Message- > > > > Lisa, when you say you "manually" migrated, did you use > > exp/imp after a > > fresh CREATE DATABASE in 9i? Also, what platform? 32-bit? > > > > Rich Jesse System/Database Administrator > > [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA > > > > > > > -Original Message- > > > Lisa > > > > > > 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 > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Seefelt, Beth > 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: Stephen Lee 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).
RE: Shite of the day
What asked for 9.0.2? Are you sure you didn't misread 9.2.0 ? You said you set COMPATIBLE to 9.0.2 and then started getting these errors - ORA-01571: redo version 9.0.2.0.0 incompatible with ORACLE version 8.1.7.0.0 Sounds like maybe you ran a migrate or downgrade script with an invalid COMPATIBLE parameter and that's what hosed it. -Original Message- Sent: Thursday, June 05, 2003 10:20 AM To: Multiple recipients of list ORACLE-L Yes. But why is it asking for 9.0.2? I set it to 9.2, 8.1.7, and 9.0.2 just to give it a try. -Original Message- Sent: Wednesday, June 04, 2003 7:30 PM To: Multiple recipients of list ORACLE-L I guess this is a silly question, but could it be that Oracle didn't like the COMPATIBLE = 9.0.2 since there is no 9.0.2? I don't know how the comparison is done, but if it's a string comparison I wonder if there will be any bugs with the COMPATIBLE check when version 10 comes out. > -Original Message- > From: Koivu, Lisa [mailto:[EMAIL PROTECTED] > > No. I guess by manual I mean I didn't use the gui. I ran the > appropriate upgrade script. > > Gosh I hope it doesn't come to exp/imp... I can't even export > my database. > > -Original Message- > > Lisa, when you say you "manually" migrated, did you use > exp/imp after a > fresh CREATE DATABASE in 9i? Also, what platform? 32-bit? > > Rich Jesse System/Database Administrator > [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA > > > > -Original Message- > > Lisa > > > > 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seefelt, Beth 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).
RE: Shite of the day (now 9i upgrade)
Binley, If you really want to know, instead of just insulting me outright: 1. I followed Note 159657.1 for a "manual" upgrade. And in step 31 it directs to use u0807010.sql. I then applied patch 2878462, and went on to apply patch 2761332. So as you can see, I did my homework here. The problems started when I set compatible to a value other than 8.1.7. I had the database open and operational at version 9.2.0.3 prior to this problem. 2. I tried 9.0.2 after trying 9.2.0 because that's what it thought it was. It's hosed anyway. Why not try it? Searching Metalink did not reveal any suggestions. 3. Yes of course the arclogs do not exist, this db was never in arclog mode. Which is exactly why when it started asking for arclogs I was pretty confused. I am trying it again and hoping that it works this time. I'll tell you what's worry-free: upgrading on Unix. Only once in 5 years did I have a problem of this magnitude. If you have any suggestions or constructive comments, I'd be glad to hear them. That's why I posted this problem to the list, along with letting everyone else know about the perils I enountered in this upgrade. I may not post too often to this list, but I do glance through the postings just to get a feeling for what others are doing/experiencing/testing/using. If you are going to post comments of a sarcastic or demeaning tone, aimed at me or at anyone else, I suggest you keep them to yourself. Lisa -Original Message- Sent: Wednesday, June 04, 2003 9:18 PM To: Multiple recipients of list ORACLE-L It is worry-free if you follow the upgrade instructions, and not skip around like you appear to have done. Did you run u0801070.sql at all? Did you check for any errors it might have produced? Both your errors indicate there was a problem in that area. Where did you dig COMPATIBLE = 9.0.2 from? There's no such release. Mere details, but details are important in a manual upgrade. If you decide to back-down COMPATIBLE to 8.1.7, did you run the downgrade script, check the outputs and follow the instructions? You need to do the following in order: - run the downgrade script and follow the instructions - run "alter database reset compatibility;" (OK, this bit is not that obvious in the documentation) - modify init.ora and restart If the database is in noarchivelog, isn't it reasonable that archivelogs do not exist? As for dropping redologs, k! - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, June 05, 2003 2:40 AM > 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Binley Lim 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).
RE: Shite of the day
Title: RE: Shite of the day Yes. But why is it asking for 9.0.2? I set it to 9.2, 8.1.7, and 9.0.2 just to give it a try. -Original Message-From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]Sent: Wednesday, June 04, 2003 7:30 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Shite of the day I guess this is a silly question, but could it be that Oracle didn't like the COMPATIBLE = 9.0.2 since there is no 9.0.2? I don't know how the comparison is done, but if it's a string comparison I wonder if there will be any bugs with the COMPATIBLE check when version 10 comes out. > -Original Message- > From: Koivu, Lisa [mailto:[EMAIL PROTECTED]] > > No. I guess by manual I mean I didn't use the gui. I ran the > appropriate upgrade script. > > Gosh I hope it doesn't come to exp/imp... I can't even export > my database. > > -Original Message- > > Lisa, when you say you "manually" migrated, did you use > exp/imp after a > fresh CREATE DATABASE in 9i? Also, what platform? 32-bit? > > Rich Jesse System/Database Administrator > [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA > > > > -Original Message- > > Lisa > > > > 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
RE: Shite of the day
If you do exp/imp... grab DDL on package bodies, grab the SYS grants, ... Patrice. -Original Message- Sent: Wednesday, June 04, 2003 6:20 PM To: Multiple recipients of list ORACLE-L Hi Rich, No. I guess by manual I mean I didn't use the gui. I ran the appropriate upgrade script. Gosh I hope it doesn't come to exp/imp... I can't even export my database. Lisa -Original Message- Sent: Wednesday, June 04, 2003 2:46 PM To: Multiple recipients of list ORACLE-L Lisa, when you say you "manually" migrated, did you use exp/imp after a fresh CREATE DATABASE in 9i? Also, what platform? 32-bit? Thx! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA > -Original Message- > From: Koivu, Lisa [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 04, 2003 1:05 PM > To: Multiple recipients of list ORACLE-L > Subject: 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 > === > 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=1764 > 462&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: Jesse, Rich 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 l
Re: Shite of the day (now 9i upgrade)
It is worry-free if you follow the upgrade instructions, and not skip around like you appear to have done. Did you run u0801070.sql at all? Did you check for any errors it might have produced? Both your errors indicate there was a problem in that area. Where did you dig COMPATIBLE = 9.0.2 from? There's no such release. Mere details, but details are important in a manual upgrade. If you decide to back-down COMPATIBLE to 8.1.7, did you run the downgrade script, check the outputs and follow the instructions? You need to do the following in order: - run the downgrade script and follow the instructions - run "alter database reset compatibility;" (OK, this bit is not that obvious in the documentation) - modify init.ora and restart If the database is in noarchivelog, isn't it reasonable that archivelogs do not exist? As for dropping redologs, k! - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, June 05, 2003 2:40 AM > 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Binley Lim 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).
RE: Shite of the day
Title: RE: Shite of the day I guess this is a silly question, but could it be that Oracle didn't like the COMPATIBLE = 9.0.2 since there is no 9.0.2? I don't know how the comparison is done, but if it's a string comparison I wonder if there will be any bugs with the COMPATIBLE check when version 10 comes out. > -Original Message- > From: Koivu, Lisa [mailto:[EMAIL PROTECTED]] > > No. I guess by manual I mean I didn't use the gui. I ran the > appropriate upgrade script. > > Gosh I hope it doesn't come to exp/imp... I can't even export > my database. > > -Original Message- > > Lisa, when you say you "manually" migrated, did you use > exp/imp after a > fresh CREATE DATABASE in 9i? Also, what platform? 32-bit? > > Rich Jesse System/Database Administrator > [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA > > > > -Original Message- > > Lisa > > > > 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
RE: Shite of the day
Hi Rich, No. I guess by manual I mean I didn't use the gui. I ran the appropriate upgrade script. Gosh I hope it doesn't come to exp/imp... I can't even export my database. Lisa -Original Message- Sent: Wednesday, June 04, 2003 2:46 PM To: Multiple recipients of list ORACLE-L Lisa, when you say you "manually" migrated, did you use exp/imp after a fresh CREATE DATABASE in 9i? Also, what platform? 32-bit? Thx! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA > -Original Message- > From: Koivu, Lisa [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 04, 2003 1:05 PM > To: Multiple recipients of list ORACLE-L > Subject: 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 > === > 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=1764 > 462&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: Jesse, Rich 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).
RE: Shite of the day
Lisa, when you say you "manually" migrated, did you use exp/imp after a fresh CREATE DATABASE in 9i? Also, what platform? 32-bit? Thx! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA > -Original Message- > From: Koivu, Lisa [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 04, 2003 1:05 PM > To: Multiple recipients of list ORACLE-L > Subject: 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 > === > 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=1764 > 462&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: Jesse, Rich 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).
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 === 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). -- 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
RE: Shite of the day
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).
RE: Shite of the day
Hi Dick, This was a manual upgrade. I sure hope your upgrades go better than mine have. Lisa -Original Message- Sent: Wednesday, June 04, 2003 11:35 AM To: Multiple recipients of list ORACLE-L Lisa, Did you do the upgrade manually or via the GUI? I'm interested because I'm looking forward to 20 upgrades several of which will have to be done in place as their too big otherwise. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, June 04, 2003 10:40 AM 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: Goulet, Dick 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).
RE: Shite of the day
I agree with you Lisa ... , I don't understand the PR ... v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 > -Original Message- > From: Koivu, Lisa [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 04, 2003 10:40 AM > To: Multiple recipients of list ORACLE-L > Subject: FW: Shite of the day > > > 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=1764 > 462&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: Wolfe Stephen S GS-11 6 MDSS/SGSI 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).
RE: Shite of the day
Lisa, Did you do the upgrade manually or via the GUI? I'm interested because I'm looking forward to 20 upgrades several of which will have to be done in place as their too big otherwise. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, June 04, 2003 10:40 AM 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: Goulet, Dick 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).