Setting db_block_size..
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Setting db_block_size..

  1. #1
    Join Date
    Feb 2002
    Posts
    36
    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

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    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.

    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Once the db_block_size is determined at database creation, it can not be changed via the init.ora.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  4. #4
    Join Date
    Feb 2001
    Posts
    389
    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.

  5. #5
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    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
    Thanx
    Sam



    Life is a journey, not a destination!


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width