<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#ffffff">
Hi Roye,<br>
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<br>
Please set l_sga=2 and do a cleanup before starting run. <br>
olt-schedule -k <master node> -z<br>
<br>
<br>
Thanks,<br>
-Sangeeta <br>
<blockquote cite="mid:53014E83.4020405@oracle.com" type="cite">
-------- Original Message --------
<table class="moz-email-headers-table" border="0" cellpadding="0"
cellspacing="0">
<tbody>
<tr>
<th nowrap="nowrap" valign="BASELINE" align="RIGHT">Subject:
</th>
<td>[Olt-users] rac-st-asmlib1 fails on ORA-04031: unable to
allocate 65560 bytes of shared memory</td>
</tr>
<tr>
<th nowrap="nowrap" valign="BASELINE" align="RIGHT">Date: </th>
<td>Fri, 14 Feb 2014 22:48:18 +0000</td>
</tr>
<tr>
<th nowrap="nowrap" valign="BASELINE" align="RIGHT">From: </th>
<td>Roye Avidor <a moz-do-not-send="true"
class="moz-txt-link-rfc2396E"
href="mailto:royea@virident.com"><royea@virident.com></a></td>
</tr>
<tr>
<th nowrap="nowrap" valign="BASELINE" align="RIGHT">To: </th>
<td><a moz-do-not-send="true"
class="moz-txt-link-abbreviated"
href="mailto:olt-users@oss.oracle.com">olt-users@oss.oracle.com</a>
<a moz-do-not-send="true" class="moz-txt-link-rfc2396E"
href="mailto:olt-users@oss.oracle.com"><olt-users@oss.oracle.com></a></td>
</tr>
</tbody>
</table>
<br>
<br>
<meta http-equiv="Content-Type" content="text/html;
charset=ISO-8859-1">
<meta name="Generator" content="Microsoft Word 14 (filtered
medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif][if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal">Hi all, <o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I’m trying to run the OLT package on a
2-node RAC cluster.<o:p></o:p></p>
<p class="MsoNormal">I have 64GB of Ram on each servers, and 32
cores.<o:p></o:p></p>
<p class="MsoNormal">I’m having difficulties on running the
rac-st-asmlib1 test.<o:p></o:p></p>
<div style="border-width: medium medium 3pt; border-style: none
none solid; border-color: -moz-use-text-color
-moz-use-text-color windowtext; padding: 0in 0in 1pt;">
<p class="MsoNormal" style="border: medium none; padding:
0in;">In the oltdbt2-dbcreate.log I found the following: <o:p></o:p></p>
</div>
<p class="MsoNormal">Connected to:<o:p></o:p></p>
<p class="MsoNormal">Oracle Database 12c Enterprise Edition
Release 12.1.0.1.0 - 64bit Production<o:p></o:p></p>
<p class="MsoNormal">With the Partitioning, Real Application
Clusters, Automatic Storage Management, OLAP,<o:p></o:p></p>
<p class="MsoNormal">Advanced Analytics and Real Application
Testing options<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">SQL> drop index icustomer1;<o:p></o:p></p>
<p class="MsoNormal">drop index icustomer1<o:p></o:p></p>
<p class="MsoNormal"> *<o:p></o:p></p>
<p class="MsoNormal">ERROR at line 1:<o:p></o:p></p>
<p class="MsoNormal">ORA-01418: specified index does not exist<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">SQL> set timing on;<o:p></o:p></p>
<p class="MsoNormal">SQL> create unique index icustomer1 on
customer (c_w_id, c_d_id, c_id)<o:p></o:p></p>
<p class="MsoNormal"> 2 initrans 100<o:p></o:p></p>
<p class="MsoNormal"> 3 parallel 10<o:p></o:p></p>
<p class="MsoNormal"> 4 pctfree 1<o:p></o:p></p>
<p class="MsoNormal"> 5 nologging<o:p></o:p></p>
<p class="MsoNormal"> 6 storage ( freelists 22 freelist
groups 4 )<o:p></o:p></p>
<p class="MsoNormal"> 7 tablespace icust1_0;<o:p></o:p></p>
<p class="MsoNormal">create unique index icustomer1 on customer
(c_w_id, c_d_id, c_id)<o:p></o:p></p>
<p class="MsoNormal">*<o:p></o:p></p>
<p class="MsoNormal">ERROR at line 1:<o:p></o:p></p>
<p class="MsoNormal">ORA-12801: error signaled in parallel query
server P00I<o:p></o:p></p>
<p class="MsoNormal">ORA-12853: insufficient memory for PX
buffers: current 3600K, max needed<o:p></o:p></p>
<p class="MsoNormal">591360K<o:p></o:p></p>
<p class="MsoNormal">ORA-04031: unable to allocate 65560 bytes
of shared memory ("large<o:p></o:p></p>
<div style="border-width: medium medium 3pt; border-style: none
none solid; border-color: -moz-use-text-color
-moz-use-text-color windowtext; padding: 0in 0in 1pt;">
<p class="MsoNormal" style="border: medium none; padding:
0in;">pool","unknown object","large pool","PX msg pool")<o:p></o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Looking at the tracefile, I have the
following :<o:p></o:p></p>
<p class="MsoNormal">Loading database.. Fri Feb 14 11:28:28 PST
2014 \n<o:p></o:p></p>
<p class="MsoNormal">Load database done. Fri Feb 14 11:33:59 PST
2014 \n<o:p></o:p></p>
<p class="MsoNormal">Create iwarehouse index.. Fri Feb 14
11:33:59 PST 2014 \n<o:p></o:p></p>
<p class="MsoNormal">createiwarehouse done. Fri Feb 14 11:34:00
PST 2014 \n<o:p></o:p></p>
<p class="MsoNormal">Create idistrict index.. Fri Feb 14
11:34:00 PST 2014 \n<o:p></o:p></p>
<p class="MsoNormal">createidistrict done. Fri Feb 14 11:34:00
PST 2014 \n<o:p></o:p></p>
<p class="MsoNormal">Create iitem index.. Fri Feb 14 11:34:00
PST 2014 \n<o:p></o:p></p>
<p class="MsoNormal">createiitem done. Fri Feb 14 11:34:00 PST
2014 \n<o:p></o:p></p>
<p class="MsoNormal">Create icustomer1 index.. Fri Feb 14
11:34:00 PST 2014 \n<o:p></o:p></p>
<p class="MsoNormal">createicustomer1 failed. Fri Feb 14
11:34:05 PST 2014 \n<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Anyone have a clue of a solution for the
above issue ? <o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thank, <o:p></o:p></p>
<p class="MsoNormal">Roye Avidor<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</blockquote>
</body>
</html>