Go to the FreeLists Home Page Home Signup Help Login
 



[oracle-l] || [Date Prev] [06-2004 Date Index] [Date Next] || [Thread Prev] [06-2004 Thread Index] [Thread Next]

RE: 9.2.0.5 core dumps, ORA-6000's ORA-07445

  • From: "M Rafiq" <rafiq9857@xxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 01 Jun 2004 16:53:56 -0400
It may be problem with your import of 8.0.5 stuff. Open an itar as you have no other option. You might have to run catalog and catproc scripts again on your 9.2.0.5 database.

Last week I encountered same type of issue. There was an import from 8.1.6(NT database) to 9.2.0.4 (Windows 2000) database resulting a lot of INVALID SYS OBJECTS. While compiling those using utlirp (when utlrp did not resolved invalids) I struck with ORA-600 (17069). Spent whole long weekend and finally ran catlog/catproc and resolved those issues.

Regards
Rafiq





From: DENNIS WILLIAMS <DWILLIAMS@xxxxxxxxxxxxx>
Reply-To: oracle-l@xxxxxxxxxxxxx
To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
Subject: RE: 9.2.0.5 core dumps, ORA-6000's ORA-07445
Date: Tue, 1 Jun 2004 15:20:19 -0500

Paula - I concur with Martha. No problems on 9.2.0.5. Actually, if you file
a TAR, you'll be forwarded to a ORA-0600 lookup. Or you can click the
following link.

http://metalink.oracle.com/metalink/plsql/ml2_gui.startup

Sometimes it finds something useful.

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams@xxxxxxxxxxxxx

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Martha Delgado
Sent: Tuesday, June 01, 2004 3:18 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: 9.2.0.5 core dumps, ORA-6000's ORA-07445


Hi, I have three databases in Oracle 9.2.0.5 and solaris 2.8 and I didn´t have these problems. They are all internal errors; perhaps you have some problems with your system parameters. Have you already verified them? regards,

Martha

-----Mensaje original-----
De: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]En nombre de
Paula_Stankus@xxxxxxxxxxxxxxx
Enviado el: Martes, 01 de Junio de 2004 04:48 p.m.
Para: oracle-l@xxxxxxxxxxxxx
Asunto: RE: 9.2.0.5 core dumps, ORA-6000's ORA-07445


Guys,


Having a lot of problems with some basic functions over a 9.2.0.5 database
on Solaris 2.9:

-Moving a table from tablespace A to tablespace B resulted in ORA-07445 and
database crash
-Importing from an export generated from Oracle 8.0.3 - resulted in ORA-600
errors and database crash
-Recompiling uncompiled objects resulted in core dump, database shutdown and
ORA-07445

Is anyone else running on this version of Oracle on Solaris and having
problems?  I dread opening the TAR as it is usually such a
overly-complicated, time-consuming process.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
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
-----------------------------------------------------------------

_________________________________________________________________
Express yourself with the new version of MSN Messenger! Download today - it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
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
-----------------------------------------------------------------




[ Home | Signup | Help | Login | Archives | Lists ]

All trademarks and copyrights within the FreeLists archives are owned by their respective owners.
Everything else ©2007 Avenir Technologies, LLC.