ORA-00383: DEFAULT cache for blocksize string cannot be
reduced to zero



ORA-00383: DEFAULT cache for blocksize string cannot be reduced to zero..

Answer / guest

Cause: User attempted to reduce db_cache_size to zero, or
attempted to to reduce db_<n>K_cache_size to zero while
there were still online tablespaces with blocksize <n>K.
Note that since the SYSTEM tablespace cannot be taken
offline, it is always illegal to set db_cache_size to zero.

Action: Offline any tablespaces with the corresponding
blocksize and then perform the operation again.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

RMAN-06124: error while looking up datafilecopy key: number

1 Answers  


TNS-00265: Navigator: Reloaded network configuration data

1 Answers  


RMAN-06463: Backup set key string cannot be backed up by proxy.

1 Answers  


ORA-12025: materialized view log on "string"."string" already has primary keys

1 Answers  


SQL*Loader-00288: Delimiters may not be specified for collections stored in SDF.

1 Answers  






NNO-00601: warning: no forwarders, DEFAULT-FORWARDERS-ONLY mode ignored

1 Answers  


DRG-11807: No Content

1 Answers  


ORA-13041: failed to compare tile with element string.string.string

1 Answers  


ORA-31691: The worker received message number string from the MCP, which is invalid.

1 Answers  


RMAN-08066: database reset to incarnation string

1 Answers  


ORA-01596: cannot specify system in string parameter

1 Answers  


ORA-24369: required callbacks not registered for one or more bind handles

1 Answers  


Categories