ORA-20008: Missing Init.ora parameter db_block_size
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: ORA-20008: Missing Init.ora parameter db_block_size

  1. #1
    Join Date
    Mar 2010
    Location
    North Carolina, USA
    Posts
    18

    ORA-20008: Missing Init.ora parameter db_block_size

    Hi All,

    Our database version is 11.1.0.7.0, Standard Edition, running on Linux 2.6.18-92.el5.

    When I run awr reports, I get several error messages at the top of the report, for example:

    ORA-20009: Missing System Statistic opened cursors current
    ORA-20008: Missing Init.ora parameter undo_management
    ORA-20008: Missing Init.ora parameter db_block_size

    When I Googled these errors, I found a post by someone who said if you set the parameter control_management_pack_access = 'DIAGNOSTIC+TUNING', then the errors would go away. I set that parameter on 03/18, but this morning I am still getting the same weird error messages from the awr report.

    Anybody have an idea about why Oracle is throwing these errors? I never saw these errors when I was using 10g Enterprise Edition....

    Thanks for any clues,
    OracleGirl

  2. #2
    Join Date
    Mar 2001
    Location
    India
    Posts
    57
    Hi,

    It is may be possible you are hitting some bug of Oracle. Generaly these type of errors are throwing due to some problem in AWR statistics generation. Kindly raise SR to Oracle support.
    Thanks and Regards,
    Gitesh Trivedi
    Dbametrix Solutions
    Database DBA support

  3. #3
    Join Date
    Mar 2010
    Location
    North Carolina, USA
    Posts
    18
    Yep I think I will - as soon as I can get a valid CSI from my boss.

    Thanks folks....

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