ORA:00600: after export
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 20

Thread: ORA:00600: after export

  1. #1
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    340

    ORA:00600: after export

    hi
    i fot this error after export, database is in 9i

    . exporting synonyms
    . exporting views
    . exporting referential integrity constraints
    . exporting stored procedures
    EXP-00008: ORACLE error 600 encountered
    ORA-00600: internal error code, arguments: [17112], [0x41F8E010], [], [], [], [], [], []
    EXP-00000: Export terminated unsuccessfully
    Share on Google+

  2. #2
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    340
    Is it Reported as a Bug?
    what is the reason for this error?
    Share on Google+

  3. #3
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Are you using PGA_AGGREGATE_TARGET?

    Check Metalink Note:463747.1
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
    Share on Google+

  4. #4
    Join Date
    Oct 2006
    Location
    Mumbai
    Posts
    184
    What is the exact oracle version?
    Share on Google+

  5. #5
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    340
    Quote Originally Posted by pareshjavkar
    What is the exact oracle version?
    Oracle9i Enterprise Edition Release 9.2.0.4.0
    Last edited by gopu_g; 09-30-2008 at 12:39 AM.
    Thanks/Gopu
    Share on Google+

  6. #6
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    340
    Quote Originally Posted by PAVB
    Are you using PGA_AGGREGATE_TARGET?
    Sorry PAVB, i did,t get what you mean

    Check Metalink Note:463747.1
    i will check it
    Thanks/Gopu
    Share on Google+

  7. #7
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    340
    I checked the note.....

    but i got only this error when exporting... ORA:600....


    i did't get the below error...

    ORA-29516: Aurora assertion failure: Assertion failure at eoamig.c:699
    EOA runtime assertion failure:
    eoamig.c:699
    Current SQL statement for this session:
    BEGIN :STATUS := DBMS_JAVA.EXPORT_TEXT_CHUNK(:CHUNK, :LENGTH); END;
    Last edited by gopu_g; 09-30-2008 at 05:52 AM.
    Thanks/Gopu
    Share on Google+

  8. #8
    Join Date
    Oct 2006
    Location
    Mumbai
    Posts
    184
    Upgrade to 9.2.0.5.0 or higher and check if the error persists ...

    Regards,
    Paresh
    Share on Google+

  9. #9
    Join Date
    Jun 2006
    Location
    Chennai, INDIA
    Posts
    72

    Post

    Check Metalink doc id 153788.1 (ORA-600 Troubleshooter) this will help you what exactly the ORA - 600 arguments are?

    Select the version and enter the arguments listed in your ORA- 600.
    Share on Google+

  10. #10
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Quote Originally Posted by pareshjavkar
    Upgrade to 9.2.0.5.0 or higher and check if the error persists ...
    I see, you are ready to work for Oracle tier 1 support.

    You cannot be serious, nobody is upgrading to the next patchset every time you get an error; have you ever heard about "troubleshooting"?
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
    Share on Google+

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width