Grid Infrastructure 12c ile gelen Diagsnap

Diagsnap, 12.1.0.2 GI’da tanıtılan yeni bir özellik olup CHM(Cluster Health Monitor) osysmod ile normalde toplanmayan ilave işletim sistemi istatistiklerini toplayan diagsnap kaynağını yönetir.

Diagsnap metrik toplama işlemi, baseline metriklerini toplamak için otomatik olarak her 15 dakikada bir çalışır. Diagsnap metrik toplama işlemi, aşağıda belirtildiği gibi spesifik olay üretimi sırasında da meydana gelir.

Diagsnap’i tetikleyen güncel olaylar :

• cssd prosesinin eksik network heartbeat’leri raporlaması
• gipcd prosesinin bir veya daha fazla interface’in down durumda olması yada down duruma geliyor olmasını tespit etmesi
• gipcd prosesinin rank olayları

Diagsnap aşağıdaki işletim sistemi komutlarını çalıştırır :

• iostat
  
• netstat
  
• lsof {gipcd pid | ocssd pid | ocssd pid | crsd pid | ohasd pid}
  
• arp
  
• ifconfig
  
• ping (private interconnect üzerinden)
  
• tcpdump
  
• top

Diagsnap logları 12.1 ve 12.2.0.1 için $ORACLE_BASE/diagsnap dizininde , 18.1 ve sonrası için $ORACLE_BASE/crsdata/crf/diagsnap dizininde yer alır.

Log içeriği aşağıdaki gibi kontrol edilebilir.

[oracle@orcl01 ]$ cd /u01/app/oracle/diagsnap/orcldb01.localdomain
[oracle@orcl01 ]$ tail -n 40 diagsnap_orcldb01.localdomain.log
2017-05-12 11:02:17.609: [62334][MSG] Spawned process 200080 for : ping_orcldb02_ib0_192_168_10_3
2017-05-12 11:02:17.610: [62334][MSG] Spawned process 200083 for : ping_orcldb08_ib0_192_168_10_15
2017-05-12 11:02:17.610: [62334][MSG] Spawned process 200085 for : ping_orcldb05_bondeth0-4_10_124_1_125
2017-05-12 11:02:17.611: [62334][MSG] Spawned process 200087 for : lsof_22188_ohasd_bin
2017-05-12 11:02:17.611: [62334][MSG] Spawned process 200090 for : traceroute_orcldb01_ib0_192_168_10_1
2017-05-12 11:02:17.612: [62334][MSG] Spawned process 200092 for : netstat_s
2017-05-12 11:15:52.666: [248239][MSG] diagsnap.pl invoked with stop option in CHM mode
2017-05-12 11:15:52.785: [248239][MSG] [stop] The deamon (167169) is not running.
2017-06-15 14:34:13.539: [75495][MSG] diagsnap.pl invoked with stop option in CHM mode
2017-06-15 14:34:13.668: [75495][WRN] Failed stopping the resource
2017-06-15 14:36:31.834: [86352][MSG] diagsnap.pl invoked with stop option in CHM mode
2017-06-15 14:36:31.968: [86352][WRN] Failed stopping the resource
2017-07-10 11:37:29.282: [319803][MSG] diagsnap.pl invoked with stop option in CHM mode
2017-07-10 11:37:29.412: [319803][WRN] Failed stopping the resource
2017-07-10 14:00:37.135: [133362][MSG] diagsnap.pl invoked with stop option in CHM mode
2017-07-10 14:00:37.284: [133362][WRN] Failed stopping the resource
2018-09-12 19:11:33.450: [373119][MSG] diagsnap.pl invoked with stop option in CHM mode
2018-09-12 19:11:33.590: [373119][WRN] Failed stopping the resource
2018-09-12 19:17:02.905: [46277][MSG] diagsnap.pl invoked with stop option in CHM mode
2018-09-12 19:17:03.059: [46277][WRN] Failed stopping the resource
2018-10-05 22:35:59.949: [245601][MSG] diagsnap.pl invoked with stop option in CHM mode
2018-10-05 22:36:00.099: [245601][MSG] [stop] The deamon (167169) is not running.
2018-10-05 22:36:02.939: [245944][MSG] diagsnap.pl invoked with stop option in CHM mode
2018-10-05 22:36:03.075: [245944][MSG] [stop] The deamon (167169) is not running.
2018-10-29 01:55:09.765: [199565][MSG] diagsnap.pl invoked with stop option in CHM mode
2018-10-29 01:55:09.910: [199565][MSG] [stop] The deamon (167169) is not running.
2018-10-29 01:55:12.712: [199636][MSG] diagsnap.pl invoked with stop option in CHM mode
2018-10-29 01:55:12.844: [199636][MSG] [stop] The deamon (167169) is not running.
2018-11-21 05:14:16.082: [50548][MSG] diagsnap.pl invoked with stop option in CHM mode
2018-11-21 05:14:16.215: [50548][MSG] [stop] The deamon (167169) is not running.
2018-11-21 05:14:18.801: [50588][MSG] diagsnap.pl invoked with stop option in CHM mode
2018-11-21 05:14:18.928: [50588][MSG] [stop] The deamon (167169) is not running.
2018-12-14 08:33:21.734: [267245][MSG] diagsnap.pl invoked with stop option in CHM mode
2018-12-14 08:33:21.880: [267245][MSG] [stop] The deamon (167169) is not running.
2018-12-14 08:33:24.914: [267926][MSG] diagsnap.pl invoked with stop option in CHM mode
2018-12-14 08:33:25.045: [267926][MSG] [stop] The deamon (167169) is not running.
2019-01-06 11:52:33.963: [325988][MSG] diagsnap.pl invoked with stop option in CHM mode
2019-01-06 11:52:34.089: [325988][MSG] [stop] The deamon (167169) is not running.
2019-01-06 11:52:37.082: [326054][MSG] diagsnap.pl invoked with stop option in CHM mode
2019-01-06 11:52:37.210: [326054][MSG] [stop] The deamon (167169) is not running.

Diagsnap özelliği kapatıp yeniden etkinleştirmek mümkündür.

Etkinleştimek için :

[oracle@orcldb01 ]$ oclumon manage -enable diagsnap
Diagsnap option is successfully Enabled on orcldb01
Diagsnap option is successfully Enabled on orcldb02
Diagsnap option is successfully Enabled on orcldb03
Diagsnap option is successfully Enabled on orcldb04
Diagsnap option is successfully Enabled on orcldb05
Diagsnap option is successfully Enabled on orcldb06
Diagsnap option is successfully Enabled on orcldb07
Diagsnap option is successfully Enabled on orcldb08
Successfully Enabled diagsnap

Kapatmak için :

[oracle@orcldb01 ]$ oclumon manage -disable diagsnap
Diagsnap option is successfully Disabled on orcldb01
Diagsnap option is successfully Disabled on orcldb02
Diagsnap option is successfully Disabled on orcldb03
Diagsnap option is successfully Disabled on orcldb04
Diagsnap option is successfully Disabled on orcldb05
Diagsnap option is successfully Disabled on orcldb06
Diagsnap option is successfully Disabled on orcldb07
Diagsnap option is successfully Disabled on orcldb08
Successfully Disabled diagsnap

Mevcut durumun tespiti için aşağıdaki komut kullanılabilir :

[oracle@orcld01 ]$ egrep '^DIAGSNAP|^PSTACK' $GRID_HOME/crf/admin/crf$(hostname -s).ora
PSTACK=Disable
DIAGSNAP=Disable