Oracle RAC節點時間差過大解決方法
文章版權所有 Jusin Hao(luckyfriends) ,支援原創,轉載請註明。
第 1 頁 共 13 頁
密級:機密 日期:2014-5-12
Oracle RAC 節點時間差過大解決方法
1. 問題現象
1.1. 兩臺 RAC 節點的 OS 時間差超過 5 分鐘
發現兩個節點的時間確實相差較大
[oraprod@ebsdb1 ~]$ date
Wed Apr 30 11:27:20 CST 2014
[oraprod@ebsdb2 ~]$ date
Wed Apr 30 11:22:24 CST 2014
1.2. 檢查 CTSS 狀態發現其處於觀察模式
[oraprod@ebsdb1 bin]$ crsctl check ctss
CRS-4700: The Cluster Time Synchronization Service is in Observer mode.
[oraprod@ebsdb1 bin]$ cluvfy comp clocksync
Verifying Clock Synchronization across the cluster nodes
Checking if Clusterware is installed on all nodes...
Check of Clusterware install passed
Checking if CTSS Resource is running on all nodes...
CTSS resource check passed
Querying CTSS for time offset on all nodes...
Query of CTSS for time offset passed
Check CTSS state started...
CTSS is in Observer state. Switching over to clock synchronization checks using NTP
Starting Clock synchronization checks using Network Time Protocol(NTP)...
NTP Configuration file check started...
NTP Configuration file check passed
Checking daemon liveness...
Liveness check failed for "ntpd"
Check failed on nodes:
ebsdb1
PRVF-5494 : The NTP Daemon or Service was not alive on all nodes
PRVF-5415 : Check to see if NTP daemon or service is running failed
Clock synchronization check using Network Time Protocol(NTP) failed 文章版權所有 Jusin Hao(luckyfriends) ,支援原創,轉載請註明。
PRVF-9652 : Cluster Time Synchronization Services check failed
Verification of Clock Synchronization across the cluster nodes was unsuccessful on all the specified nodes.
1.3. 發現 RAC 節點的 NTP 配置存在
發現RAC2 上的NTP 是起著的,RAC1 上的NTP 是聽著的
[root@ebsdb2 ~]# service ntpd status
ntpd (pid 7723) is running...
[root@ebsdb2 ~]# cd /etc/
[root@ebsdb2 etc]# ls -alt |grep ntp
-rw-r--r-- 1 root root 1833 Apr 16 2013 ntp.conf
-rw-r--r-- 1 root root 1833 Nov 17 2011 ntp.conf.original
drwxr-xr-x 2 root root 4096 Jun 11 2011 ntp
[root@ebsdb2 ntp]# cd /var/run/
[root@ebsdb2 run]# ls -alt |grep ntp
-rw-r--r-- 1 root root 4 Apr 17 2013 ntpd.pid
[root@ebsdb1 ~]# service ntpd status
ntpd is stopped
[root@ebsdb1 ~]# cd /etc/
[root@ebsdb1 etc]# ls -alt ntp*
-rw-r--r-- 1 root root 1833 Apr 16 2013 ntp.conf
2. 問題解決過程:
2.1. 停止應用
略。
2.2. 停止 Oracle RAC 及資料庫
[oraprod@ebsdb1 bin]$ ./crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.CRS.dg ora....up.type ONLINE ONLINE ebsdb1
ora.DATA.dg ora....up.type ONLINE ONLINE ebsdb1
ora.FRA.dg ora....up.type ONLINE ONLINE ebsdb1
ora....ER.lsnr ora....er.type ONLINE ONLINE ebsdb1
ora....N1.lsnr ora....er.type ONLINE ONLINE ebsdb1
ora.asm ora.asm.type ONLINE ONLINE ebsdb1
ora.cvu ora.cvu.type ONLINE ONLINE ebsdb1
ora....SM1.asm application ONLINE ONLINE ebsdb1
ora....B1.lsnr application ONLINE ONLINE ebsdb1
ora.ebsdb1.gsd application ONLINE OFFLINE
ora.ebsdb1.ons application ONLINE ONLINE ebsdb1
ora.ebsdb1.vip ora....t1.type ONLINE ONLINE ebsdb1
ora....SM2.asm application ONLINE ONLINE ebsdb2
ora....B2.lsnr application ONLINE ONLINE ebsdb2
ora.ebsdb2.gsd application ONLINE OFFLINE
ora.ebsdb2.ons application ONLINE ONLINE ebsdb2
ora.ebsdb2.vip ora....t1.type ONLINE ONLINE ebsdb2
ora.gsd ora.gsd.type ONLINE OFFLINE
ora....network ora....rk.type ONLINE ONLINE ebsdb1
ora.oc4j ora.oc4j.type ONLINE ONLINE ebsdb1
ora.ons ora.ons.type ONLINE ONLINE ebsdb1
ora.prod.db ora....se.type ONLINE ONLINE ebsdb2
ora.scan1.vip ora....ip.type ONLINE ONLINE ebsdb1
[oraprod@ebsdb1 bin]$ ./crs_stop -all
Attempting to stop `ora.ons` on member `ebsdb2`
Attempting to stop `ora.LISTENER.lsnr` on member `ebsdb2`
Attempting to stop `ora.cvu` on member `ebsdb1`
Attempting to stop `ora.ons` on member `ebsdb1`
Attempting to stop `ora.LISTENER.lsnr` on member `ebsdb1`
Attempting to stop `ora.LISTENER_SCAN1.lsnr` on member `ebsdb1`
Attempting to stop `ora.oc4j` on member `ebsdb1`
Attempting to stop `ora.CRS.dg` on member `ebsdb2`
Attempting to stop `ora.DATA.dg` on member `ebsdb2`
Attempting to stop `ora.FRA.dg` on member `ebsdb2`
Attempting to stop `ora.prod.db` on member `ebsdb2`
CRS-2789: Cannot stop resource 'ora.gsd' as it is not running on server 'ebsdb2'
Attempting to stop `ora.CRS.dg` on member `ebsdb1`
Attempting to stop `ora.DATA.dg` on member `ebsdb1`
Attempting to stop `ora.FRA.dg` on member `ebsdb1`
Attempting to stop `ora.prod.db` on member `ebsdb1`
CRS-2789: Cannot stop resource 'ora.gsd' as it is not running on server 'ebsdb1'
Stop of `ora.cvu` on member `ebsdb1` succeeded.
Stop of `ora.LISTENER.lsnr` on member `ebsdb1` succeeded.
Attempting to stop `ora.ebsdb1.vip` on member `ebsdb1`
CRS-2789: Cannot stop resource 'ora.LISTENER.lsnr' as it is not running on server 'ebsdb1'
Stop of `ora.LISTENER_SCAN1.lsnr` on member `ebsdb1` succeeded.
Attempting to stop `ora.scan1.vip` on member `ebsdb1`
Stop of `ora.ons` on member `ebsdb1` succeeded.
CRS-2789: Cannot stop resource 'ora.ons' as it is not running on server 'ebsdb1'
Stop of `ora.LISTENER.lsnr` on member `ebsdb2` succeeded.
Attempting to stop `ora.ebsdb2.vip` on member `ebsdb2`
CRS-2789: Cannot stop resource 'ora.LISTENER.lsnr' as it is not running on server 'ebsdb2'
Stop of `ora.ons` on member `ebsdb2` succeeded.
CRS-2789: Cannot stop resource 'ora.ons' as it is not running on server 'ebsdb2'
Stop of `ora.scan1.vip` on member `ebsdb1` succeeded.
Stop of `ora.ebsdb1.vip` on member `ebsdb1` succeeded.
Attempting to stop `ora.net1.network` on member `ebsdb1`
Stop of `ora.net1.network` on member `ebsdb1` succeeded.
Stop of `ora.ebsdb2.vip` on member `ebsdb2` succeeded.
Attempting to stop `ora.net1.network` on member `ebsdb2`
Stop of `ora.net1.network` on member `ebsdb2` succeeded.
Stop of `ora.FRA.dg` on member `ebsdb2` succeeded.
Stop of `ora.FRA.dg` on member `ebsdb1` succeeded.
Stop of `ora.oc4j` on member `ebsdb1` succeeded.
Stop of `ora.DATA.dg` on member `ebsdb1` succeeded.
Stop of `ora.DATA.dg` on member `ebsdb2` succeeded.
Stop of `ora.prod.db` on member `ebsdb2` succeeded.
Stop of `ora.CRS.dg` on member `ebsdb1` succeeded.
Stop of `ora.CRS.dg` on member `ebsdb2` succeeded.
Attempting to stop `ora.asm` on member `ebsdb2`
Stop of `ora.prod.db` on member `ebsdb1` succeeded.
Attempting to stop `ora.asm` on member `ebsdb1`
Stop of `ora.asm` on member `ebsdb2` succeeded.------在這裡長時間等待停止
Attempting to stop `ora.asm` on member `ebsdb2`
CRS-2500: Cannot stop resource 'ora.asm' as it is not running
Stop of `ora.asm` on member `ebsdb2` succeeded.
Stop of `ora.asm` on member `ebsdb1` succeeded.
Attempting to stop `ora.asm` on member `ebsdb1`
CRS-0184: Cannot communicate with the CRS daemon.
2.3. ASM 在 CRS 停止前無法停止
Attempting to stop `ora.asm` on member `ebsdb1`
Stop of `ora.asm` on member `ebsdb2` succeeded.------在這裡長時間等待停止
Attempting to stop `ora.asm` on member `ebsdb2`
[oraprod@ebsdb1 bin]$ ./crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
[oraprod@ebsdb1 bin]$ crsctl check ctss
CRS-4700: The Cluster Time Synchronization Service is in Observer mode.
檢視asm 日誌
[oraprod@ebsdb1 trace]$ tail -f alert_+ASM1.log
SUCCESS: ALTER DISKGROUP DATA DISMOUNT /* asm agent *//* {1:52692:21791} */
freeing rdom 2
Received detach msg from inst 2 for dom 2
GMON querying group 1 at 23 for pid 18, osid 8802
Sun May 11 09:26:24 2014
NOTE: Instance updated compatible.asm to 11.2.0.0.0 for grp 1
Sun May 11 09:26:24 2014
ORA-15032: not all alterations performed
ORA-15027: active use of diskgroup "CRS" precludes(妨礙、組織) its dismount
ERROR: ALTER DISKGROUP CRS DISMOUNT /* asm agent *//* {1:52692:21791} */
從日誌可以看出ASM無法 dismount 因為 CRS 沒有停止,這是因為 The OCR is located on ASM and CRSD is client of
ASM thus ASM can't be shutdown(參考 ORA-15097 Cannot Shutdown ASM if OCR is Located in ASM [ID 984663.1])
即在 Oracle 11gR2 下,除了資料檔案之外,OCR 也是放在 ASM 裡的,這樣 CRSD 就會成為 ASM 的客戶端。如果
我們像 Oracle 10g 裡那樣直接停ASM 的時候,就會報上面的錯誤。 所以,在 11gR2 下面,要停 ASM 例項的話,
只能和 CRS 一起停。 在root 使用者下執行:crsctl stop crs。
同時,要注意不要直接 kill 掉 ASM 程式,或者用 shutdown abort 來關閉ASM 例項。 這樣 CRS 也會被掛掉。
2.4. 停止 CRS
[root@ebsdb1 ~]# cd /oradb/11.2.0/grid/bin/
[root@ebsdb1 bin]# ./crsctl stop crs
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'ebsdb1'
CRS-2673: Attempting to stop 'ora.crsd' on 'ebsdb1'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'ebsdb1'
CRS-4549: Unexpected disconnect while executing shutdown request.
CRS-2675: Stop of 'ora.crsd' on 'ebsdb1' failed
CRS-2679: Attempting to clean 'ora.crsd' on 'ebsdb1'
CRS-2681: Clean of 'ora.crsd' on 'ebsdb1' succeeded
CRS-2673: Attempting to stop 'ora.mdnsd' on 'ebsdb1'
CRS-2673: Attempting to stop 'ora.crf' on 'ebsdb1'
CRS-2673: Attempting to stop 'ora.ctssd' on 'ebsdb1'
CRS-2673: Attempting to stop 'ora.evmd' on 'ebsdb1'
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'ebsdb1'
CRS-2677: Stop of 'ora.mdnsd' on 'ebsdb1' succeeded
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'ebsdb1' succeeded
CRS-2677: Stop of 'ora.crf' on 'ebsdb1' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'ebsdb1' succeeded
CRS-2677: Stop of 'ora.evmd' on 'ebsdb1' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'ebsdb1'
CRS-2677: Stop of 'ora.cssd' on 'ebsdb1' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'ebsdb1'
CRS-2677: Stop of 'ora.gipcd' on 'ebsdb1' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'ebsdb1'
CRS-2677: Stop of 'ora.gpnpd' on 'ebsdb1' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'ebsdb1' has completed
CRS-4133: Oracle High Availability Services has been stopped.
[root@ebsdb2 bin]# ./crsctl stop crs -f
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'ebsdb2'
CRS-2673: Attempting to stop 'ora.crf' on 'ebsdb2'
CRS-2673: Attempting to stop 'ora.ctssd' on 'ebsdb2'
CRS-2673: Attempting to stop 'ora.evmd' on 'ebsdb2'
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'ebsdb2'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'ebsdb2'
CRS-2677: Stop of 'ora.crf' on 'ebsdb2' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'ebsdb2' succeeded
CRS-2677: Stop of 'ora.evmd' on 'ebsdb2' succeeded
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'ebsdb2' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'ebsdb2' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'ebsdb2'
CRS-2677: Stop of 'ora.cssd' on 'ebsdb2' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'ebsdb2'
CRS-2677: Stop of 'ora.gipcd' on 'ebsdb2' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'ebsdb2'
CRS-2677: Stop of 'ora.gpnpd' on 'ebsdb2' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'ebsdb2' has completed
[oraprod@ebsdb1 bin]$
[oraprod@ebsdb1 bin]$ ./crs_stat -t
CRS-0184: Cannot communicate with the CRS daemon.
[oraprod@ebsdb1 bin]$ ps -ef |grep asm
oraprod 30959 28971 0 09:37 pts/1 00:00:00 grep asm
[oraprod@ebsdb1 bin]$ ps -ef |grep d.bin
oraprod 30971 28971 0 09:37 pts/1 00:00:00 grep d.bin
2.5. 調整 RAC 伺服器時間
2.5.1. 同步伺服器的 OS 時間與 CMOS 時間
[root@ebsdb1 ~]# date
Sun May 11 09:41:57 CST 2014
[root@ebsdb1 ~]# hwclock ----檢視 rac1 的 cmos 時間
Sun 11 May 2014 09:36:34 AM CST -0.670362 seconds
[root@ebsdb2 bin]# date
Sun May 11 09:35:57 CST 2014
[root@ebsdb2 bin]# hwclock ----檢視 rac2 的 cmos 時間
Sun 11 May 2014 09:36:20 AM CST -0.662735 seconds
[root@ebsdb1 ~]# clock –systohc ----同步 cmos 時間與 os 時間
[root@ebsdb1 ~]# hwclock
dateSun 11 May 2014 09:43:17 AM CST -0.983102 seconds
[root@ebsdb1 ~]# date
Sun May 11 09:43:17 CST 2014
2.5.2. 修改 EBSDB2(RAC2)時間與 RAC1 一致
[root@ebsdb1 run]# date
Sun May 11 09:54:06 CST 2014
[root@ebsdb1 run]# hwclock
Sun 11 May 2014 09:54:09 AM CST -0.920398 seconds
[root@ebsdb2 run]# date
Sun May 11 09:46:33 CST 2014
[root@ebsdb2 run]# date -s 09:54:09 ----修改 RAC2 的時間與RAC1 一致
Sun May 11 09:54:09 CST 2014
[root@ebsdb2 run]# date
Sun May 11 09:54:14 CST 2014
[root@ebsdb2 run]# hwclock -r
Sun May 11 09:48:15 2014 -0.045481 seconds
[root@ebsdb2 run]# clock -w -----將時間寫入 CMOS
[root@ebsdb2 run]# hwclock
Sun May 11 09:55:48 2014 -0.686071 seconds
[root@ebsdb2 run]# hwclock -r
Sun May 11 09:55:53 2014 -1.014941 seconds
[root@ebsdb2 run]# date
Sun May 11 09:55:55 CST 2014
2.6. 停止 OS 的 NTPD 並禁用
2.6.1. 停止 NTPD 服務
[root@ebsdb1 ~]# service ntpd status
ntpd is stopped
[root@ebsdb2 bin]# service ntpd status
ntpd is stopped
[root@ebsdb2 bin]# ps -ef |grep ntpd
root 21397 20896 0 09:40 pts/2 00:00:00 grep ntpd
2.6.2. 禁用 NTPD 自動啟動
[root@ebsdb1 ~]# chkconfig ntpd off
[root@ebsdb2 ~]# chkconfig ntpd off
2.6.3. 重新命名 ntpd.conf
[root@ebsdb1 etc]# ls -alt |grep ntp
-rw-r--r-- 1 root root 1833 Apr 16 2013 ntp.conf
-rw-r--r-- 1 root root 1833 Nov 17 2011 ntp.conf.original
drwxr-xr-x 2 root root 4096 Jun 11 2011 ntp
[root@ebsdb1 etc]# mv /etc/ntp.conf /etc/ntp.conf.20140511
[root@ebsdb1 etc]# ls -alt |grep ntp
-rw-r--r-- 1 root root 1833 Apr 16 2013 ntp.conf.20140511
-rw-r--r-- 1 root root 1833 Nov 17 2011 ntp.conf.original
drwxr-xr-x 2 root root 4096 Jun 11 2011 ntp
[root@ebsdb2 etc]# ls -alt |grep ntp
-rw-r--r-- 1 root root 1833 Apr 16 2013 ntp.conf
-rw-r--r-- 1 root root 1833 Nov 17 2011 ntp.conf.original
drwxr-xr-x 2 root root 4096 Jun 11 2011 ntp
[root@ebsdb2 etc]# mv ntp.conf ntp.conf.20140511
[root@ebsdb2 etc]# ls -alt |grep ntp
-rw-r--r-- 1 root root 1833 Apr 16 2013 ntp.conf.20140511
-rw-r--r-- 1 root root 1833 Nov 17 2011 ntp.conf.original
drwxr-xr-x 2 root root 4096 Jun 11 2011 ntp
2.6.4. 刪除 PID 檔案
[root@ebsdb1 etc]# cd /var/run
[root@ebsdb1 run]# ls -alt |grep ntp
[root@ebsdb2 etc]# cd /var/run
[root@ebsdb2 run]# ls -alt |grep ntp
2.7. 啟動 Oracle RAC
[root@ebsdb1 run]# ps -ef |grep d.bin
root 32003 29334 0 09:58 pts/2 00:00:00 grep d.bin
[root@ebsdb2 run]# ps -ef |grep d.bin
root 21985 20896 0 09:58 pts/2 00:00:00 grep d.bin
2.7.1. 啟動 RAC1 的 crs
[root@ebsdb1 bin]# ./crsctl start crs
CRS-4123: Oracle High Availability Services has been started.
[root@ebsdb1 bin]# ./crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4535: Cannot communicate with Cluster Ready Services
CRS-4530: Communications failure contacting Cluster Synchronization Services daemon
CRS-4534: Cannot communicate with Event Manager
[root@ebsdb1 bin]# ps -ef |grep d.bin
oraprod 354 1 4 10:00 ? 00:00:00 /oradb/11.2.0/grid/bin/oraagent.bin
oraprod 357 1 1 10:00 ? 00:00:00 /oradb/11.2.0/grid/bin/scriptagent.bin
root 361 1 2 10:00 ? 00:00:00 /oradb/11.2.0/grid/bin/orarootagent.bin
root 610 29334 0 10:01 pts/2 00:00:00 grep d.bin
root 32057 1 2 09:59 ? 00:00:02 /oradb/11.2.0/grid/bin/ohasd.bin reboot
oraprod 32173 1 0 09:59 ? 00:00:00 /oradb/11.2.0/grid/bin/oraagent.bin
oraprod 32185 1 0 09:59 ? 00:00:00 /oradb/11.2.0/grid/bin/mdnsd.bin
oraprod 32195 1 0 09:59 ? 00:00:00 /oradb/11.2.0/grid/bin/gpnpd.bin
root 32206 1 1 09:59 ? 00:00:00 /oradb/11.2.0/grid/bin/orarootagent.bin
oraprod 32208 1 1 09:59 ? 00:00:00 /oradb/11.2.0/grid/bin/gipcd.bin
root 32223 1 8 09:59 ? 00:00:05 /oradb/11.2.0/grid/bin/osysmond.bin
root 32234 1 0 09:59 ? 00:00:00 /oradb/11.2.0/grid/bin/cssdmonitor
root 32252 1 0 09:59 ? 00:00:00 /oradb/11.2.0/grid/bin/cssdagent
oraprod 32264 1 2 09:59 ? 00:00:01 /oradb/11.2.0/grid/bin/ocssd.bin
root 32295 1 1 10:00 ? 00:00:00 /oradb/11.2.0/grid/bin/ologgerd -M -d
/oradb/11.2.0/grid/crf/db/ebsdb1
root 32341 1 0 10:00 ? 00:00:00 /oradb/11.2.0/grid/bin/octssd.bin reboot
oraprod 32363 1 0 10:00 ? 00:00:00 /oradb/11.2.0/grid/bin/evmd.bin
root 32661 1 11 10:00 ? 00:00:01 /oradb/11.2.0/grid/bin/crsd.bin reboot
oraprod 32731 32363 0 10:00 ? 00:00:00 /oradb/11.2.0/grid/bin/evmlogger.bin -o
/oradb/11.2.0/grid/evm/log/evmlogger.info -l /oradb/11.2.0/grid/evm/log/evmlogger.log
2.7.2. 啟動 RAC2 的 crs
[root@ebsdb2 bin]# ./crsctl check crs
CRS-4639: Could not contact Oracle High Availability Services
[root@ebsdb2 bin]# ./crsctl start crs
CRS-4123: Oracle High Availability Services has been started.
[root@ebsdb2 bin]# ./crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4535: Cannot communicate with Cluster Ready Services
CRS-4530: Communications failure contacting Cluster Synchronization Services daemon
CRS-4534: Cannot communicate with Event Manager
[root@ebsdb2 bin]# ps -ef |grep d.bin
root 22148 1 4 10:00 ? 00:00:02 /oradb/11.2.0/grid/bin/ohasd.bin reboot
oraprod 22265 1 0 10:00 ? 00:00:00 /oradb/11.2.0/grid/bin/oraagent.bin
oraprod 22277 1 0 10:00 ? 00:00:00 /oradb/11.2.0/grid/bin/mdnsd.bin
oraprod 22287 1 1 10:00 ? 00:00:00 /oradb/11.2.0/grid/bin/gpnpd.bin
root 22299 1 1 10:00 ? 00:00:00 /oradb/11.2.0/grid/bin/orarootagent.bin
oraprod 22300 1 3 10:00 ? 00:00:00 /oradb/11.2.0/grid/bin/gipcd.bin
root 22315 1 6 10:00 ? 00:00:01 /oradb/11.2.0/grid/bin/osysmond.bin
root 22326 1 0 10:00 ? 00:00:00 /oradb/11.2.0/grid/bin/cssdmonitor
root 22343 1 0 10:00 ? 00:00:00 /oradb/11.2.0/grid/bin/cssdagent
oraprod 22355 1 3 10:00 ? 00:00:00 /oradb/11.2.0/grid/bin/ocssd.bin
root 22386 1 3 10:01 ? 00:00:00 /oradb/11.2.0/grid/bin/ologgerd -m ebsdb1 -r -d
/oradb/11.2.0/grid/crf/db/ebsdb2
root 22432 1 2 10:01 ? 00:00:00 /oradb/11.2.0/grid/bin/octssd.bin reboot
root 22449 20896 0 10:01 pts/2 00:00:00 grep d.bin
2.7.3. 檢視 CTSS 狀態已經出入 Active 模式
[root@ebsdb2 bin]# ./crsctl check ctss
CRS-4701: The Cluster Time Synchronization Service is in Active mode.
CRS-4702: Offset (in msec): 0
[root@ebsdb2 bin]#
[root@ebsdb1 bin]# ./crsctl check ctss
CRS-4701: The Cluster Time Synchronization Service is in Active mode.
CRS-4702: Offset (in msec): 0
[root@ebsdb1 bin]#
[root@ebsdb1 bin]# ./crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
[root@ebsdb2 bin]# ./crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
[root@ebsdb2 bin]# ./crsctl stat resource -t -init
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.asm
1 ONLINE ONLINE ebsdb2 Started
ora.cluster_interconnect.haip
1 ONLINE ONLINE ebsdb2
ora.crf
1 ONLINE ONLINE ebsdb2
ora.crsd
1 ONLINE ONLINE ebsdb2
ora.cssd
1 ONLINE ONLINE ebsdb2
ora.cssdmonitor
1 ONLINE ONLINE ebsdb2
ora.ctssd
1 ONLINE ONLINE ebsdb2 ACTIVE:0
ora.diskmon
1 OFFLINE OFFLINE
ora.evmd
1 ONLINE ONLINE ebsdb2
ora.gipcd
1 ONLINE ONLINE ebsdb2
ora.gpnpd
1 ONLINE ONLINE ebsdb2
ora.mdnsd
1 ONLINE ONLINE ebsdb2
2.7.4. 檢視叢集狀態
[root@ebsdb1 bin]# ./crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.CRS.dg ora....up.type ONLINE ONLINE ebsdb1
ora.DATA.dg ora....up.type ONLINE ONLINE ebsdb1
ora.FRA.dg ora....up.type ONLINE ONLINE ebsdb1
ora....ER.lsnr ora....er.type OFFLINE OFFLINE
ora....N1.lsnr ora....er.type OFFLINE OFFLINE
ora.asm ora.asm.type ONLINE ONLINE ebsdb1
ora.cvu ora.cvu.type OFFLINE OFFLINE
ora....SM1.asm application ONLINE ONLINE ebsdb1
ora....B1.lsnr application OFFLINE OFFLINE
ora.ebsdb1.gsd application ONLINE OFFLINE
ora.ebsdb1.ons application ONLINE ONLINE ebsdb1
ora.ebsdb1.vip ora....t1.type OFFLINE OFFLINE
ora....SM2.asm application ONLINE ONLINE ebsdb2
ora....B2.lsnr application OFFLINE OFFLINE
ora.ebsdb2.gsd application ONLINE OFFLINE
ora.ebsdb2.ons application ONLINE ONLINE ebsdb2
ora.ebsdb2.vip ora....t1.type OFFLINE OFFLINE
ora.gsd ora.gsd.type ONLINE OFFLINE
ora....network ora....rk.type ONLINE ONLINE ebsdb1
ora.oc4j ora.oc4j.type OFFLINE OFFLINE
ora.ons ora.ons.type ONLINE ONLINE ebsdb1
ora.prod.db ora....se.type OFFLINE OFFLINE
ora.scan1.vip ora....ip.type OFFLINE OFFLINE
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29067253/viewspace-2150694/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- RAC各節點時間同步的兩種方法
- 【RAC】部署安裝RAC時確保主節點的時間小於其他節點時間
- (轉)windows環境下rac節點時間同步方法Windows
- Oracle RAC新增節點Oracle
- Oracle RAC 新增節點Oracle
- 關於Oracle RAC節點間免密碼策略Oracle密碼
- Oracle Rac 刪除節點Oracle
- RAC節點之間通訊問題 兩節點 11g RAC
- rac中控制節點間並行並行
- [網摘] Oracle RAC新增節點Oracle
- 檢視oracle rac的節點Oracle
- 一次RAC節點當機的解決過程
- JavaScript計算兩個時間點之間的時間差JavaScript
- oracle11g RAC新增節點Oracle
- Oracle10g RAC 加節點Oracle
- 【RAC】Oracle10g RAC 節點重配的方式Oracle
- oracle 11g rac新增節點前之清除節點資訊Oracle
- 刪除oracle10g rac(rhel4)節點_節點Oracle
- Oracle rac時間不同步Oracle
- Oracle RAC時間同步(NTP/CTSS)Oracle
- ORACLE RAC環境下刪除節點Oracle
- 11g兩個節點RAC搭建單例項DG過程問題以及解決方法單例
- oracle 10g rac,刪除故障節點並新增新節點Oracle 10g
- oracle 10g rac 新增節點與刪除節點步驟Oracle 10g
- Linux Shell 時間運算以及時間差計算方法Linux
- Oracle RAC中第二節點不能載入nfs的共享磁碟方法OracleNFS
- undo表空間太大解決辦法
- 臨時表空間過大的解決方法
- oracle rac中設定時間同步Oracle
- RAC 雙節點 轉單節點流程
- 關於Oracle 11G RAC雙節點之間存在防火牆導致只能一個節點執行Oracle防火牆
- win10恢復到上一個時間節點的方法Win10
- oracle11g_RAC新增刪除節點Oracle
- Oracle 11g RAC重新新增節點Oracle
- Oracle 10g RAC刪除、增加節點Oracle 10g
- Oracle RAC 10g叢集節點增加Oracle
- Oracle 10g RAC增加節點例項Oracle 10g
- Oracle9.2.0.4 RAC系統加入新節點Oracle