ORA-00845: MEMORY_TARGET not supported on this system

Friday, March 28th, 2008

Cause : The MEMORY_TARGET parameter was not supported on this operating system or /dev/shm was not sized correctly on Linux.
Action : Refer to documentation for a list of supported operating systems. Or, size /dev/shm to be at least the SGA_MAX_SIZE on each Oracle instance running on the system.

Popularity: 41% [?]

ORA-00823: Specified value of sga_target greater than sga_max_size

Friday, March 28th, 2008

Cause : The specified value of sga_target is greater than sga_max_size.
Action : Increase sga_max_size to match up with sga_target or decrease sga_target to match up with sga_maxsize.

Popularity: 19% [?]

ORA-00820: Specified value of sga_max_size is too small, needs to be at least stringM

Friday, March 28th, 2008

Cause : The specified value of sga_max_size is too small for the SGA to accommodate all of the necessary SGA components such as the log buffer, buffer pools, shared pool, etc.
Action : Set sga_max_size to the recommended value or reduce the values of any SGA component size parameters you have specified.

Popularity: 14% [?]

Close
E-mail It