發生ORA-00600 [kkqgbpAggPushAndTransform.2：Inval Agg found。]錯誤在Oracle 12C

7/16 收到一封錯誤訊息

訊息如下:

<span style="-webkit-text-stroke-width:0px; background-color:rgb(250, 250, 250); color:rgb(0, 61, 91); display:inline !important; float:none; font-family:tahoma,verdana,helvetica,sans-serif; font-size:11px; font-style:normal; font-variant-caps:normal; font-variant-ligatures:normal; font-weight:400; letter-spacing:normal; orphans:2; text-align:left; text-decoration-color:initial; text-decoration-style:initial; text-indent:0px; text-transform:none; white-space:normal; widows:2; word-spacing:0px"> <span style="-webkit-text-stroke-width:0px; background-color:rgb(250, 250, 250); color:rgb(0, 61, 91); display:inline !important; float:none; font-family:tahoma,verdana,helvetica,sans-serif; font-size:11px; font-style:normal; font-variant-caps:normal; font-variant-ligatures:normal; font-weight:400; letter-spacing:normal; orphans:2; text-align:left; text-decoration-color:initial; text-decoration-style:initial; text-indent:0px; text-transform:none; white-space:normal; widows:2; word-spacing:0px">ORA-600 [kkqgbpAggPushAndTransform.2：Inval Agg found。]

幸好這個錯誤並不會影響資料庫運作,透過oracle support查看

原來是一個bug

可以透過追蹤檔案看到因為什麼SQL影響的,如希望更多訊息請留言給我。

----------------------後續打patch紀錄

---------------------NODE1上面

1.su - oracle 2.unzip p25323193_122010_Linux-x86-64.zip 3.cd 25323193/ 4./u01/app/oracle/product/12.2.0/db_1/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./

--------------------關閉所有服務 1.su - oracle 2.srvctl stop instance -d orcl -n rac1 --關閉node1節點的資料庫 3.srvctl status instance -d orcl -n rac1 4.su - root 5./u01/app/12.2.0/grid/bin/crsctl stop cluster -n rac1 --------------------- 開始應用oracle patch 1.su - oracle 1.cd 25323193/ 2./u01/app/oracle/product/12.2.0/db_1/OPatch/opatch apply

----------------------開啟全部服務 1.root >>/u01/app/12.2.0/grid/bin/crsctl start cluster -n rac1 2.oracle >> srvctl start instance -d orcl -n rac1 3.結束....

換node2

assistant engineer

The growth related to novice engineers(database)