| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: 8174 32 bit to 9204 64 big
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
-- 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
 |
 |