Hi all,
Is it compatible Oracle 11g r2 (11.2.0.4) with OS (win 2016 64bit )? ...After installations on Win 2016 ,,,
error generating in alert logs see below
"ORA-00020: maximum number of processes"
Os info below
Note:
i have changed the process parameter values 1000 to 2000 for temporary....please advice me the correct solution.
Alert log info
---------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Windows NT Version V6.2
CPU : 4 - type 8664, 4 Physical Cores
Process Affinity : 0x0x0000000000000000
Memory (Avail/Total): Ph:7024M/24575M, Ph+PgF:10180M/28159M
Using parameter settings in server-side spfile D:\APP\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEORCL.ORA
System parameters with non-default values:
processes = 2000
sessions = 3024
sga_target = 14720M
control_files = "D:\APP\ORADATA\ORCL\CONTROL01.CTL"
control_files = "D:\APP\ORADATA\ORCL\CONTROL02.CTL"
db_block_size = 8192
compatible = "11.2.0.4.0"
undo_tablespace = "UNDOTBS1"
sec_case_sensitive_logon = FALSE
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=orclXDB)"
audit_file_dest = "D:\APP\ADMIN\ORCL\ADUMP"
audit_trail = "DB"
db_name = "orcl"
open_cursors = 3000
pga_aggregate_target = 4904M
diagnostic_dest = "D:\APP"
Error in Alert logs
Sun Jul 29 16:29:08 2018
Starting background process SMCO
Sun Jul 29 16:29:08 2018
SMCO started with pid=88, OS id=4892
Sun Jul 29 18:26:41 2018
ORA-00020: maximum number of processes (1000) exceeded
ORA-20 errors will not be written to the alert log for
the next minute. Please look at trace files to see all
the ORA-20 errors.
Sun Jul 29 18:33:50 2018
ORA-00020: maximum number of processes (1000) exceeded
ORA-20 errors will not be written to the alert log for
the next minute. Please look at trace files to see all
the ORA-20 errors.
Process m000 submission failed with error = 20
Sun Jul 29 18:43:51 2018
ORA-00020: maximum number of processes (1000) exceeded
ORA-20 errors will not be written to the alert log for
the next minute. Please look at trace files to see all
the ORA-20 errors.
Process m000 submission failed with error = 20
Sun Jul 29 18:53:53 2018
ORA-00020: maximum number of processes (1000) exceeded
ORA-20 errors will not be written to the alert log for
the next minute. Please look at trace files to see all
the ORA-20 errors.
Process m000 submission failed with error = 20
Sun Jul 29 19:03:55 2018
ORA-00020: maximum number of processes (1000) exceeded
ORA-20 errors will not be written to the alert log for
the next minute. Please look at trace files to see all
the ORA-20 errors.
Process m000 submission failed with error = 20
Process m001 submission failed with error = 20
Sun Jul 29 19:13:56 2018
Thx & regards
PKR