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:
kernel.sem = 500 32000 100 256 # SEMMSL, SEMMNS, SEMOPM, SEMMNI Apply: sysctl -p Edit /etc/security/limits.conf :
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.
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:
kernel.sem = 500 32000 100 256 # SEMMSL, SEMMNS, SEMOPM, SEMMNI Apply: sysctl -p Edit /etc/security/limits.conf : Ora-27103 Internal Error Svr4 Error 11 Resource Temporarily
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. Ora-27103 Internal Error Svr4 Error 11 Resource Temporarily