今天,一同事在自己的虚拟机上安装oracle 19c rac集群,在他安装的过程中遭遇了报错:PRCR-1079&CRS-5017&ORA-03113。具体的报错信息截图如下:
看着像是功败垂成的样子,同事提供的DBCA报错日志信息提示,数据库库实例未启动:
进一步跟踪两个节点db实例的告警日志,除了实例被PMON进程终止,未发现其他有价值的信息:实例1的告警日志:2021-02-20T11:45:14.671691+08:00Dumping diagnostic data in directory=[cdmp_20210220114514], requested by (instance=2, osid=88420 (PMON)), summary=[abnormal instance termination].2021-02-20T11:45:39.728434+08:00ALTER SYSTEM SET _ipddb_enable=TRUE SCOPE=MEMORY SID='racdb1';2021-02-20T11:46:15.464253+08:00Process termination requested for pid 91909 [source = rdbms], [info = 2] [request issued by pid: 91857, uid: 6001]2021-02-20T11:46:23.515236+08:00Warning: VKTM detected a forward time drift. Please see the VKTM trace file for more details:/oracle/app/oracle/diag/rdbms/racdb/racdb1/trace/racdb1_vktm_91812.trc实例2的告警日志:2021-02-20T11:44:03.379475+08:00My CSS node number is 2 My CSS hostname is racdb62Instance reconfiguration: current system load 19 (hiload)lmon registered with NM - instance number 2 (internal mem no 1)2021-02-20T11:45:14.511978+08:00PMON (ospid: ): terminating the instance due to ORA error 2021-02-20T11:45:14.545360+08:00System state dump requested by (instance=2, osid=88420 (PMON)), summary=[abnormal instance termination]. error - 'Instance is terminating.'System State dumped to trace file /oracle/app/oracle/diag/rdbms/racdb/racdb2/trace/racdb2_diag_88450.trc2021-02-20T11:45:14.568799+08:00Cause - 'Instance is being terminated due to fatal process death (pid: 22, ospid: 88564, LMON)'2021-02-20T11:45:26.851684+08:00License high water mark = 12021-02-20T11:45:28.491267+08:00Dumping diagnostic data in directory=[cdmp_20210220114514], requested by (instance=2, osid=88420 (PMON)), summary=[abnormal instance termination].2021-02-20T11:45:30.181664+08:00Instance terminated by PMON, pid = 884202021-02-20T11:45:31.276108+08:00Warning: 2 processes are still attacheded to shmid 5: (size: 16384 bytes, creator pid: 87669, last attach/detach pid: 88626)2021-02-20T11:45:32.234979+08:00USER(prelim) (ospid: 89675): terminating the instance2021-02-20T11:45:32.236231+08:00Instance terminated by USER(prelim), pid = 89675 但是,看到
ORA-27101告警,下意识的感觉是集群操作系统配置或者oracle用户的环境变量有问题。2021-02-20 11:45:33.445 :CLSDYNAM:1644160768: [ora.racdb.db]{1:60322:3769} [check] ORA-01034: ORACLE not availableORA-27101: shared memory realm does not existLinux-x86_64 Error: 2: No such file or directoryAdditional information: 4376Additional information: -907856465Process ID: 0Session ID: 0 Serial number: 0 同事提供的两个节点的oracle用户环境变量,经检查没问题:
排除掉环境变量配置问题后,那就可能是主机配置问题,同事提供了sysctl.conf配置内容:
看到kernel.shmmax配置为4G左右,貌似看到问题根源,接下来询问同事虚机的内存配置,配置为6.3G:
oracle 19c rac集群安装的最低配置要求
总结:ORACLE 19C RAC集群安装由于内存6.3G不足以满足grid和db内存的实例化要求,导致dbca建库报错PRCR-1079&CRS-5017&ORA-03113。
ORACLE 19C RAC集群安装与PRCR-1079&CRS-5017&ORA-03113
来源:这里教程网
时间:2026-03-03 16:29:39
作者:
编辑推荐:
下一篇:
相关推荐
-
雷神推出 MIX PRO II 迷你主机:基于 Ultra 200H,玻璃上盖 + ARGB 灯效
2 月 9 日消息,雷神 (THUNDEROBOT) 现已宣布推出基于英
-
制造商 Musnap 推出彩色墨水屏电纸书 Ocean C:支持手写笔、第三方安卓应用
2 月 10 日消息,制造商 Musnap 现已在海外推出一款 Oce
热文推荐
- ORACLE 19C RAC集群安装与PRCR-1079&CRS-5017&ORA-03113
- 12c使用DBLINK连接9i报ORA-03134
12c使用DBLINK连接9i报ORA-03134
26-03-03 - oracle客户端安装步骤—附图形界面启用失败处理方法
oracle客户端安装步骤—附图形界面启用失败处理方法
26-03-03 - 记一次utlrp.sql脚本执行引发的结果
记一次utlrp.sql脚本执行引发的结果
26-03-03 - Rax App 研发框架背后的思考
Rax App 研发框架背后的思考
26-03-03 - 源码级别人话说:Virtual DOM和DOM diff算法
源码级别人话说:Virtual DOM和DOM diff算法
26-03-03 - oracle uncatalog数据库备份文件
oracle uncatalog数据库备份文件
26-03-03 - 记一次expdp导出任务中某张大表报错问题的解决过程
记一次expdp导出任务中某张大表报错问题的解决过程
26-03-03 - 数据库redolog切换频率统计分析
数据库redolog切换频率统计分析
26-03-03 - 【TUNE_ORACLE】Oracle索引设计思想(一)索引片和匹配列概述
