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 tristan.van.essen@(protected)

Reply:     1     2     3     4  

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://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)] 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.

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7233.69">
<TITLE>RE: Oracle 10 on linux</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->

<P DIR=LTR><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en
-us"><FONT COLOR="#000080" SIZE=2 FACE="Arial">Hi John,</FONT></SPAN></P>

<P DIR=LTR><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en
-us"><FONT COLOR="#000080" SIZE=2 FACE="Arial">&#8220;</FONT></SPAN><SPAN LANG=
"en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"><FONT COLOR="#000080
" SIZE=2 FACE="Arial">Google is your friend</FONT></SPAN><SPAN LANG="en-us"><
/SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"><FONT COLOR="#000080" SIZE=2
FACE="Arial">&#8230;&#8221;</FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG=
"en-us"></SPAN><SPAN LANG="en-us"><FONT COLOR="#000080" SIZE=2 FACE="Arial"> 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 COLOR="#000080" SIZE=2 FACE="Arial">Maybe
this helps you with your problem:</FONT></SPAN></P>

<P DIR=LTR><SPAN LANG="en-us"></SPAN><A HREF="http://ora-04031 (See ora-04031.ora-code.com).ora-code.com/">
<SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"><U><FONT
COLOR="#0000FF" SIZE=2 FACE="Arial">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 HREF="http://www.cryer.co.uk/brian
/oracle/ORA04031.htm"><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN
LANG="en-us"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">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 COLOR="#000080" SIZE=2 FACE="Arial">Regards
,</FONT></SPAN></P>

<P DIR=LTR><SPAN LANG="en-us"><FONT COLOR="#000080" SIZE=2 FACE="Arial">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=""><SPAN LANG="en-us"><FONT COLOR=
"#808080" SIZE=1 FACE="Arial">-- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
-- ---- ---- ---- ---- ---- ------</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 COLOR="#808080" SIZE=1 FACE="Arial">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 COLOR="#808080" SIZE=1 FACE="Arial"
>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 COLOR="#808080" SIZE=1 FACE="Arial"
>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 COLOR="#808080" SIZE=1 FACE="Arial">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 COLOR="#808080" SIZE=1 FACE="Arial">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 COLOR="#808080" SIZE=1 FACE="Arial">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 COLOR="#808080" SIZE=1 FACE="Arial">Email:
tristan.van.essen@(protected)</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 SIZE=2 FACE="Tahoma">__ ____ ____ ____ ____ ____ ____ ____ ____ __<BR
>
</FONT></SPAN><SPAN LANG="en-us"><B></B></SPAN><SPAN LANG="en-us"><B></B></SPAN
><SPAN LANG="en-us"><B><FONT SIZE=2 FACE="Tahoma">From:</FONT></B></SPAN><SPAN
LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"><FONT SIZE=2
FACE="Tahoma"> oracle-l-bounce@(protected) [<A HREF="mailto:oracle-l-bounce
@(protected)">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 SIZE=2 FACE="Tahoma">On Behalf Of</FONT></B></SPAN><SPAN LANG="en-us">
</SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"> <FONT SIZE=2 FACE="Tahoma"
>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 SIZE=2 FACE="Tahoma">Sent:</FONT></B></SPAN><SPAN
LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"><FONT SIZE=2
FACE="Tahoma"> 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 SIZE=2 FACE="Tahoma">To:</FONT></B></SPAN><SPAN
LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"><FONT SIZE=2
FACE="Tahoma"> '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 SIZE=2 FACE="Tahoma">Subject:</FONT></B></SPAN>
<SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"><FONT
SIZE=2 FACE="Tahoma"> Oracle 10 on linux</FONT></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 SIZE=2 FACE="Courier New">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 SIZE=2 FACE="Courier New">ORA-04031 (See ORA-04031.ora-code.com): unable
to</FONT></SPAN></P>

<P DIR=LTR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">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 SIZE=2 FACE="Courier New">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 SIZE=2 FACE="Arial">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 SIZE=2 FACE="Courier New">John Dunn</FONT></SPAN></P>

<P DIR=LTR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">Product
Consultant</FONT></SPAN></P>

<P DIR=LTR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">Direct Dial +44
(0) 117 373 6122</FONT></SPAN></P>

<P DIR=LTR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">Sefas Innovation
Ltd, CityPoint, Temple Gate, Bristol BS1 6PL, UK.</FONT></SPAN></P>

<P DIR=LTR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">Tel: +44(0) 117
373 6114</FONT></SPAN></P>

<P DIR=LTR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">Fax: +44 (0) 117
373 6115</FONT></SPAN></P>

<P DIR=LTR><SPAN LANG="en-us"><FONT SIZE=2 FACE="Courier New">www.sefas.com<
/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>

<div id="##disclaimer##"><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></BODY>
</HTML>