[Olt-users] Fwd: rac-st-asmlib1 fails on ORA-04031: unable to allocate 65560 bytes of shared memory

[sangeeta.dhundale at oracle.com]

Hi Roye,
Looks like some issue with SGA allocation. You can try to increase sga 
size for dbcreation at location 
/opt/oracle/oltest/.srchome/oltdbt2/src/scripts/oltdbt2-setupdbt2
Please set l_sga=2 and do a cleanup before starting run.
olt-schedule -k <master node> -z


Thanks,
-Sangeeta
> -------- Original Message --------
> Subject: 	[Olt-users] rac-st-asmlib1 fails on ORA-04031: unable to 
> allocate 65560 bytes of shared memory
> Date: 	Fri, 14 Feb 2014 22:48:18 +0000
> From: 	Roye Avidor <royea at virident.com>
> To: 	olt-users at oss.oracle.com <olt-users at oss.oracle.com>
>
>
>
> Hi all,
>
> I'm trying to run the OLT package on a 2-node RAC cluster.
>
> I have 64GB of Ram on each servers, and 32 cores.
>
> I'm having difficulties on running the rac-st-asmlib1  test.
>
> In the oltdbt2-dbcreate.log I found the following:
>
> Connected to:
>
> Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit 
> Production
>
> With the Partitioning, Real Application Clusters, Automatic Storage 
> Management, OLAP,
>
> Advanced Analytics and Real Application Testing options
>
> SQL> drop index icustomer1;
>
> drop index icustomer1
>
>            *
>
> ERROR at line 1:
>
> ORA-01418: specified index does not exist
>
> SQL> set timing on;
>
> SQL> create unique index icustomer1 on customer (c_w_id, c_d_id, c_id)
>
>   2    initrans    100
>
>   3    parallel    10
>
>   4    pctfree    1
>
>   5    nologging
>
>   6    storage ( freelists 22 freelist groups 4 )
>
>   7    tablespace       icust1_0;
>
> create unique index icustomer1 on customer (c_w_id, c_d_id, c_id)
>
> *
>
> ERROR at line 1:
>
> ORA-12801: error signaled in parallel query server P00I
>
> ORA-12853: insufficient memory for PX buffers: current 3600K, max needed
>
> 591360K
>
> ORA-04031: unable to allocate 65560 bytes of shared memory ("large
>
> pool","unknown object","large pool","PX msg pool")
>
> Looking at the tracefile, I have the following :
>
> Loading database.. Fri Feb 14 11:28:28 PST 2014 \n
>
> Load database done. Fri Feb 14 11:33:59 PST 2014 \n
>
> Create iwarehouse index.. Fri Feb 14 11:33:59 PST 2014 \n
>
> createiwarehouse  done. Fri Feb 14 11:34:00 PST 2014 \n
>
> Create idistrict index.. Fri Feb 14 11:34:00 PST 2014 \n
>
> createidistrict  done. Fri Feb 14 11:34:00 PST 2014 \n
>
> Create iitem index.. Fri Feb 14 11:34:00 PST 2014 \n
>
> createiitem  done. Fri Feb 14 11:34:00 PST 2014 \n
>
> Create icustomer1 index.. Fri Feb 14 11:34:00 PST 2014 \n
>
> createicustomer1 failed. Fri Feb 14 11:34:05 PST 2014 \n
>
> Anyone have a clue of a solution for the above issue ?
>
> Thank,
>
> Roye Avidor
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://oss.oracle.com/pipermail/olt-users/attachments/20140217/a1c398c0/attachment.html