spam.Michael_Gruetzner_at_gmx.de said...
(snip in several places)
>
> SMON: enabling tx recovery
> 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...
>
> >> 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
> >>
>
Since "row cache objects" are related to latches, how much SGA (System
Global Area) is reported when you "startup nomount"? It looks like your
SGA might not be large enuf. Is that really all you have in your
initdb1.ora file (db name and control files)? No SGA sizing info?
--
/Karsten
DBA > retired > DBA
Received on Wed Feb 19 2003 - 14:40:17 CST
