Setting db_block_size..

[Siva]

Hi Friends,

I have changed the block size parameter in Initorcl.ora
file. Then I started database. It gives the following error message
ORA-00209: control file blocksize mismatch, check alert log for more info:
In the alert log file, I have found the following message
ORA-00218: block size 2048 of controlfile does not match DB_BLOCK_SIZE (4096)
So is that true, If I have changed any parameter in the initora file. I have to recreate a control file. Pl clarify me.
Thanks
Regards
Siva

[julian]

You have two options:

1. Return to the old block size.

2.. If you insist on the new one, follow the instructions in Metalink Note:1011167.7.

[marist89]

Once the db_block_size is determined at database creation, it can not be changed via the init.ora.

[gpsingh]

pre 9i, if u need to changethe db_block_size , u will need to recreate the database , even the primary and standby database have to have same db_block_size.

But from 9i , u can set db_block_size at tablespace level , but there r lot of things to keep in mind ,refer to the manuals.

[sambavan]

Looks like the version that you are running is before 9i. On such case, changing the db_block_size is not an option. It was set at the time of database creation. You cannot and should not try to change it. But as of 9i this options had been relaxed, which allows you to set different block size for different applications.

Sam