该案例的参数配置不一定准确,请慎重配置
有2个环境,一个是11g单机环境,另外一个是19c的rac环境,操作系统都是Oracle linux 7.9
报错差异较大,通过配置kernel.randomize_va_space=0后再也没有报错,
环境1:
Mon Jul 17 16:19:42 2023
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_cjq0_3154.trc (incident=136695):
ORA-00445: background process "J000" did not start after 120 seconds
Incident details in: /u01/app/oracle/diag/rdbms/orcl/orcl/incident/incdir_136695/orcl_cjq0_3154_i136695.trc
环境2:
2022-03-31T12:09:09.510570+08:00
TMON (PID:155242): Process (PID:155435) hung on an I/O to LAD:1 after 256 seconds with threshold of 240 at [krse.c:8925]
TMON (PID:155242): WARN: Terminating process hung on an operation (PID:155435)
2022-03-31T12:09:16.488408+08:00
TMON (PID:155242): Killing 1 processes (PIDS:155435) (Process by index) in order to remove hung processes. Requested by OS process 155242 on instance 1
2022-03-31T12:09:16.503950+08:00
Process termination requested for pid 155435 [source = rdbms], [info = 2] [request issued by pid: 155242, uid: 1000]
2022-03-31T12:09:18.530702+08:00
TMON (PID:155242): Error 16198 due to hung I/O operation to LOG_ARCHIVE_DEST_1
TMON (PID:155242): Detected ARCH process failure
TMON (PID:155242): STARTING ARCH PROCESSES
mos文档
ASLR is disabled in Oracle Linux 7 system - kernel.randomize_va_space = 0 (Doc ID 2755770.1)
ORA-00445: Background Process "xxxx" Did Not Start After 120 Seconds (Doc ID 1345364.1)
ORA-00445: background process "J000" did not start after 120 seconds (Doc ID 1600807.1)
ORA-00445: Background Process "m000" Did Not Start After 120 Seconds (Doc ID 2952314.1)
Troubleshooting ORA-00445: Background Process "xxxx" Did Not Start After n Seconds / Ksvcreate: Process(xxxx) Creation Failed (Doc ID 2023910.1)
Troubleshooting Guide (TSG) - Ksvcreate: Process(xxxx) Creation Failed / ORA-00445: Background Process "xxxx" Did Not Start After n Seconds (Doc ID 1379200.1)
处理办法:
# echo 'kernel.randomize_va_space=0' >> /etc/sysctl.conf
# sysctl -p