Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-00600 help needed
If it is this error, which the first set of numbers seems to indicate. you need to look further into what is causing the database to dismount...
Cause:An attempt was made to open a database that is not mounted.
Action:Mount the database with the ALTER DATABASE command; then re-attempt to open the database.
Archibald <archibald_at_computer.org> wrote:
>
>I don't have access to Metalink, so i post you one of the numbers here.
>Most often 12333 can be found in the first pair of square brackets. It
>is followed by a simple SELECT statement. Can you help me or tell me
>where i can find some more information ? We do have some abnormal
>termination of processes logged in the trace files, too. They receive
>signal 11 which i think is a segmentation violation under UNIX (we do
>have an AIX 4.3.3).
>
>Luggy wrote:
>>
>> Sybrand is correct - ORA-00600 errors are catch-all messages which
>> refer to conditions not catered for in more explicit error messages.
>>
>> The most important part of the message is the set of numbers in square
>> brackets following the error number. The format is something like...
>>
>> ORA-00600 [1234] [5678] [90123]
>>
>> If you have access to Metalink, you could try searching for your
>> problem (search on the numbers in square brackets). Alternatively, post
>> them to this NG and I'll see if it is a problem I'm familiar with.
>>
>> Unfortunately, just saying that you are getting ORA-00600 messages
>> doesn't mean very much, as there are lots of problems which yield ORA-
>> 00600s.
>>
>> Dave.
>>
>> Sent via Deja.com
>> http://www.deja.com/
Received on Fri Dec 29 2000 - 15:47:38 CST