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

[Roye Avidor]

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/20140214/06016daa/attachment.html