Home » Other » Training & Certification » Error creating database in windows xp with db_block_size = 8192 in oracle 9i
Error creating database in windows xp with db_block_size = 8192 in oracle 9i [message #256683] |
Mon, 06 August 2007 05:39 |
samg4ug
Messages: 33 Registered: July 2007 Location: India
|
Member |
|
|
Dear All,
I am using Microsoft Windows XP [Version 5.1.2600] and Oracle9i Enterprise Edition Release 9.0.1.1.1. Now when I am trying to create a database using DBCA with "db_block_size = 8192" I am getting error 'Disconnection forced'. But when I am trying to create a database with "db_block_size = 4096", the database is created successfully. I am also giving the alertlog file for deeper analysis.-----------------------------------------------------------------------------------------------------------------------
Dump file D:\oracle\admin\secrmmis\bdump\secrmmisALRT.LOG
Mon Aug 06 15:00:33 2007
ORACLE V9.0.1.1.1 - Production vsnsta=0
vsnsql=10 vsnxtr=3
Windows 2000 Version 5.1 Service Pack 2, CPU type 586
Starting up ORACLE RDBMS Version: 9.0.1.1.1.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 209715200
large_pool_size = 10485760
java_pool_size = 58720256
control_files = D:\oracle\oradata\secrmmis\CONTROL01.CTL, D:\oracle\oradata\secrmmis\CONTROL02.CTL, D:\oracle\oradata\secrmmis\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 469762048
compatible = 9.0.0
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS
max_enabled_roles = 60
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = secrmmis
dispatchers = (PROTOCOL=TCP)(SER=MODOSE), (PROTOCOL=TCP)(PRE=oracle.aurora.server.GiopServer), (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)
background_dump_dest = D:\oracle\admin\secrmmis\bdump
user_dump_dest = D:\oracle\admin\secrmmis\udump
core_dump_dest = D:\oracle\admin\secrmmis\cdump
sort_area_size = 524288
db_name = secrmmis
open_cursors = 300
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
Mon Aug 06 15:00:38 2007
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Mon Aug 06 15:00:40 2007
Create controlfile reuse set database secrmmis
MAXINSTANCES 1
MAXLOGHISTORY 1
MAXLOGFILES 50
MAXLOGMEMBERS 5
MAXDATAFILES 100
Datafile
'D:\oracle\oradata\secrmmis\CWMLITE01.DBF' ,
'D:\oracle\oradata\secrmmis\DRSYS01.DBF' ,
'D:\oracle\oradata\secrmmis\EXAMPLE01.DBF' ,
'D:\oracle\oradata\secrmmis\INDX01.DBF' ,
'D:\oracle\oradata\secrmmis\SYSTEM01.DBF' ,
'D:\oracle\oradata\secrmmis\TOOLS01.DBF' ,
'D:\oracle\oradata\secrmmis\UNDOTBS01.DBF' ,
'D:\oracle\oradata\secrmmis\USERS01.DBF'
LOGFILE GROUP 1 ('D:\oracle\oradata\secrmmis\REDO01.LOG') SIZE 102400K,
GROUP 2 ('D:\oracle\oradata\secrmmis\REDO02.LOG') SIZE 102400K,
GROUP 3 ('D:\oracle\oradata\secrmmis\REDO03.LOG') SIZE 102400K RESETLOGS
Mon Aug 06 15:00:42 2007
Successful mount of redo thread 1, with mount id 370390489.
Mon Aug 06 15:00:42 2007
Completed: Create controlfile reuse set database secrmmis
MAX
Shutting down instance: further logons disabled
Shutting down instance (normal)
License high water mark = 1
Mon Aug 06 15:00:45 2007
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
Mon Aug 06 15:00:45 2007
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archiving is disabled
Shutting down archive processes
archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
archiving is disabled
Archive process shutdown avoided: 0 active
Mon Aug 06 15:00:48 2007
Starting ORACLE instance (normal)
Starting up ORACLE RDBMS Version: 9.0.1.1.1.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 209715200
large_pool_size = 10485760
java_pool_size = 58720256
control_files = D:\oracle\oradata\secrmmis\CONTROL01.CTL, D:\oracle\oradata\secrmmis\CONTROL02.CTL, D:\oracle\oradata\secrmmis\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 469762048
compatible = 9.0.0
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS
max_enabled_roles = 60
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = secrmmis
dispatchers = (PROTOCOL=TCP)(SER=MODOSE), (PROTOCOL=TCP)(PRE=oracle.aurora.server.GiopServer), (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)
background_dump_dest = D:\oracle\admin\secrmmis\bdump
user_dump_dest = D:\oracle\admin\secrmmis\udump
core_dump_dest = D:\oracle\admin\secrmmis\cdump
sort_area_size = 524288
db_name = secrmmis
open_cursors = 300
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
Mon Aug 06 15:00:54 2007
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Mon Aug 06 15:00:56 2007
Create controlfile reuse set database secrmmis
MAXINSTANCES 1
MAXLOGHISTORY 1
MAXLOGFILES 50
MAXLOGMEMBERS 5
MAXDATAFILES 100
Datafile
'D:\oracle\oradata\secrmmis\CWMLITE01.DBF' ,
'D:\oracle\oradata\secrmmis\DRSYS01.DBF' ,
'D:\oracle\oradata\secrmmis\EXAMPLE01.DBF' ,
'D:\oracle\oradata\secrmmis\INDX01.DBF' ,
'D:\oracle\oradata\secrmmis\SYSTEM01.DBF' ,
'D:\oracle\oradata\secrmmis\TOOLS01.DBF' ,
'D:\oracle\oradata\secrmmis\UNDOTBS01.DBF' ,
'D:\oracle\oradata\secrmmis\USERS01.DBF'
LOGFILE GROUP 1 ('D:\oracle\oradata\secrmmis\REDO01.LOG') SIZE 102400K,
GROUP 2 ('D:\oracle\oradata\secrmmis\REDO02.LOG') SIZE 102400K,
GROUP 3 ('D:\oracle\oradata\secrmmis\REDO03.LOG') SIZE 102400K RESETLOGS
Mon Aug 06 15:00:59 2007
Successful mount of redo thread 1, with mount id 370406889.
Mon Aug 06 15:00:59 2007
Completed: Create controlfile reuse set database secrmmis
MAX
Mon Aug 06 15:00:59 2007
alter database secrmmis open resetlogs
RESETLOGS after incomplete recovery UNTIL CHANGE 267823
Resetting resetlogs activation ID 0 (0x0)
***
Corrupt block relative dba: 0x0040013b (file 1, block 315)
Fractured block found during reading root dba
Data in bad block -
type: 13 format: 2 rdba: 0x0040013b
last change scn: 0x0000.0004162c seq: 0x1 flg: 0x04
consistency value in tail: 0x162c0d01
check value in block header: 0xb9f1, computed block checksum: 0x0
spare1: 0x0, spare2: 0x0, spare3: 0x0
***
Reread of rdba: 0x0040013b (file 1, block 315) found valid data
Mon Aug 06 15:01:08 2007
Assigning activation ID 370406889 (0x1613f5e9)
Thread 1 opened at log sequence 1
Current log# 3 seq# 1 mem# 0: D:\ORACLE\ORADATA\SECRMMIS\REDO03.LOG
Successful open of redo thread 1.
Mon Aug 06 15:01:08 2007
SMON: enabling cache recovery
Mon Aug 06 15:01:08 2007
Errors in file D:\oracle\admin\secrmmis\udump\ORA00288.TRC:
ORA-00379: no free buffers available in buffer pool DEFAULT for block size 4K
Mon Aug 06 15:01:08 2007
Error 379 happened during db open, shutting down database
USER: terminating instance due to error 379
Instance terminated by USER, pid = 288
ORA-1092 signalled during: alter database secrmmis open resetlogs...
Mon Aug 06 15:01:35 2007
Shutting down instance (abort)
I am also attaching the alert log file.
I hope you can guide me through proper way.
Thanks & Regards,
Sam G
|
|
|
|
|
Goto Forum:
Current Time: Sat Sep 28 08:15:03 CDT 2024
|