ora -00600 Internal error code
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: ora -00600 Internal error code

Hybrid View

  1. #1
    Join Date
    Mar 2002
    Posts
    14

    Exclamation

    Hello

    I have a problem that don´t let me connect sometimes, i have checked the alert file and it show me an error :

    ora - 00600 Internal error code , arguments
    [12333],[0],[2],[31].

    Please if someone knows how i can solve this problem, help me.


    Noemí

  2. #2
    Join Date
    Jul 2002
    Location
    Washington DC
    Posts
    110
    Hi,

    Did u check whehter block corruption is there ? chek it.Check trace file also.Bock corruption is there u wull have to solve it.If u have the support from oracle that is hte best way to solve the block corruption

    Mnaoj

  3. #3
    Join Date
    Mar 2002
    Posts
    14
    How can i check the block corruption ?

  4. #4
    Join Date
    Jun 2001
    Location
    Charlotte, NC
    Posts
    27
    Originally posted by Noemi
    How can i check the block corruption ?
    tHE ORA-600 ERROR messages is a generic messages. It could be caused for any number of reasons. You should try and look at the alert logs and trace files which should be located in your home directory or you can look in the init file to find the locations of these files.

    Seeing that you are unable to connect. You may want to look at the number you have your process limit set to.

  5. #5
    Join Date
    Jul 2002
    Location
    California
    Posts
    128
    To check the processes on Unix...

    ps -ef|grep oracleSID|wc -l

    *** Replace SID with your sid in question... ***

    i.e. for sid PSERV it would be:

    ps -ef|grep oraclePSRV|wc -l

    alapps

    Fast, Cheap, Reliable... Pick Two(2)

  6. #6
    Join Date
    Mar 2002
    Posts
    14
    I have checked the number of process that i have limit set , it is 150 .

    what else can i check ?

  7. #7
    Originally posted by mkumarnk
    Hi,

    Did u check whehter block corruption is there ? chek it.Check trace file also.Bock corruption is there u wull have to solve it.If u have the support from oracle that is hte best way to solve the block corruption

    Mnaoj
    hei,
    As far as i know, 12333 is not block corruption, it is because of network unstable, right?
    www.cnoug.org

  8. #8
    Join Date
    Feb 2000
    Posts
    175
    Hi,

    Yes - it looks like it could be a network problem - Below is an extract from Metalink - Hope it helps point you in the right direction....

    Regards
    Moff.

    ORA-600[12333] is reported with three additional numeric values when a request is being received from a network packet and the request code in the packet is not recognized.
    The error may have a number of different root causes. For example, a network error may have caused bad data to be received, or the client application may have sent wrong data, or the data in the network buffer may have been overwritten. Since there are many potential causes of this
    error, it is essential to have a reproducible testcase to correctly diagnose the underlying cause. If operating system network logs are available, it is advisable to check them for evidence of network failures which may indicate network transmission problems.

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