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 Go to next message
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
Re: Error creating database in windows xp with db_block_size = 8192 in oracle 9i [message #256695 is a reply to message #256683] Mon, 06 August 2007 06:24 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ You should take another version than 9.0 which was the most buggy version that Oracle never releases.
2/ The problem comes from a corrupt redo logs not the create database.
Did you remove/delete the redo logs between your test? If no, do it, do not reuse the same file.

Btw, it'd be good you read How to format your posts.
Make sure that lines of code do not exceed 80 or 100 characters when you format.

Regards
Michel
Re: Error creating database in windows xp with db_block_size = 8192 in oracle 9i [message #260883 is a reply to message #256695] Tue, 21 August 2007 03:19 Go to previous message
samg4ug
Messages: 33
Registered: July 2007
Location: India
Member
The database is finally created but manually. DBCA is still unable to create a database with 8192b or 8kb db_block_size.

Thanks.

Sam G
Previous Topic: Password Verify Function.
Next Topic: Real time scenarios of performance issues.
Goto Forum:
  


Current Time: Fri Mar 29 03:28:34 CDT 2024