Last updated on APRIL 28, 2009
Applies to:Oracle Server - Enterprise Edition - Version: 10.2.0.3
This problem can occur on any platform.
-- Problem Statement:
ORA-15021 for "__shared_pool_size" while starting ASM instance
-- Steps To Reproduce:
After an ASM instance is started using an spfile and sga_max_size is set, change shared_pool_size
value dynamically in either memory or both.
alter system set shared_pool_size scope=memory;
alter system set shared_pool_size scope=both;
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms