Dump file d:\oracle\product\10.2.0\db_1\admin\ora10g\bdump\alert_ora10g.log
Wed Feb 01 21:22:40 2012
ORACLE V10.2.0.3.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows NT Version V6.0 
CPU                 : 2 - type 586, 2 Physical Cores
Process Affinity    : 0x00000000
Memory (Avail/Total): Ph:986M/2037M, Ph+PgF:2850M/4308M, VA:1928M/2047M
Wed Feb 01 21:22:40 2012
Starting ORACLE instance (normal)
Wed Feb 01 21:31:26 2012
Starting ORACLE instance (normal)
Wed Feb 01 21:31:58 2012
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Shared memory segment for instance monitoring created
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as D:\oracle\product\10.2.0\db_1\RDBMS
Autotune of undo retention is turned off. 
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.3.0.
System parameters with non-default values:
  shared_pool_size         = 33554432
  control_files            = D:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\ORA10G\CONTROL101.CTL, D:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\ORA10G\CONTROL102.CTL, D:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\ORA10G\CONTROL103.CTL
  db_block_size            = 8192
  db_cache_size            = 33554432
  db_file_multiblock_read_count= 16
  instance_name            = OracleServiceora10g
  background_dump_dest     = D:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\ORA10G\BDUMP
  user_dump_dest           = D:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\ORA10G\UDUMP
  db_name                  = ora10g
  optimizer_mode           = choose
  star_transformation_enabled= true
  parallel_threads_per_cpu = 4
  parallel_automatic_tuning= TRUE
  query_rewrite_enabled    = true
  query_rewrite_integrity  = trusted
  pga_aggregate_target     = 31457280
Deprecated system parameters with specified values:
  parallel_automatic_tuning
End of deprecated system parameter listing
Wed Feb 01 21:32:00 2012
WARNING:Shared I/O Pool created with size=0 set size=0
MMAN started with pid=4, OS id=820
DBW0 started with pid=5, OS id=5648
LGWR started with pid=6, OS id=2828
CKPT started with pid=7, OS id=4692
SMON started with pid=8, OS id=5640
RECO started with pid=9, OS id=4840
MMON started with pid=10, OS id=1256
MMNL started with pid=11, OS id=5964
PSP0 started with pid=3, OS id=4792
PMON started with pid=2, OS id=2076
Wed Feb 01 21:52:07 2012
Shutting down instance: further logons disabled
Wed Feb 01 21:52:07 2012
Stopping background process MMNL
Wed Feb 01 21:52:08 2012
Stopping background process MMON
Wed Feb 01 21:52:09 2012
Shutting down instance (immediate)
License high water mark = 1
Wed Feb 01 21:52:09 2012
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Wed Feb 01 21:58:23 2012
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as D:\oracle\product\10.2.0\db_1\RDBMS
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =12
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.3.0.
System parameters with non-default values:
  shared_pool_size         = 33554432
  control_files            = D:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\ORA10G\CONTROL101.CTL, D:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\ORA10G\CONTROL102.CTL, D:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\ORA10G\CONTROL103.CTL
  db_block_size            = 8192
  db_cache_size            = 33554432
  db_file_multiblock_read_count= 16
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  undo_retention           = 3600
  instance_name            = OracleServiceora10g
  background_dump_dest     = D:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\ORA10G\BDUMP
  user_dump_dest           = D:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\ORA10G\UDUMP
  db_name                  = ora10g
  optimizer_mode           = choose
  star_transformation_enabled= true
  parallel_threads_per_cpu = 4
  parallel_automatic_tuning= TRUE
  query_rewrite_enabled    = true
  query_rewrite_integrity  = trusted
  pga_aggregate_target     = 31457280
Deprecated system parameters with specified values:
  parallel_automatic_tuning
