DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 18

Thread: URGENT : ORA-00600 internal error code

  1. #1
    Join Date
    Apr 2001
    Location
    Vadodara, India
    Posts
    249

    URGENT : ORA-00600 internal error code

    I have taken export from 8.1.7(win NT) and taken import of DMP file in 10.1.0(win NT) for testing purpose

    When i tried to compile my forms (Ver 6.0.5.33.0) The series of internal error code encounter. The exact error is

    ora-00600 internal error code, arguments [17069], [39843448],[],[]...


    If i compile that form in 8.1.7 DB and run it by connecting 10.1.0 DB then it will fine.

    I am facing only complilation problem with 10.1.0

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    have you searched on metalink? ORA-600 usually means open a tar

  3. #3
    Join Date
    Apr 2001
    Location
    Vadodara, India
    Posts
    249
    I donot have metalink support.

    Is there any incomability issue between 10g and forms 6.0.5.33.0?

  4. #4
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    before raising a TAR this could probably help.

    Courtesy of Marist89(Jeff Hunter).
    ORA_600s

  5. #5
    Join Date
    Apr 2001
    Location
    Vadodara, India
    Posts
    249
    Thanks for your reply

    I donot have metalink support.

    This link is for required metalink support.

  6. #6
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995

    Steps Up to Mic

    Why don't you have Metalink Support? You're an Oracle DBA that works for a company right?
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

  7. #7
    Join Date
    Apr 2001
    Location
    Vadodara, India
    Posts
    249
    Yes you are right, but presently i am facing this problem

    any solution??

    it will be very helpful to me.

  8. #8
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    Ok, Here is what Metalink says...
    PURPOSE:This article discusses the internal error "ORA-600 [17069]", what it means and possible actions. The information here is only applicable to the versions listed and is provided only for guidance.
    ERROR: ORA-600 [17069] [a]
    VERSIONS:
    versions 7.0 to 10.1
    DESCRIPTION:
    Failed to pin a library cache object after 50 attempts.
    ARGUMENTS:
    Arg [a] Library Cache Object Handle.
    FUNCTIONALITY:
    GENERIC LAYER
    IMPACT:
    PROCESS FAILURE
    NO DATA CORRUPTION
    SUGGESTIONS:
    It is possible to get this error on a long running process if the dependent object has been dropped or recompiled.
    If the error occurs on a procedure, attempt to recompile the procedure.
    For repeatable occurrences, please submit the trace files and alert.log to Oracle Support for further analysis.
    So, according to Oracle what you need to do to fix this problem is to open up a TAR imagine that?
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

  9. #9
    Join Date
    Apr 2001
    Location
    Vadodara, India
    Posts
    249
    Thank you very much for your co-operation

    I have checked log file and trace file but there is not log about this error.

    I am facing problem only while compiling the FORM. same FORM if i compile in 8.1.7 and run it using 10.1.0 then it will run fine. Even all FORMS of my application are run.


    And also i have marked one thing that the problem is with one library's procedures. i have tried to recompile the procedures of library but problem is same.

  10. #10
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    Hmmmm, Ok if you can't open a TAR up then here's what I suggest you do.
    1. sqlplus /nolog
    2. connect / as sysdba
    3. shutdown abort
    4. exit
    5. update resume
    6. Gather up personal belongings in cube
    7. Leave building
    8. look for a job with SQL server.
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

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