On
creation of database through OEM with a block size of 32K is failing @
pre-requiste step(error is below).
[FATAL]
[DBT-11101] The block size (0MB) for the tablespace SYSAUX does not match the
configured block size (0MB).
ACTION:
To use block size of (0MB), set initialization parameter db_8k_cache_size.
On
checking the template file (QC_12201_32k_DB_TEMPLATE.dbt), default tablespaces
block sizes are explicitly set to “8192” where this doesn’t work, as the
database block size is set to “32K”. Per oracle, If we want to create
tablespaces with non-standard block size(other than database block size), we
may need to set the non standard block size buffers parameter
db_8k_cache_size to certain MB(per requirement), Legimate values are from
2K to 32K,so that the oracle can load the content of the datafile with the
block size of “8k” into “32k” buffer size.
For
now, created with dbca & tablespaces have been picked with blocksize of
32K (No issue). We might face issue only when mismatches happens.
TABLESPACE_NAME
BLOCK_SIZE
------------------------------
----------
SYSTEM
32768
SYSAUX
32768
UNDOTBS1
32768
TEMP
32768
USERS
32768
In
our case, since db blocksize and tablespace blocksize have mismatches, Assuming
that we may need to add “blocksize” parameter to ‘32K’ in the template” or “set
the ‘db_nk_cache_size’ parameter with certain memory.
Content
of template:
--
Refer below link for explanation :
https://docs.oracle.com/cd/