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
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
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
: 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
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
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
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:
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
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
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.
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
-
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
-
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
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
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?
15 matches
Mail list logo