RE: Shite of the day

2003-06-06 Thread Koivu, Lisa
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 (now 9i upgrade)

2003-06-06 Thread Koivu, Lisa
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

RE: Shite of the day

2003-06-06 Thread Seefelt, Beth
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

RE: Shite of the day

2003-06-06 Thread Stephen Lee
: 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

RE: Shite of the day

2003-06-06 Thread Jacques Kilchoer
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

RE: Shite of the day

2003-06-05 Thread Boivin, Patrice J
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

RE: Shite of the day

2003-06-05 Thread Goulet, Dick
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:

RE: Shite of the day

2003-06-05 Thread Wolfe Stephen S GS-11 6 MDSS/SGSI
I agree with you Lisa ... g, 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

RE: Shite of the day

2003-06-05 Thread Koivu, Lisa
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

RE: Shite of the day

2003-06-05 Thread Ganesh Raja
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.

RE: Shite of the day

2003-06-05 Thread Koivu, Lisa
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

RE: Shite of the day

2003-06-05 Thread Jesse, Rich
- 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

RE: Shite of the day

2003-06-05 Thread Koivu, Lisa
- 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

RE: Shite of the day

2003-06-05 Thread Jacques Kilchoer
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

Re: Shite of the day (now 9i upgrade)

2003-06-05 Thread Binley Lim
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?