Hi,
I found following errors in the alert log file.
Tue Jan 05 18:04:57 2016
Process startup failed, error stack:
Errors in file /app/cord033/01/admin/diag/rdbms/cord033d/CORD033D/trace/CORD033D_psp0_24314090.trc:
ORA-27300: OS system dependent operation:fork failed with status: 12
ORA-27301: OS failure message: Not enough space
ORA-27302: failure occurred at: skgpspawn3
my findings
SQL> show parameter processes
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 1
db_writer_processes integer 1
gcs_server_processes integer 0
global_txn_processes integer 1
job_queue_processes integer 0
log_archive_max_processes integer 4
processes integer 500
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) unlimited
stack(kbytes) 4194304
memory(kbytes) unlimited
coredump(blocks) 2097151
nofiles(descriptors) unlimited
threads(per process) unlimited
processes(per user) unlimited
A note I found in the google
ORA-27300: OS system dependent operation: string failed with status: string
Cause: OS system call error
Action: Contact Oracle Support
I noted that the maximum user process for this server was set to 2047 and when I check the total number of process it is reaching the OS limit,
causing the ORA-27300 error. We need to check the "processes" Oracle parameter to ensure that it is large enough and we also need to increase
the process limit to fix the ORA-27300 error and here are the commands for each OS:
The above trace file CORD033E_psp0_27066454.trc contains the same errors as above
Max processes allowed per user 4096
Could you please comment on this issue?
Oracle -- 11.2.0.3.0
OS -- AIX
Regards,
Bala