ORACLE 19C RAC集群安装与PRCR-1079&CRS-5017&ORA-03113

来源:这里教程网 时间:2026-03-03 16:29:39 作者:

    今天,一同事在自己的虚拟机上安装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。

相关推荐