Re: Newbie needs help

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 )

Michael

> Michael Gruetzner wrote:
>

>> DA Morgan wrote:
>>
>>> Michael Gruetzner wrote:
>>>
>>>
>>>> Alistair Thomson wrote:
>>>>
>>>>> Hi
>>>>>
>>>>> You're just about there. Connected to an idle instance means that it's
>>>>> closed / shut. Type startup and Oracle will open and then you can 
>>>>> create a
>>>>> user etc...
>>>>>
>>>>> Alistair
>>>>>
>>>>
>>>> Ok, I typed startup, but now I get the following errors:
>>>> ORA-0178: failure in processing system parameters
>>>> LRM-00123: invalid character 2 found in the input file
>>>>
>>>> What input file does it mean??
>>>>
>>>> Thanks Michael
>>>
>>>
>>>
>>>
>>> It likely means there is something wrong with the init.ora or the 
>>> resulting
>>> spfile.
>>>
>>> Did you create the initSID.ora and/or the spfile or are they the 
>>> default from
>>> the installation?
>>>
>> I created a file called initdb1.ora and edited 
>> it(db_name=db1;control_files=(db1_control1, db1_control2)).
>> Then I started sqlplus and executed "connect / as sysdba" and "startup 
>> nomount"(it works now). After that, I get some Information about 
>> "System Global Area", "Fixed size", etc.
>> I think this looks good.
>> Now I try "create database db1;". This takes a while and it ends with:
>> "ERROR at line 1:
>>  ORA-01092: ORACLE instance terminated. Disconnection forced"
>>
>> This is where I'm stuck now ;-(.
>>
>> Michael
>>