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: ora-600 / ora-00604 during migrate

RE: ora-600 / ora-00604 during migrate

From: Jeroen van Sluisdam <jeroen.van.sluisdam_at_vrijuit.nl>
Date: Fri, 21 Nov 2003 01:14:27 -0800
Message-ID: <F001.005D74F5.20031121011427@fatcity.com>


Problem solved thanks to ots
Event 1399 solved it, necessary during migrate

Regards,

Jeroen

-----Oorspronkelijk bericht-----

Van: DENNIS WILLIAMS [mailto:DWILLIAMS_at_LIFETOUCH.COM] Verzonden: Thursday, November 20, 2003 21:46 Aan: 'Jeroen van Sluisdam'
Onderwerp: RE: ora-600 / ora-00604 during migrate

Jeroen - I think at least for the U.S. that the form says something like "critical business impact". I have had a test database treated as a priority 1. At this point you could try calling on the phone and asking to change the priority. Or you could file another TAR and ensure it gets rated a priority 1.

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----

Sent: Thursday, November 20, 2003 2:42 PM To: DENNIS WILLIAMS; 'oracle-l_at_fatcity.com'

-----Oorspronkelijk bericht-----

Van: Jeroen van Sluisdam
Verzonden: donderdag 20 november 2003 21:41 Aan: 'DENNIS WILLIAMS'; 'oracle-l_at_fatcity.com' Onderwerp: RE: ora-600 / ora-00604 during migrate

Dennnis,

Priority 2. I have tried export but after 3 days of experimenting And not getting results I switched to this scenario How could I persuade them to go to priority 1 if this isn't A production situation?

Tnx,

Jeroen

-----Oorspronkelijk bericht-----

Van: DENNIS WILLIAMS [mailto:DWILLIAMS_at_LIFETOUCH.COM] Verzonden: donderdag 20 november 2003 21:24 Aan: 'ORACLE-L_at_fatcity.com'
CC: 'jeroen.van.sluisdam_at_vrijuit.nl'
Onderwerp: RE: ora-600 / ora-00604 during migrate

Jeroen - What priority did Oracle assign the TAR? Given the seriousness of your situation, you should get it rated a priority 1. Is there any possibility you can export/import your data instead of performing a migration?

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----

Sent: Thursday, November 20, 2003 2:15 PM To: Multiple recipients of list ORACLE-L

Hi,  

I'm experiencing an ora-600 during migration of a 7.3.4 to 9.2.0.4

Error occurs during issueing alter database open resetlogs migrate

All previous steps (all according to the migrate manual):

Migprep

Mig

Alter database convert

Succeeded successfully  

Details:

HP-UX 11.11

Source-DB 7.3.4.5 (HP11 version)

Target 9.2.0.4    

Error in alert-file:

Errors in file /var/opt/oracle/product/admin/VU_2/bdump/vu_2_smon_8589.trc: ORA-00604: error occurred at recursive SQL level 1 ORA-00942: table or view does not exist
Thu Nov 20 16:42:11 2003
ALTER SYSTEM SET _system_trig_enabled=FALSE SCOPE=MEMORY; Thu Nov 20 16:42:11 2003
ALTER SYSTEM SET job_queue_processes=0 SCOPE=MEMORY; Thu Nov 20 16:42:11 2003
ALTER SYSTEM SET aq_tm_processes=0 SCOPE=MEMORY; Thu Nov 20 16:42:11 2003
Errors in file /var/opt/oracle/product/admin/VU_2/udump/vu_2_ora_9760.trc: ORA-00600: internal error code, arguments: [16608], [2], [0], [0xC0000000234BAB80], [], [], [], []  

I could find one similar notice on metalink but it didn't describe what they did to resolve this.

I entered a tar, but probably too late for today. I need help urgently because this is causing

Major problems in our timeschedule for testing and going live as planned in 2 weeks.  

Hope you can help soon,  

Regards,  

Jeroen

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jeroen van Sluisdam
  INET: jeroen.van.sluisdam_at_vrijuit.nl

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).
Received on Fri Nov 21 2003 - 03:14:27 CST

Original text of this message

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