Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Newbie needs help

Re: Newbie needs help

From: Michael Gruetzner <Michael_Gruetzner_at_gmx.de>
Date: Wed, 19 Feb 2003 20:13:35 +0100
Message-ID: <3E53D75F.8090306@gmx.de>


Sybrand Bakker wrote:

> "Michael Gruetzner" <spam.Michael_Gruetzner_at_gmx.de> wrote in message
> news:3E51F5F9.8050004_at_gmx.de...
> 

>>Ron Reidy wrote:
>>
>>>Michael,
>>>
>>>Did you ...
>>>
>>>1. Read the admin and concepts docs before you started?
>>>2. Set your shared memory and semaphore parameters as recommed\nded by
>>>the above docs?
>>>3. Check your alert log for the problem?
>>>
>>
>>Yes, I read the admin manual. I set the semaphore and shared memory
>>parameters as discribed in the install manual( I couldn't find any of
>>them in the admin manual ).
>>At the end of the alert log I found the following:
>>
>>SMON: enabling tx recovery
>>Tue Feb 18 09:47:06 2003
>>Errors in file /opt/oracle/OraHome1/rdbms/log/db1_ora_718.trc:
>>ORA-00600: internal error code, arguments: [525], [0x50F5D234], [4],
>>[row cache objects], [2], [0x50017ED4], [child cursor hash table], []
>>Tue Feb 18 09:47:10 2003
>>Errors in file /opt/oracle/OraHome1/rdbms/log/db1_ora_718.trc:
>>ORA-01501: CREATE DATABASE failed
>>ORA-00600: internal error code, arguments: [525], [0x50F5D234], [4],
>>[row cache objects], [2], [0x50017ED4], [child cursor hash table], []
>>Tue Feb 18 09:47:10 2003
>>Error 600 happened during db open, shutting down database
>>USER: terminating instance due to error 600
>>Instance terminated by USER, pid = 718
>>ORA-1092 signalled during: create database db1...
>>
>>So I looked at the db1_ora_718.trc, where I found a lot of numbers and
>>the same two errors(ORA-01501 and ORA-00600) at the end of the file.
>>While I executed the "CREATE DATABASE db1;" statement I watched the
>>memory use on another terminal and I found out, that free memory goes
>>down to less than 4MB. Could insufficient memory be the reason why the
>>creation of my database fails? ( I've got 256M of main memory )
>>
> 
> According to the specs you need 512 M minimum.
> 

I tried the same on a friend's machine(with 512MB) where exactly the same error occurs. The only difference is that he can use the gui tools (creating a database with dbca works on his machine, but sqlplus fails).

Michael

> Hth
> 
> 
> --
> Sybrand Bakker
> Senior Oracle DBA
> 
> to reply remove '-verwijderdit' from my e-mail address
> 
> 
Received on Wed Feb 19 2003 - 13:13:35 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US