.ora-code.com

Links
• Home
• Oracle DBA Forum
Frequent Oracle Errors
•TNS:could not resolve the connect identifier specified
•Backtrace message unwound by exceptions
•invalid identifier
•PL/SQL compilation error
•internal error
•missing expression
•table or view does not exist
•end-of-file on communication channel
•TNS:listener unknown in connect descriptor
•insufficient privileges
•PL/SQL: numeric or value error string
•TNS:protocol adapter error
•ORACLE not available
•target host or object does not exist
•invalid number
•unable to allocate string bytes of shared memory
•resource busy and acquire with NOWAIT specified
•error occurred at recursive SQL level string
•ORACLE initialization or shutdown in progress
•archiver error. Connect internal only, until freed
•snapshot too old
•unable to extend temp segment by string in tablespace
•Credential retrieval failed
•missing or invalid option
•invalid username/password; logon denied
•unable to create INITIAL extent for segment
•out of process memory when trying to allocate string bytes
•shared memory realm does not exist
•cannot insert NULL
•TNS:unable to connect to destination
•remote database not found'>ora-02019
•exception encountered: core dump
•inconsistent datatypes
•no data found
•TNS:operation timed out
•PL/SQL: could not find program
•existing state of packages has been discarded
•maximum number of processes exceeded
•error signaled in parallel query server
•ORACLE instance terminated. Disconnection forced
•TNS:packet writer failure
•see ORA-12699
•missing right parenthesis
•name is already used by an existing object
•cannot identify/lock data file
•invalid file operation
•quoted string not properly terminated
Oracle 10 on linux

Oracle 10 on linux

2006-07-11       - By oracle sos
Reply:     1     2     3     4  

check the following configuration

your physical memory size,
32 or 64bit OS,
may consider using hugemem kernel instead of smp kernel in Linux,

before you make any changes in the database site.

You can try to flash your shared pool to see if this helps. (ALTER SYSTEM
FLUSH SHARED_POOL; )



Cindy




