广州活力数据恢复中心

 找回密码
 立即注册

QQ登录

只需一步,快速开始

Ora-27103 Internal Error Svr4 Error 11 Resource Temporarily Now

Set kernel.sem = 1500 32000 100 512 in sysctl.conf. The database started immediately. Conclusion The ORA-27103: internal error, svr4 error 11, resource temporarily unavailable is intimidating but almost never an Oracle code bug. It is the OS’s polite way of saying, “I’m too busy or too constrained to give you another resource right now.”

ALTER SYSTEM SET processes=800 SCOPE=SPFILE; Then restart. Check MyOracleSupport for known bugs matching your version (e.g., Bug 9854529 for Solaris 10). Case Study: A Real-World Example Symptom: After increasing the SGA from 8GB to 16GB, the database failed to start with ORA-27103.

ipcs -ls showed SEMMNI=128 . The database’s PROCESSES=1500 . Each Oracle process consumes a semaphore. With multiple instances, 128 semaphore sets were insufficient. Ora-27103 Internal Error Svr4 Error 11 Resource Temporarily

kernel.sem = 500 32000 100 256 # SEMMSL, SEMMNS, SEMOPM, SEMMNI Apply: sysctl -p Edit /etc/security/limits.conf :

ORA-27300: OS system dependent operation:fork failed with status: 11 ORA-27301: OS failure message: Resource temporarily unavailable ORA-27302: failure occurred at: skgpspawn3 This confirms the OS failed to fork a new process. Run: Set kernel

Introduction If you are an Oracle Database Administrator (DBA) working on Unix/Linux-based systems (Solaris, AIX, Linux), you might occasionally encounter the cryptic error:

By systematically checking semaphore limits, process limits, and memory parameters, you can resolve this error quickly and prevent it from recurring. Always monitor resource usage trends to catch exhaustion before it brings down production. Have you encountered ORA-27103 in your environment? Share your troubleshooting story in the comments below. It is the OS’s polite way of saying,

cat /proc/sys/kernel/sem # Output: 250 32000 100 128 # Fields: SEMMSL, SEMMNS, SEMOPM, SEMMNI Increase SEMMNI or SEMMSL via sysctl if needed. Switch to the Oracle user and run:

oracle soft nproc 65536 oracle hard nproc 65536 Reboot or re-login as oracle. If the instance is misconfigured:

QQ|小黑屋|硬盘FLASH数据恢复论坛

GMT+8, 2025-12-14 16:13 , Processed in 0.039127 second(s), 19 queries .

Powered by Discuz! X3.4

Copyright © 2001-2020, Tencent Cloud.

快速回复 返回顶部 返回列表