Copy of Oracle FAQ | ORACLE RECOVERY without DUL |
Index >
ORACLE Server Parameters >
db_block_size
db_block_sizeOracle 10.0.1:
Oracle 9.2.0:
Oracle 8.1.7:
Oracle 8.0.6:
Oracle 7.3.4:
Related Error Messages:ORA-00058: DB_BLOCK_SIZE must be %s to mount this database (not %s)
Action: Fix the value of the DB_BLOCK_SIZE parameter or mount a database that matches the value. ORA-00209: control file blocksize mismatch, check alert log for more info
Action: Look at the alert log for more information. ORA-00218: block size %s of controlfile '%s' does not match DB_BLOCK_SIZE (%s)
Action: Restore a good copy of the controlfile. If the controlfile is known to be clean set the DB_BLOCK_SIZE to match controlfile headers block size value. ORA-00374: parameter db_block_size = %s invalid ; must be a multiple of %s in the range [%s..%s]
Action: adjust parameter and restart ORA-00375: unable to get default db_block_size
Action: see accompanying system specific error. As a workaround, specify the blocksize in the INIT.ORA file. ORA-06580: Hash Join ran out of memory while keeping large rows in memory
Action: Increase HASH_JOIN_MULTIBLOCK_IO_COUNT so that each joined row fits in a slot. HASH_AREA_SIZE may also need to be increaed. ORA-07303: ksmcsg: illegal database buffer size.
Action: Verify that the db_block_size parameter is correct in INIT.ORA. ORA-07305: ksmcsg: illegal database buffer size.
Action: Verify that the db_block_size parameter is correct in INIT.ORA, or disable the use_indirect_data_buffers parameter. ORA-07620: smscre: illegal database block size
Action: Change db_block_size in the parameter file to conform to these limits. ORA-09202: sfifi: error identifying file
Action: See OSD error accompanying this message
This parameter is documented in the Oracle Server Reference Guide. Search for more info about [ db_block_size ] on the Oracle FAQ.
|