End of deprecated system parameter listing
Wed Feb 01 21:58:23 2012
WARNING:Shared I/O Pool created with size=0 set size=0
PMON started with pid=2, OS id=5732
PSP0 started with pid=3, OS id=4308
MMAN started with pid=4, OS id=3092
DBW0 started with pid=5, OS id=4372
LGWR started with pid=6, OS id=5272
CKPT started with pid=7, OS id=1412
SMON started with pid=8, OS id=3380
RECO started with pid=9, OS id=5948
MMON started with pid=10, OS id=3996
MMNL started with pid=11, OS id=4564
Wed Feb 01 22:00:08 2012
CREATE DATABASE ora10g
MAXLOGFILES 5
MAXLOGMEMBERS 3
MAXLOGHISTORY 100
MAXDATAFILES 50
MAXINSTANCES 1
LOGFILE
GROUP 1 ('D:\oracle\product\10.2.0\db_1\oradata\ora10g\redo01.log') SIZE 50M,
GROUP 2 ('D:\oracle\product\10.2.0\db_1\oradata\ora10g\redo02.log') SIZE 50M,
GROUP 3 ('D:\oracle\product\10.2.0\db_1\oradata\ora10g\redo03.log') SIZE 50M
DATAFILE 'D:\oracle\product\10.2.0\db_1\oradata\ora10g\system01.dbf' SIZE 500M
AUTOEXTEND ON NEXT 10M
SYSAUX DATAFILE 'D:\oracle\product\10.2.0\db_1\oradata\ora10g\sysAUX01.dbf' SIZE 30M
AUTOEXTEND ON NEXT 10M
DEFAULT TABLESPACE USERS
DATAFILE 'D:\oracle\product\10.2.0\db_1\oradata\ora10g\USER01.dbf' SIZE 20M
AUTOEXTEND ON NEXT 1M
DEFAULT TEMPORARY TABLESPACE temp
TEMPFILE 'D:\oracle\product\10.2.0\db_1\oradata\ora10g\TEMP01.DBF' SIZE 1024M
AUTOEXTEND ON
UNDO TABLESPACE undotbs1
DATAFILE 'D:\oracle\product\10.2.0\db_1\oradata\ora10g\UNDOTBS01.dbf' SIZE 1024M
AUTOEXTEND ON
CHARACTER SET WE8MSWIN1252
Wed Feb 01 22:00:09 2012
Database mounted in Exclusive Mode
Wed Feb 01 22:00:13 2012
Successful mount of redo thread 1, with mount id 4093040680
Assigning activation ID 4093040680 (0xf3f6d828)
Thread 1 opened at log sequence 1
  Current log# 1 seq# 1 mem# 0: D:\ORACLE\PRODUCT\10.2.0\DB_1\ORADATA\ORA10G\REDO01.LOG
Successful open of redo thread 1
Wed Feb 01 22:00:13 2012
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Wed Feb 01 22:00:13 2012
SMON: enabling cache recovery
Wed Feb 01 22:00:13 2012
create tablespace SYSTEM datafile  'D:\oracle\product\10.2.0\db_1\oradata\ora10g\system01.dbf' SIZE 500M
AUTOEXTEND ON NEXT 10M

  default storage (initial 10K next 10K) EXTENT MANAGEMENT DICTIONARY online

Wed Feb 01 22:00:23 2012
Completed: create tablespace SYSTEM datafile  'D:\oracle\product\10.2.0\db_1\oradata\ora10g\system01.dbf' SIZE 500M
AUTOEXTEND ON NEXT 10M
  default storage (initial 10K next 10K) EXTENT MANAGEMENT DICTIONARY online
Wed Feb 01 22:00:23 2012
create rollback segment SYSTEM tablespace SYSTEM
  storage (initial 50K next 50K)

Completed: create rollback segment SYSTEM tablespace SYSTEM
  storage (initial 50K next 50K)
Wed Feb 01 22:00:23 2012
Errors in file d:\oracle\product\10.2.0\db_1\admin\ora10g\udump\ora10g_ora_984.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 40 bytes of shared memory ("shared pool","create unique index i_con2 o...","sql area","kksol : kksnsg")

