ORA:600
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: ORA:600

  1. #1
    Join Date
    Oct 2000
    Posts
    467
    Hi,
    I got an ora:600 on the alert log and tried to check the corresponding trace file which did give me the pid no. which caused the error. When i checked it in v$process the pid was not there - which means it was terminated on account. How do i get the details corresponding to this particular pid. I can do a restore until time but is there any other solution ?

    Cheers,
    Vinit

  2. #2
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    well, if the process is not here anymore, I guess you'll have difficulties in finding anything ... nevertheless what is important in ORA-00600 is to get the parameters.
    You should have sommething like :
    ORA-00600 [something1] [something2] ...
    the 1st argument tells which type of internal error it is, and it is needed to find if there is an answer to your problem

  3. #3
    Join Date
    Oct 2000
    Posts
    467
    the arguments are ORA-00600:internal error code, arguments[15709], [1],[1],[3]
    Any takers for this one ?

    Cheers,
    Vinit

  4. #4
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    are you loading data from PL/SQL and using parallel server ?? if so this could cause the error you have :

    This error is raised when there are problems with parallel query processing. This is a process failure and is non-corruptive.

    Try increasing the parallel_max_servers parameter in the init.ora.

    The bugs that I found on this error do not affect 8.1.7. If you continue to have the problem, please e-mail me the trace file generated from the ORA-600 (after increasing parallel_max_servers).

    else this could come from using a cursos in Pro*C ... do you use Pro*C ???

  5. #5
    Join Date
    Oct 2000
    Posts
    25
    Usually ORA-00600 appears when the database has invalid objects.
    Recompile all the invalid objects.
    That might help.

  6. #6
    Join Date
    Oct 2000
    Posts
    467
    Pipo,
    U're right..!! The problm was caused by parallel query. We're not using Pro*C though..!! Thanx..!!

    Cheers
    Vinit

  7. #7
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809

    Talking

    kewl

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