ORACLE 19C RAC叢集安裝與PRCR-1079&CRS-5017&ORA-03113

    今天，一同事在自己的虛擬機器上安裝oracle 19c rac叢集，在他安裝的過程中遭遇了報錯：

PRCR-1079&CRS-5017&ORA-03113。具體的報錯資訊截圖如下：

    看著像是功敗垂成的樣子，同事提供的DBCA報錯日誌資訊提示，資料庫庫例項未啟動：

    進一步跟蹤兩個節點db例項的告警日誌，除了例項被PMON程式終止，未發現其他有價值的資訊：

例項1的告警日誌：

2021-02-20T11:45:14.671691+08:00

Dumping diagnostic data in directory=[cdmp_20210220114514], requested by (instance=2, osid=88420 (PMON)), summary=[abnormal instance termination].

2021-02-20T11:45:39.728434+08:00

ALTER SYSTEM SET _ipddb_enable=TRUE SCOPE=MEMORY SID='racdb1';

2021-02-20T11:46:15.464253+08:00

Process termination requested for pid 91909 [source = rdbms], [info = 2] [request issued by pid: 91857, uid: 6001]

2021-02-20T11:46:23.515236+08:00

Warning: 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:00

My CSS node number is 2 

My CSS hostname is racdb62

Instance reconfiguration: current system load 19 (hiload)

lmon registered with NM - instance number 2 (internal mem no 1)

2021-02-20T11:45:14.511978+08:00

PMON (ospid: ): terminating the instance due to ORA error 

2021-02-20T11:45:14.545360+08:00

System 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.trc

2021-02-20T11:45:14.568799+08:00

Cause - 'Instance is being terminated due to fatal process death (pid: 22, ospid: 88564, LMON)'

2021-02-20T11:45:26.851684+08:00

License high water mark = 1

2021-02-20T11:45:28.491267+08:00

Dumping diagnostic data in directory=[cdmp_20210220114514], requested by (instance=2, osid=88420 (PMON)), summary=[abnormal instance termination].

2021-02-20T11:45:30.181664+08:00

Instance terminated by PMON, pid = 88420

2021-02-20T11:45:31.276108+08:00

Warning: 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:00

USER(prelim) (ospid: 89675): terminating the instance

2021-02-20T11:45:32.236231+08:00

Instance 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 available

ORA-27101: shared memory realm does not exist

Linux-x86_64 Error: 2: No such file or directory

Additional information: 4376

Additional information: -907856465

Process ID: 0

Session 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。