数据库启动,alert日志报错ORA-00445,pmon在120s不能启动,日志如下:
Tue Jul 18 08:32:59 2023
Errors in file /opt/app/oracle/diag/rdbms/jcd/jcd/trace/jcd_ora_15233.trc (incident=260431):
ORA-00445: background process "PMON" did not start after 120 seconds
Incident details in: /opt/app/oracle/diag/rdbms/jcd/jcd/incident/incdir_260431/jcd_ora_15233_i260431.trc
USER (ospid: 15233): terminating the instance due to error 445
Instance terminated by USER, pid = 15233
Tue Jul 18 08:34:19 2023
检查补丁没有打,是个bug参考如下文档:
Troubleshooting Guide (TSG) - Ksvcreate: Process(xxxx) Creation Failed / ORA-00445: Background Process "xxxx" Did Not Start After n Seconds (Doc ID 1379200.1)
ORA-00445: Background Process "xxxx" Did Not Start After 120 Seconds (Doc ID 1345364.1)
报错:
ORA-00445: Background Process "xxxx" Did Not Start After 120 Seconds
解决:禁用ASLR
# /sbin/sysctl -a | grep randomize
kernel.randomize_va_space = 1
验证ASLR是否使用:
#/sbin/sysctl -a | grep randomize
kernel.randomize_va_space = 1
参数值不是0说明ASLR在使用.
在/etc/sysctl.conf种增加参数
kernel.randomize_va_space=0
kernel.exec-shield=0