Mozark's blog

新建的 12.2.0.1 資料庫, 在 alert log 裡持續的出現 ORA-12012 , 如下所示 2018-06-04T01:30:45.124533+08:00 Errors in file /oracle/app/diag/rdbms/hisdb/HISDB1/trace/HISDB1_j000_24469.trc: ORA-12012 : error on auto execute of job "SYS"."ORA$AT_OS_OPT_SY_14438" ORA-20001: Statistics Advisor: Invalid task name for the current user ORA-06512: at "SYS.DBMS_STATS", line 47207 ORA-06512: at "SYS.DBMS_STATS_ADVISOR", line 882 ORA-06512: at "SYS.DBMS_STATS_INTERNAL", line 20059 ORA-06512: at "SYS.DBMS_STATS_INTERNAL", line 22201 ORA-06512: at "SYS.DBMS_STATS", line 47197 2018-06-04T01:40:45.589708+08:00 Errors in file /oracle/app/diag/rdbms/hisdb/HISDB1/trace/HISDB1_j000_2328.trc: ORA-12012 : error on auto execute of job "SYS"."ORA$AT_OS_OPT_SY_14440" ORA-20001: Statistics Advisor: Invalid task name for the current user ORA-06512: at "SYS.DBMS_STATS", line 47207 ORA-06512: at "SYS.DBMS_STATS_A...

環境 Linux 7.2 Oracle  12.1.0.2   異常   trace file 持續大量成長 細節 沒有安排行程的一天 先是遇到Ａ客戶spatial index 有誤 再來是B客戶的 cluster 1 node 1 自動重啟後, 向 cluster 2 scan 註冊 還沒處理完, C客戶因為重建 index 也發生了 ORA-4031 最後, 高雄同事又問 trace file 一直增加 遠端連線看了一下, 果然如此 # ls -l  -rw-r-----. 1 oracle asmadmin  1810987 May 24 15:29 CATOSP1_m000_4177.trc -rw-r-----. 1 oracle asmadmin   650296 May 24 15:29 CATOSP1_m000_4177.trm -rw-r-----. 1 oracle asmadmin  1810987 May 24 15:28 CATOSP1_m000_3859.trc -rw-r-----. 1 oracle asmadmin   650263 May 24 15:28 CATOSP1_m000_3859.trm -rw-r-----. 1 oracle asmadmin  1809963 May 24 15:27 CATOSP1_m000_2615.trc -rw-r-----. 1 oracle asmadmin   650220 May 24 15:27 CATOSP1_m000_2615.trm -rw-r-----. 1 oracle asmadmin  3620892 May 24 15:26 CATOSP1_m000_2380.trc -rw-r-----. 1 oracle asmadmin  1300501 May 24 15:26 CATOSP1_m000_2380.trm -rw-r-----. 1 oracle asmadmin  1808910 May 24 15:25 CATOSP1_m000_2...

(1).  OS NTP vs Oracle GI ctssd (Cluster Synchronization Service Daemon) OS 有設NTP , 則 GI ctssd 以 observer  模式啟動 OS 沒設 NTP,  , 則 GI ctssd 以 active  模式啟動 參考 https://community.toadworld.com/platforms/oracle/b/weblog/archive/2015/03/12/switching-ctssd-from-active-mode-to-observer-mode (2). 設定 NTP 微調式 (slew)修正時間 依 metalink Doc ID 1056693.1 , 在 Solaris 上的設定方式如下: Solaris 10: #  egrep 'slewalways|pll' /etc/inet/ntp.conf slewalways yes disable pll To set, modify the configuration file. Solaris 11: # svcprop -p config/slew_always svc:/network/ntp:default true To set: # svccfg -s svc:/network/ntp:default setprop config/slew_always = true 設定完成後, 以 下列兩個指令生效 (單純 stop/start 不會生效) # /usr/sbin/svcadm refresh ntp # /usr/sbin/svcadm restart ntp (3) 關於 NTP 微調式修正時間 文件同時提到, NTP 需以微調方式修正系統時間, 否則會出珼下列錯誤 但是在 Oracle 12c GI 上 沒出現此問題 $GRID_HOME/bin/cluvfy comp clocksync -n all .. Checking daemon liveness... Liveness check passed for "xntpd" ...

環境 Solaris 11 SPARC (LDOM) Oracle 12.2.0.1 EE RAC  異常   OS 重開後, GI 無法啟動,   osysmond.bin 也沒有啟動 細節 EMRRAC1 root@EMRRAC1:~# /oracle/app/grid/bin/crsctl start cluster CRS-2672: Attempting to start 'ora.crf' on 'emrrac1' CRS-2672: Attempting to start 'ora.cssd' on 'emrrac1' CRS-2672: Attempting to start 'ora.diskmon' on 'emrrac1' CRS-2676: Start of 'ora.diskmon' on 'emrrac1' succeeded CRS-2676: Start of 'ora.crf' on 'emrrac1' succeeded CRS-2674: Start of 'ora.cssd' on 'emrrac1' failed CRS-2679: Attempting to clean 'ora.cssd' on 'emrrac1' CRS-2681: Clean of 'ora.cssd' on 'emrrac1' succeeded CRS-2673: Attempting to stop 'ora.crf' on 'emrrac1' CRS-2677: Stop of 'ora.crf' on 'emrrac1' succeeded CRS-4000: Command Start failed, or completed with errors . EMRRAC2 root@EMRRAC2:~# /oracle/app/grid/bin/crsctl start ...

環境 Solaris 11 SPARC (LDOM) Oracle 12.2.0.1 EE RAC  異常   OS log 出現  WARNING: couldn't allocate FBT table for module oracleacfs 細節 root@HISRAC1:~# dmesg |grep acfs Apr 27 01:08:03 HISRAC1 fbt: [ID 795213 kern.warning] WARNING: couldn't allocate FBT table for module oracleacfs Apr 27 02:08:03 HISRAC1 fbt: [ID 795213 kern.warning] WARNING: couldn't allocate FBT table for module oracleacfs Apr 27 03:08:03 HISRAC1 fbt: [ID 795213 kern.warning] WARNING: couldn't allocate FBT table for module oracleacfs Apr 27 04:08:03 HISRAC1 fbt: [ID 795213 kern.warning] WARNING: couldn't allocate FBT table for module oracleacfs Apr 27 05:08:03 HISRAC1 fbt: [ID 795213 kern.warning] WARNING: couldn't allocate FBT table for module oracleacfs Apr 27 06:08:03 HISRAC1 fbt: [ID 795213 kern.warning] WARNING: couldn't allocate FBT table for module oracleacfs Apr 27 07:08:03 HISRAC1 fbt: [ID 795213 kern.warning] WARNING: couldn't allocate FBT table for module oracl...