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
rjesse_at_qtiworld.com                  Quad/Tech Inc, Sussex, WI USA

> -----Original Message-----
> From: Koivu, Lisa [mailto:Lisa.Koivu_at_Fairfieldresorts.com]
> 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: Rich.Jesse_at_qtiworld.com

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: ListGuru_at_fatcity.com (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: Lisa.Koivu_at_Fairfieldresorts.com

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: ListGuru_at_fatcity.com (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).