Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-27102 SVR4 Error: 12: Not enough space

lrpJun 1 2009 — edited Apr 1 2010
Our Oracle 11.1.0.7 database is running on Solaris 10 / Sunfire hardware. Unfortunately, we've been seeing our database crash and corrupt a datafile in the process several times. The key alert log message is below (which I've blanked out some info for security purposes):
KCF: write/open error block=0xbc28 online=1
file=6 /***************.dbf
error=27063 txt: 'SVR4 Error: 12: Not enough space
Additional information: -1
Additional information: 8192'

KCF: write/open error block=0x1571 online=1
file=57 *************.dbf
error=27063 txt: 'SVR4 Error: 12: Not enough space
Additional information: -1
Additional information: 8192'
Automatic datafile offline due to write error on
file 57: ***********.dbf
I've already done a forum search for the error codes but couldn't find any other post that matched my exact situation/code. The key coincidence here is that the number 8192 matches a value in my ulimit (stack size). Below is what I would currently see as my oracle user:
ulimit -a
core file size (blocks, -c) unlimited
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
open files (-n) 256
pipe size (512 bytes, -p) 10
stack size (kbytes, -s) 8192  <-------------
cpu time (seconds, -t) unlimited
max user processes (-u) 29995
virtual memory (kbytes, -v) unlimited
Oracle's documentation doesn't give me much information on what ORA-27063 means. Does anybody else know how Oracle reports 'Error 12:" codes coming from the OS? What the "additional information: -1" or "additional information: 8192" means? I need this in my troubleshooting so we can measure and adjust the correct resource, instead of blindly increasing stack size or other resource parameters on the OS.

Comments

843830
Not sure about this that i will tell you, but have u tried to do this in a loop??

.........
Message message[] = folder.getMessages();

for (int i=0, n=message.length; i<n; i++) {
Multipart mp = (Multipart)message.getContent();
.........


...just a thought, i am trying this also at this time
843830
...ah something else also...

i just add "activation.jar" in the libraries and it is working for me (just to get the ConentType from an e-mail)

You can find it in tomcat\common\lib, if u have apache tomcat.
Thats all until now, i will keep trying
843834
I'm getting the same exception on several "bounce" messages I try to access with JavaMail. I believe that some of them are flat-out wrong in their MIME encoding, as there truly is no start boundary. However, some appear to be OK and causing JavaMail to give an exception. Should this be logged as a bug?

Here's an example similar to yours (I didn't include all the received headers and several addresses are munged):

<blockquote><i>{noformat}Date: Sat, 19 Apr 2008 06:57:46 -0400
From: owner-LISTSERV@LISTS.NETSPACE.ORG
Subject: Undelivered mail
To: x
Message-ID: <x@LISTS.NETSPACE.ORG>
MIME-Version: 1.0
Content-Type: multipart/report; report-type=delivery-status;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;boundary="--TKFLZMMSbcaBDNCJdCBMaXGSRbVIAF"

--TKFLZMMSbcaBDNCJdCBMaXGSRbVIAF<br />

--> Error description:
Error-For: x@LISTS.NETSPACE.ORG
Error-Code: 5.1.1
Error-Text: No such list.

Error-End: One error reported.

--TKFLZMMSbcaBDNCJdCBMaXGSRbVIAF<br />
Content-Type: message/delivery-status

Reporting-MTA: dns; LISTS.NETSPACE.ORG

Final-Recipient: RFC822; x@LISTS.NETSPACE.ORG
Action: failed
Status: 5.1.1 (No such list)

--TKFLZMMSbcaBDNCJdCBMaXGSRbVIAF<br />
Content-Type: message/rfc822

Return-Path: <x>
X-Original-To: x@lists.netspace.org
Received: from ppp91-122-170-233.pppoe.avangarddsl.ru (ppp91-122-170-233.pppoe.avangarddsl.ru [91.122.170.233]) by lists.netspace.org (Postfix) with ESMTP id 538527A53A for <x@lists.netspace.org>; Sat, 19 Apr 2008 06:57:45 -0400 (EDT)
Received: from [91.122.170.233] by mx1.bne.server-mail.com; Sat, 19 Apr 2008 14:06:15 +0300
Message-ID: <01c8a226$87bfa580$e9aa7a5b@retentioncal53>
From: "x" <x>
To: <x@lists.netspace.org>
Subject: The extracts of VPXL are Pueraria tuberose 75 mg, Mucuna pruriens 75 mg, Asteracantha longifolia 75 mg.
Date: Sat, 19 Apr 2008 14:06:15 +0300
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="Windows-1252"; reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2741.2600
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2741.2600

TKFLZMMSbcaBDNCJdCBMaXGSRbVIAF{noformat}
</i></blockquote>
Bill Shannon-Oracle
The message is improperly constructed.

Note that the boundary parameter is "--TKFLZMMSbcaBDNCJdCBMaXGSRbVIAF",
which should appear in the message as a line that looks like:

----TKFLZMMSbcaBDNCJdCBMaXGSRbVIAF

As you can see, they incorrectly included the leading "--" in the boundary parameter value.
You should report this bug to the owner of the software or host that created this message.

As a workaround, create a copy of the message (using the MimeMessage copy constructor)
so that you can modify it, change the Content-Type header to remove the boundary parameter,
and set the System property "mail.mime.multipart.ignoremissingboundaryparameter" to "true".

(I should probably add another property to make it easy to ignore bogus boundary parameters.)
843834
I have identical problem. and possible to remove the boundary?
Bill Shannon-Oracle
As with the previous case, please report this bug to the owner of the software
that created this broken message.

If you're using JavaMail 1.4.3, there's a property that will cause JavaMail to
ignore the (bogus) boundary parameter in the message, and try to guess
what the boundary really is. See the javadocs for the javax.mail.internet package.
843834
ok thank you. I use JavaMail 1.4.3 as the command to ignore the boundary? thanks and sorry for my English amateur.
Bill Shannon-Oracle
Yes, use JavaMail 1.4.3.

Read the javadocs to find out which property to set.
1 - 8
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 29 2010
Added on Jun 1 2009
23 comments
17,160 views