Wed Feb 01 22:00:23 2012
Errors in file d:\oracle\product\10.2.0\db_1\admin\ora10g\udump\ora10g_ora_984.trc:
ORA-01501: CREATE DATABASE failed
ORA-01519: error while processing file '%ORACLE_HOME%\RDBMS\ADMIN\SQL.BSQ' near line 1725
ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 40 bytes of shared memory ("shared pool","create unique index i_con2 o...","sql area","kksol : kksnsg")

Error 1519 happened during db open, shutting down database
USER: terminating instance due to error 1519
Wed Feb 01 22:00:23 2012
Errors in file d:\oracle\product\10.2.0\db_1\admin\ora10g\bdump\ora10g_pmon_5732.trc:
ORA-01519: error while processing file '' near line 

Wed Feb 01 22:00:24 2012
Errors in file d:\oracle\product\10.2.0\db_1\admin\ora10g\bdump\ora10g_psp0_4308.trc:
ORA-01519: error while processing file '' near line 

Wed Feb 01 22:00:24 2012
Errors in file d:\oracle\product\10.2.0\db_1\admin\ora10g\bdump\ora10g_reco_5948.trc:
ORA-01519: error while processing file '' near line 

Wed Feb 01 22:00:24 2012
Errors in file d:\oracle\product\10.2.0\db_1\admin\ora10g\bdump\ora10g_lgwr_5272.trc:
ORA-01519: error while processing file '' near line 

Wed Feb 01 22:00:24 2012
Errors in file d:\oracle\product\10.2.0\db_1\admin\ora10g\bdump\ora10g_dbw0_4372.trc:
ORA-01519: error while processing file '' near line 

Wed Feb 01 22:00:24 2012
Errors in file d:\oracle\product\10.2.0\db_1\admin\ora10g\bdump\ora10g_ckpt_1412.trc:
ORA-01519: error while processing file '' near line 

Wed Feb 01 22:00:24 2012
Errors in file d:\oracle\product\10.2.0\db_1\admin\ora10g\bdump\ora10g_mman_3092.trc:
ORA-01519: error while processing file '' near line 

Wed Feb 01 22:00:24 2012
Errors in file d:\oracle\product\10.2.0\db_1\admin\ora10g\bdump\ora10g_smon_3380.trc:
ORA-01519: error while processing file '' near line 

Instance terminated by USER, pid = 984
ORA-1092 signalled during: CREATE DATABASE ora10g
MAXLOGFILES 5
MAXLOGMEMBERS 3
MAXLOGHISTORY 100
MAXDATAFILES 50
MAXINSTANCES 1
LOGFILE
GROUP 1 ('D:\oracle\product\10.2.0\db_1\oradata\ora10g\redo01.log') SIZE 50M,
GROUP 2 ('D:\oracle\product\10.2.0\db_1\oradata\ora10g\redo02.log') SIZE 50M,
GROUP 3 ('D:\oracle\product\10.2.0\db_1\oradata\ora10g\redo03.log') SIZE 50M
DATAFILE 'D:\oracle\product\10.2.0\db_1\oradata\ora10g\system01.dbf' SIZE 500M
AUTOEXTEND ON NEXT 10M
SYSAUX DATAFILE 'D:\oracle\product\10.2.0\db_1\oradata\ora10g\sysAUX01.dbf' SIZE 30M
AUTOEXTEND ON NEXT 10M
DEFAULT TABLESPACE USERS
DATAFILE 'D:\oracle\product\10.2.0\db_1\oradata\ora10g\USER01.dbf' SIZE 20M
AUTOEXTEND ON NEXT 1M
DEFAULT TEMPORARY TABLESPACE temp
TEMPFILE 'D:\oracle\product\10.2.0\db_1\oradata\ora10g\TEMP01.DBF' SIZE 1024M
AUTOEXTEND ON
UNDO TABLESPACE undotbs1
DATAFILE 'D:\oracle\product\10.2.0\db_1\oradata\ora10g\UNDOTBS01.dbf' SIZE 1024M
AUTOEXTEND ON
CHARACTER SET WE8MSWIN1252...