Database Database - General Oracle Error Messages ORA ORA-02097: parameter cannot be modified because specified value is invalid

Oracle Error Messages



Statistics

Content View Hits : 486782

Who's Online

We have 7 guests online
ORA-02097: parameter cannot be modified because specified value is invalid
User Rating: / 8
PoorBest 

ORA-02097

parameter cannot be modified because specified value is invalid

Cause:
Though the initialization parameter is modifiable, the modified value is not acceptable to the parameter.

Action:
Check the DBA guide for range of acceptable values for this parameter.

 


 

Sample:

SQL> alter system set db_32K_cache_size=32m;
   alter system set db_32K_cache_size=32m
   *

   ERROR at line 1:
   ORA-02097: parameter cannot be modified because specified value is invalid
  
ORA-00382: 32768 not a valid block size, valid range [2048..16384]


 NOTE:  Not all operating systems allow a 32K block size