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

Home -> Community -> Usenet -> c.d.o.server -> CREATE DATABASE creates "memory leak"

CREATE DATABASE creates "memory leak"

From: Michael J. Moore <hicamel_x_the_spam_at_attbi.com>
Date: Mon, 30 Sep 2002 00:07:25 GMT
Message-ID: <1BMl9.254808$Jo.107679@rwcrnsc53>


Has anybody encountered a similar problem? I am using WinXP and have one instance sucessfully running. Now I am trying to manually create a second instance.

Thanks, Mike

SQL> CREATE DATABASE test
  2 MAXINSTANCES 1
  3 MAXLOGFILES 5
  4 MAXDATAFILES 100
  5 DATAFILE 'oracle\oradata\test\system01.dbf' SIZE 325M REUSE   6 AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED   7 UNDO TABLESPACE "UNDOTBS" DATAFILE 'oracle\oradata\test\undotbs01.dbf'   8 SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED   9 CHARACTER SET WE8MSWIN1252

 10  logfile 'D:\oracle\oradata\test\redo01.log' size 100M reuse,
 11  'D:\oracle\oradata\test\redo02.log' size 100M reuse,
 12  'D:\oracle\oradata\test\redo03.log' size 100M reuse;
CREATE DATABASE test
*

ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced

Dump file d:\oracle\admin\test\bdump\test_ora_3252.trc

Wed Sep 18 23:08:18 2002

ORACLE V9.2.0.1.0 - Production vsnsta=0

vsnsql=12 vsnxtr=3

Windows 2000 Version 5.1 Service Pack 1, CPU type 586

Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production

With the Partitioning, OLAP and Oracle Data Mining options

JServer Release 9.2.0.1.0 - Production

Windows 2000 Version 5.1 Service Pack 1, CPU type 586

Instance name: test

Redo thread mounted by this instance: 0 <none>

Oracle process number: 0

3252

HEAP DUMP heap name="pga heap" desc=00209F18

extent sz=0x213c alt=84 het=32767 rec=0 flg=3 opc=3

parent=00000000 owner=00000000 nex=00000000 xsz=0x8214

EXTENT 0 addr=02EE23E4 Received on Sun Sep 29 2002 - 19:07:25 CDT

Original text of this message

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