To resolve the issue, one needs to perform following steps for Oracle Database:
1. Increase SGA (sga_target and sga_max_size)
2. Increase shared_pool.
3. Increase shared_pool_reserved_size.
4. Or set _SHARED_POOL_RESERVED_PCT=10 - this setting will make sure that there is always 10% reserved size available of shared pool.
Post increasing Shared pool memory kindly start scheduler and execute "chk_auto_up -r 111" to verify whether jobs are running to success.