Monday, February 10, 2020

Exadata - What is Exadata sundiag or sundiag.sh - Collecting sundiag Information

What is Exadata sundiag or sundiag.sh 

Oracle Exadata Diagnostics Collection Tool sundiag.sh

Very often when creating a Support Request (SR) for an issue on an Oracle Exadata Database Machine, you’ll need to run the script “sundiag.sh“.  

Which is the “Oracle Exadata Database Machine – Diagnostics Collection Tool“.

The tool collects a lot of diagnostics information that assist the support analyst in diagnosing your problem, such as failed hardware like a failed disk, etc.

More information Please refer the below MOS document:

SRDC – EEST Sundiag (Doc ID 1683842.1)

Oracle Exadata Diagnostic Information required for Disk Failures and some other Hardware issues (Doc ID 761868.1)

Below is the technical steps for running or collecting sundiag report.

[root@HOST1]# locate sundiag.sh
/opt/oracle.SupportTools/sundiag.sh

 [root@HOST1]#/opt/oracle.SupportTools/sundiag.sh
Oracle Exadata Database Machine - Diagnostics Collection Tool
Gathering Linux information

error: "Input/output error" reading key "net.ipv6.conf.all.stable_secret"
error: "Input/output error" reading key "net.ipv6.conf.bond0.stable_secret"
error: "Input/output error" reading key "net.ipv6.conf.bondeth0.stable_secret"
error: "Input/output error" reading key "net.ipv6.conf.bondeth1.stable_secret"
error: "Input/output error" reading key "net.ipv6.conf.default.stable_secret"
error: "Input/output error" reading key "net.ipv6.conf.eth0.stable_secret"
error: "Input/output error" reading key "net.ipv6.conf.eth1.stable_secret"
error: "Input/output error" reading key "net.ipv6.conf.eth2.stable_secret"
error: "Input/output error" reading key "net.ipv6.conf.eth3.stable_secret"
error: "Input/output error" reading key "net.ipv6.conf.eth4.stable_secret"
error: "Input/output error" reading key "net.ipv6.conf.eth5.stable_secret"
error: "Input/output error" reading key "net.ipv6.conf.ib0.stable_secret"
error: "Input/output error" reading key "net.ipv6.conf.ib1.stable_secret"
error: "Input/output error" reading key "net.ipv6.conf.lo.stable_secret"
Skipping collection of OSWatcher/ExaWatcher logs, Cell Metrics and Traces
Skipping ILOM collection. Use the ilom or snapshot options, or login to ILOM
over the network and run Snapshot separately if necessary.

/var/log/exadatatmp/sundiag_pexdbadm01_1707NM10AX_2018_02_04_01_04
Gathering dbms information
Generating diagnostics tarball and removing temp directory
==============================================================================
Done. The report files are bzip2 compressed in /var/log/exadatatmp/sundiag_pexdbadm01_1707NM10AX_2018_02_04_01_04.tar.bz2
==============================================================================
[root@HOST1]#

Regards,
Mallik

No comments:

Post a Comment

Automation Script | Archivelog Generation Hourly Monitoring

1. List out all the running databases and pic one database where we want to monitore the archive log generation from last 1 month. [oracle@o...