by 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 *** SESSION ID:(9.5) 2002-09-18 23:08:18.000 ******** ERROR: PGA memory leak detected 34580 > 23036 ******** ****************************************************** 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
---------------------