Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: 8174 32 bit to 9204 64 big

RE: 8174 32 bit to 9204 64 big

From: M Rafiq <rafiq9857_at_hotmail.com>
Date: Mon, 05 Apr 2004 15:25:48 -0400
Message-ID: <BAY99-F12GEbJ8MqU2x000054dc@hotmail.com>


Dennis,

I upgraded/migrated couple of database from 8.1.7.4 to 9.2.0.4 using export/import even with change of platform without any issues and those production databases are running fine. The sizes were around 5 G. However, after upgrade I have to change some scripts to avoid export errors by using statistics=none.

Regards
Rafiq

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM> Reply-To: oracle-l_at_freelists.org
To: "'oracle-l_at_freelists.org'" <oracle-l_at_freelists.org> Subject: RE: 8174 32 bit to 9204 64 big
Date: Sat, 3 Apr 2004 17:12:06 -0600

Branimir

    I did not tie it to a specific error. When I found I could not export I started looking up the error messages I was receiving and found some notes related to export. At that point I got really interested in upgrading. Once I did that, the problems went away except for one test database that nobody is using. I'm assuming that nobody is still on the unpatched version. Here are the error messages it still throws on export (after patch, I was receiving a different message before the patch):

EXP-00056: ORACLE error 4068 encountered
ORA-04068: existing state of packages has been discarded
ORA-04067: not executed, package body "SYS.DBMS_METADATA" does not exist

Fortunately nobody uses it, and I will probably refresh it by cloning production soon. I tried poking around on Metalink, but it seems to have taken the weekend off.

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Branimir Petrovic Sent: Saturday, April 03, 2004 10:55 AM
To: 'oracle-l_at_freelists.org'
Subject: RE: 8174 32 bit to 9204 64 big

> Over the years I have observed many more Oracle Bug reports on the
> upgrade process corrupting databases than import corrupting databases.
> Anyway that was my thinking until I discovered that 9.2.0.1
> Export could
> corrupt the dictionary.

Got a docID or link for this particular bug? (can not recognize it looking at patch set *.2 - *.5 lists of fixes)

Branimir



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

_________________________________________________________________
FREE pop-up blocking with the new MSN Toolbar  get it now! 
http://toolbar.msn.com/go/onm00200415ave/direct/01/

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Mon Apr 05 2004 - 14:22:14 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US