oracle soft nproc 65536 oracle hard nproc 65536 Reboot or re-login as oracle. If the instance is misconfigured:
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: Ora-27103 Internal Error Svr4 Error 11 Resource Temporarily
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: oracle soft nproc 65536 oracle hard nproc 65536