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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Glen Conway

Presumably the Query Results tab in 3.2 did not have a problem when you originally installed it. Possibly the loss of highlighting and context menu is due to corruption of user settings.  And if you migrated any corrupt settings to newer versions, that could be the problem with whatever 18.x version you have.  Otherwise you might suspect a mismatch between the versions of SQL Developer, Java, and some native driver on the OS.

Assuming Windows, exit and restart SQL Developer after renaming the system<yourSqlDevVersion> folder to something else in C:\Users\<yourUserID>\AppData\Roaming\SQL Developer.  That will create a fresh user settings folder, either with default values or values migrated from some earlier version, depending on your choice.

Final advice:  don't use extremely old versions of software unless you have a really good reason.

Cheers

User_EKWC5

Thanks Glen for the reply

I was using the version 3.2.09  earlier, and faced issue their, so upgraded to Version 18.4.0.376, Build 376.1900 which resolved the issue for few months. But again suddenly started facing the same problem V18 as well.

So uninstalled V18 and was trying to check if V3 has the issue or not by reinstalling V3.

I am using Windows. I tried to rename the directory as suggested by you, and started SQL Developer, but no luck.

I have already tried uninstalling V3 and reinstalling SQL developer V18 and renaming the directories in AppData\Roaming\SQL Developer but no luck.

Currently i have V18 installed on my machine.

Any other option you think?

Glen Conway
Answer

It is not clear to me whether your efforts at reinstalling V3 / V18 included migrating settings from a prior version or using fresh default settings.

Whenever there are issues with a new version with migrated settings, I always Export Connections from the prior version's Connections navigator tree, delete the user settings folder for the new version, then start up the new version, avoid migrating settings, and Import Connections from the prior version.

If that's not what you've already done, then try that, or even get the latest 19.4 and avoid migrating settings.

Another possibility could be (from the SQL Developer main toolbar) using Window > Reset WIndows To Factory Setting.

Good luck

Marked as Answer by User_EKWC5 · Sep 27 2020
User_EKWC5

Hey Glen,

I have tried to uninstall V18, removing AppData\Raoming\SQL Developer .. files and with both options i.e. importing the settings from previous version and using fresh default settings, but no luck .

Also i already tried the Factory reset option in past and also today i tried it but that also does not work.

I am trying with V1.5 now as thats the version where i can see the query results pane is accessible and i can copy something from there.

Thanks,

Glen Conway

Wow, V1.5, that really is a piece of history! The suggestion to use fresh, default user settings really should have worked. Just out of curiosity, what is your OS and OS version?

User_EKWC5

I installed V19 as you suggested, i did not import the settings from previous installations and that resolved the problem. Thanks.

By the way i am using Windows 10, 64 bit OS.

Glen Conway

Wonderful!  Really glad to know you are not mysteriously being blocked from using the latest / greatest SQL Developer.

Edit:  If the problem eventually comes back, that may suggest you have a pattern of use that leads to corruption of the user settings.  But hopefully not.

User_EKWC5

How can i mark this thread as Answered?

Glen Conway

You cannot do it from the Inbox, you actually have to open the thread:  See:

1 - 9
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,046 views