On 7/11/06, tristan.van.essen@(protected) <tristan.van.essen@(protected)>
wrote:
>
>  Hi John,
>
> "Google is your friend?" a wise man once said.
>
> Maybe this helps you with your problem:
>
> *http://ora-04031 (See ora-04031.ora-code.com).ora-code.com/* <http://ora-04031 (See ora-04031.ora-code.com).ora-code.com/>
>
> *http://www.cryer.co.uk/brian/oracle/ORA04031.htm*<http://www.cryer.co.uk
/brian/oracle/ORA04031.htm>
>
> Regards,
>
> Tristan
>
>
> -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ----
-- ----
>
> Tristan van Essen
>
> Accenture Technology Solutions AG
>
> Baslerstrasse 60
>
> CH-8048 Zürich
>
> Office: +41 44 405 3245
>
> Mobile: +41 79 654 0592
>
> Email: tristan.van.essen@(protected)
>
> __ ____ ____ ____ ____ ____ ____ ____ ____ __
> *****From:* oracle-l-bounce@(protected) [
> mailto:oracle-l-bounce@(protected) <oracle-l-bounce@(protected)>]***** On
> Behalf Of* John Dunn
> *****Sent:* Dienstag, 11. Juli 2006 10:23
> *****To:* 'oracle-l digest users'
> *****Subject:* Oracle 10 on linux
>
> I am running Oracle 10 R2  on linux with automatic memory management and
> keep getting the following error :
>
> ORA-04031 (See ORA-04031.ora-code.com): unable to
>
> allocate 3888 bytes of shared memory ("shared pool","unknown object","sga
>
> heap(1,0)","kglsim object batch"
>
> Anyone else seen this?
>
> John Dunn
>
> Product Consultant
>
> Direct Dial +44 (0) 117 373 6122
>
> Sefas Innovation Ltd, CityPoint, Temple Gate, Bristol BS1 6PL, UK.
>
> Tel: +44(0) 117 373 6114
>
> Fax: +44 (0) 117 373 6115
>
> www.sefas.com
>
>   This message is for the designated recipient only and may contain
> privileged, proprietary, or otherwise private information. If you have
> received it in error, please notify the sender immediately and delete the
> original. Any other use of the email by you is prohibited.
>

<div>check the following configuration</div>
<div>&nbsp;</div>
<div>your physical memory size, </div>
<div>32 or 64bit OS, </div>
<div>may consider using hugemem kernel instead of smp kernel in Linux,</div>
<div>&nbsp;</div>
<div>before you make any changes in the database site.</div>
<div>&nbsp;</div>
<div>You&nbsp;can try to flash your shared pool to see if this helps. (ALTER
SYSTEM FLUSH SHARED_POOL; )</div>
<div>&nbsp;</div>
<div>&nbsp;</div>
<div>&nbsp;</div>
<div>Cindy</div>
<div>&nbsp;</div>
<div>&nbsp;</div>
<div><br>&nbsp;</div>
<div><span class="gmail_quote">On 7/11/06, <b class="gmail_sendername"><a href=
"mailto:tristan.van.essen@(protected)">tristan.van.essen@(protected)</a></b>
&lt;<a href="mailto:tristan.van.essen@(protected)">tristan.van.essen
@(protected)
</a>&gt; wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0
.8ex; BORDER-LEFT: #ccc 1px solid">
<div>
<div>
<p dir="ltr"><span lang="en-us"></span><span lang="en-us"></span><span lang="en
-us"><font face="Arial" color="#000080" size="2">Hi John,</font></span></p>
<p dir="ltr"><span lang="en-us"></span><span lang="en-us"></span><span lang="en
-us"><font face="Arial" color="#000080" size="2">"</font></span><span lang="en
-us"></span><span lang="en-us"></span><span lang="en-us"><font face="Arial"
color="#000080" size="2">
Google is your friend</font></span><span lang="en-us"></span><span lang="en-us"
></span><span lang="en-us"><font face="Arial" color="#000080" size="2">?"</font>
</span><span lang="en-us"></span><span lang="en-us"></span><span lang="en-us">
<font face="Arial" color="#000080" size="2"> a wise man once said.</font></span
><span lang="en-us"></span><span lang="en-us"></span><span lang="en-us"></span><
/p>
<p dir="ltr"><span lang="en-us"><font face="Arial" color="#000080" size="2"
>Maybe this helps you with your problem:</font></span></p>
<p dir="ltr"><span lang="en-us"></span><a onclick="return top.js.OpenExtLink
(window,event,this)" href="http://ora-04031 (See ora-04031.ora-code.com).ora-code.com/" target="_blank"><span
lang="en-us"></span><span lang="en-us"></span><span lang="en-us">
<u><font face="Arial" color="#0000ff" size="2">http://ora-04031 (See ora-04031.ora-code.com).ora-code.com/<
/font></u></span><span lang="en-us"></span></a><span lang="en-us"></span><span
lang="en-us"></span><span lang="en-us"></span></p>
<p dir="ltr"><span lang="en-us"></span><a onclick="return top.js.OpenExtLink
(window,event,this)" href="http://www.cryer.co.uk/brian/oracle/ORA04031.htm"
target="_blank"><span lang="en-us"></span><span lang="en-us"></span>
<span lang="en-us"><u><font face="Arial" color="#0000ff" size="2">http://www
.cryer.co.uk/brian/oracle/ORA04031.htm</font></u></span><span lang="en-us"><
/span></a><span lang="en-us"></span><span lang="en-us"></span><span lang="en-us"
>
</span></p>
<p dir="ltr"><span lang="en-us"><font face="Arial" color="#000080" size="2"
>Regards,</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Arial" color="#000080" size="2"
>Tristan</font></span><span lang="en-us"></span><span lang="en-us"></span><span
lang="en-us"></span></p>
<p dir="ltr"><span lang="en-us"></span><span lang="en-us"></span><span lang="en
-us"></span><span lang="en-us"></span><a name="10c5cbecb0ddddb6_"><span lang="en
-us"><font face="Arial" color="#808080" size="1">-- ---- ---- ---- ---- ---- ---
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- -----
</font></span></a><span lang="en-us"></span><span lang="en-us"></span><span
lang="en-us"></span><span lang="en-us"></span></p>
<p dir="ltr"><span lang="en-us"></span><span lang="en-us"></span><span lang="en
-us"></span><span lang="en-us"><font face="Arial" color="#808080" size="1"
>Tristan van Essen</font></span><span lang="en-us"></span><span lang="en-us">
</span><span lang="en-us"></span><span lang="en-us"></span></p>
<p dir="ltr"><span lang="en-us"></span><span lang="en-us"></span><span lang="en
-us"></span><span lang="en-us"><font face="Arial" color="#808080" size="1"
>Accenture Technology Solutions AG</font></span><span lang="en-us">
</span><span lang="en-us"></span><span lang="en-us"></span><span lang="en-us"><
/span></p>
<p dir="ltr"><span lang="en-us"></span><span lang="en-us"></span><span lang="en
-us"></span><span lang="en-us"><font face="Arial" color="#808080" size="1"
>Baslerstrasse 60</font></span><span lang="en-us"></span><span lang="en-us">
</span><span lang="en-us"></span><span lang="en-us"></span></p>
<p dir="ltr"><span lang="en-us"></span><span lang="en-us"></span><span lang="en
-us"></span><span lang="en-us"><font face="Arial" color="#808080" size="1">CH
-8048 Zürich</font></span><span lang="en-us"></span><span lang="en-us">
</span><span lang="en-us"></span><span lang="en-us"></span></p>
<p dir="ltr"><span lang="en-us"></span><span lang="en-us"></span><span lang="en
-us"></span><span lang="en-us"><font face="Arial" color="#808080" size="1"
>Office: +41 44 405 3245</font></span><span lang="en-us"></span><span lang="en
-us">
</span><span lang="en-us"></span><span lang="en-us"> </span></p>
<p dir="ltr"><span lang="en-us"></span><span lang="en-us"></span><span lang="en
-us"></span><span lang="en-us"><font face="Arial" color="#808080" size="1"
>Mobile: +41 79 654 0592</font></span><span lang="en-us"></span><span lang="en
-us">
</span><span lang="en-us"></span><span lang="en-us"></span></p>
<p dir="ltr"><span lang="en-us"></span><span lang="en-us"></span><span lang="en
-us"></span><span lang="en-us"><font face="Arial" color="#808080" size="1">Email
: <a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:tristan
.van.essen@(protected)" target="_blank">
tristan.van.essen@(protected)</a></font></span><span lang="en-us"></span>
<span lang="en-us"></span><span lang="en-us"></span><span lang="en-us"></span><
/p>
<p dir="ltr"><span lang="en-us"></span><span lang="en-us"></span><span lang="en
-us"></span></p>
<p dir="ltr"><span lang="en-us"></span><span lang="en-us"></span><span lang="en
-us"><font face="Tahoma" size="2">__ ____ ____ ____ ____ ____ ____ ____ ____ __
<br></font></span><span lang="en-us"><b></b></span><span lang="en-us">
<b></b></span><span lang="en-us"><b><font face="Tahoma" size="2">From:</font><
/b></span><span lang="en-us"></span><span lang="en-us"></span><span lang="en-us"
><font face="Tahoma" size="2"> <a onclick="return top.js.OpenExtLink(window
,event,this)" href="mailto:oracle-l-bounce@(protected)" target="_blank">
oracle-l-bounce@(protected)</a> [<a onclick="return top.js.OpenExtLink(window
,event,this)" href="mailto:oracle-l-bounce@(protected)" target="_blank">mailto
:oracle-l-bounce@(protected)</a>]</font></span><span lang="en-us">
<b></b></span><span lang="en-us"><b></b></span><span lang="en-us"><b> <font
face="Tahoma" size="2">On Behalf Of</font></b></span><span lang="en-us"></span>
<span lang="en-us"></span><span lang="en-us"> <font face="Tahoma" size="2">
John Dunn<br></font></span><span lang="en-us"><b></b></span><span lang="en-us">
<b></b></span><span lang="en-us"><b><font face="Tahoma" size="2">Sent:</font></b
></span><span lang="en-us"></span><span lang="en-us"></span><span lang="en-us">
<font face="Tahoma" size="2"> Dienstag, 11. Juli 2006 10:23<br></font></span>
<span lang="en-us"><b></b></span><span lang="en-us"><b></b></span><span lang="en
-us"><b><font face="Tahoma" size="2">To:</font></b></span><span lang="en-us">
</span><span lang="en-us"></span><span lang="en-us"><font face="Tahoma" size="2
"> 'oracle-l digest users'<br></font></span><span lang="en-us"><b></b></span>
<span lang="en-us"><b></b></span><span lang="en-us"><b><font face="Tahoma" size=
"2">
Subject:</font></b></span><span lang="en-us"></span><span lang="en-us"></span>
<span lang="en-us"><font face="Tahoma" size="2"> Oracle 10 on linux</font></span
><span lang="en-us"></span></p></div>
<div><span class="e" id="q_10c5cbecb0ddddb6_1">
<p dir="ltr"><span lang="en-us"></span><span lang="en-us"></span><span lang="en
-us"><font face="Courier New" size="2">I am running Oracle 10 R2&nbsp; on linux
with automatic memory management and keep getting the following error :
</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Courier New" size="2">ORA-04031 (See ORA-04031.ora-code.com):
unable to</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Courier New" size="2">allocate 3888
bytes of shared memory (&quot;shared pool&quot;,&quot;unknown object&quot;,
&quot;sga</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Courier New" size="2">heap(1,0)
&quot;,&quot;kglsim object batch&quot;</font></span></p>
<p dir="ltr"><span lang="en-us"></span><span lang="en-us"></span><span lang="en
-us"><font face="Arial" size="2">Anyone else seen this?</font></span></p>
<p dir="ltr"><span lang="en-us"></span><span lang="en-us"></span><span lang="en
-us"><font face="Courier New" size="2">John Dunn</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Courier New" size="2">Product
Consultant</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Courier New" size="2">Direct Dial
+44 (0) 117 373 6122</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Courier New" size="2">Sefas
Innovation Ltd, CityPoint, Temple Gate, Bristol BS1 6PL, UK.</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Courier New" size="2">Tel: +44(0)
117 373 6114</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Courier New" size="2">Fax: +44 (0)
117 373 6115</font></span></p>
<p dir="ltr"><span lang="en-us"><font face="Courier New" size="2"><a onclick=
"return top.js.OpenExtLink(window,event,this)" href="http://www.sefas.com/"
target="_blank">www.sefas.com</a></font></span></p>
<p dir="ltr"><span lang="en-us"></span><span lang="en-us"></span><span lang="en
-us"></span></p>
<p dir="ltr"><span lang="en-us"></span><span lang="en-us"></span><span lang="en
-us"></span></p></span></div>
<div>
<div>
<p></p>
<p style="FONT-SIZE: x-small; FONT-FAMILY: Arial, Sans-Serif">This message is
for the designated recipient only and may contain privileged, proprietary, or
otherwise private information. If you have received it in error, please notify
the sender immediately and delete the original. Any other use of the email by
you is prohibited.
</p></div></div></div></blockquote></div><br>