ORA-12853 and ORA-04031 simultaneously

[former_member759680]

Hello,

I am getting the following errors when I try to start Oracle

ORA-12853: insufficient memory for PX buffers: current 0K, max needed 2640K

ORA-04031: unable to allocate 21544 bytes of shared memory ("large pool","unknown object","large pool","PX msg pool")

My init.ora file is as follows -

______________________________________________________________________________

EDA.__db_cache_size=1174405120

EDA.__java_pool_size=33554432

EDA.__large_pool_size=0

EDA.__shared_pool_size=1174405120

EDA.__streams_pool_size=0

*._OPTIM_PEEK_USER_BINDS=FALSE

*.background_dump_dest='/oracle/EDA/saptrace/background'

*.compatible='10.2.0'

*.control_file_record_keep_time=30

*.control_files='/oracle/EDA/origlogA/cntrl/cntlrEDA.dbf','/oracle/EDA/origlogB/cntrl/cntrlEDA.dbf','/oracle/EDA/sapdata1/cntrl/cntrlEDA.dbf'

*.core_dump_dest='/oracle/EDA/saptrace/background'

*.db_block_size=8192

*.db_cache_size=1159641169

*.db_files=254

*.db_name='EDA'

*.dml_locks=4000

*.event='10191 trace name context forever, level 1'

*.FILESYSTEMIO_OPTIONS='setall'

*.job_queue_processes=1

*.log_archive_dest='/oracle/EDA/oraarch/EDAarch'

*.log_buffer=1048576

*.log_checkpoint_interval=0

*.log_checkpoints_to_alert=true

*.open_cursors=800

*.optimizer_features_enable='10.2.0.1'

*.pga_aggregate_target=1546188226

*.processes=80

*.recyclebin='off'

*.remote_login_passwordfile='exclusive'

*.remote_os_authent=true

*.sessions=96

*.sga_max_size=2319282339

*.sga_target=2399141888

*.shared_pool_reserved_size=115964116

*.shared_pool_size=1159641169

*.sort_area_retained_size=0

*.sort_area_size=2097152

*.statistics_level='typical'

*.undo_management='AUTO'

*.undo_retention=43200

*.undo_tablespace='PSAPUNDO'

*.user_dump_dest='/oracle/EDA/saptrace/usertrace'

*.workarea_size_policy='AUTO'

_______________________________________________________________________________

According to me everything looks fine. Kindly help me sort this error.

Thanks in advance.

[former_member204746 · Accepted solution]

it's about time you review SAP note 830576.

you will see, amongst other things, that shared_pool_size must be set to at least 400MB.