12c Cluster 的 NTP

(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"
PRVF-5436 : The NTP daemon running on one or more nodes lacks the slewing option "slewalways yes"
Clock synchronization check using Network Time Protocol(NTP) failed
PRVF-9652 : Cluster Time Synchronization Services check failed


留言

張貼留言

這個網誌中的熱門文章

12c RAC, OS log 出現 WARNING: couldn't allocate FBT table for module oracleacfs

環境 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...
閱讀完整內容

11g client 連上 12c server, 出現 ora-28040

圖片
環境 Solaris 11 Oracle 12.2.0.1 EE 異常   開發人員使用 11g tools 連至 12c DB 時出現 ora-28040 細節 User 轉寄以下圖片 Workaround  這個很好查, 馬上就找到  12c: ORA-28040 After Upgrade: No Matching Authentication Protocol (Doc ID 1957995.1)  在 sqlnet.ora 加入以下字串 SQLNET.ALLOWED_LOGON_VERSION_SERVER=10 SQLNET.ALLOWED_LOGON_VERSION_CLIENT=10 有幾點要注意 1. 將數值設成低於 11, 也不代表一定支援那個版本的 client  2. 在RAC環境下, 有時必需重開 cluster service 3. 在 12cR1 預設值是 11, 在 12cR2 預設值是 12 4. 在 12c 已廢棄   SQLNET.ALLOWED_LOGON_VERSION
閱讀完整內容

12cRAC, 災演後, cluster 服務無法啟動

環境 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 ...
閱讀完整內容