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

[Roye Avidor]

Setting the l_sga to the value two resolved the issue.

Thank you,
Roye Avidor
Virident|HGST

From: sangeeta.dhundale at oracle.com [mailto:sangeeta.dhundale at oracle.com]
Sent: Monday, February 17, 2014 1:30 AM
To: olt-users at oss.oracle.com; Roye Avidor
Subject: Re: Fwd: [Olt-users] rac-st-asmlib1 fails on ORA-04031: unable to allocate 65560 bytes of shared memory

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><mailto:royea at virident.com>

To:

olt-users at oss.oracle.com<mailto:olt-users at oss.oracle.com> <olt-users at oss.oracle.com><mailto: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/20140218/9ead1b6a/attachment.html