Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: ora-600 / ora-00604 during migrate
What was wrong with export?
How big the database is?
Igor Neyman, OCP DBA
ineyman_at_perceptron.com
-----Original Message-----
Jeroen van Sluisdam
Sent: Thursday, November 20, 2003 3:45 PM
To: Multiple recipients of list ORACLE-L
-----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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Igor Neyman
INET: ineyman_at_perceptron.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). Received on Thu Nov 20 2003 - 16:04:59 CST
![]() |
![]() |