How to make Explorer Report with Oracle Explominer tool


In this topic I will provide detail information how to generate system wide report based on Oracle Explorer Output

In System Administration and Support service work is very often is necessary to find out the root cause
of Solaris OS performance issues or Sun HW firmware revision analyze. To do is necessary to have
explorer output from current investigated system. Explorer package can be downloaded and installed
separate from Oracle Download web site or installed from EIS (Enterprise Installation Service ) DVD media.

The explorer packages is named – SUNWexplo. Install it as required pkgadd -d /cdrom/sun/tools/explorer/ SUNWexplo
Once you installed it – run to collect explorer report:

# /opt/SUNWexplo/bin/explorer -d default

Now you need install explominer from EIS DVD media, from /cdrom/sun/tools/explominer, just unzip it to some one permanent folder (exp. to /opt/explominer).

Now we will generate Human readable report from explorer by using explominer tool:

#/opt/explominer/explominer.sparc –f /opt/SUNWexplo/output/explorer.847c1fc3.server-2012.01.17.14.55 -o /home/user/EXPLOMINER_REPORT/server -e /cdrom/sun/patch/etc/ -c -m -r -i -a


You can see next output in console during generating report:

================================================================================
=== Copyright © 2011, Oracle and/or its affiliates. All rights reserved. ===
=== ExploMiner v2.9.10 EIS-CD 12/2011 ===
================================================================================
PRODIR is:
[explorerdir]: /home/eldara/WORK4/explorer.847c1fc3.japan-2012.01.17.14.55
[outputdir]: /home/eldara/WORK4/EXPLOMINER_REPORT/japan
[eisdir]: /net/ojmgt02/jet/install/patches/eiscd/14DEC11/sun/patch/etc/

Contents Output file name
——————————————————————————–
HTML_Check_Results [outputdir]/ExploMiner_Output_eldara.html
Alerts [outputdir]/ExploMiner_Alerts_Output_eldara
msg.pl output [outputdir]/ExploMiner_messages.out.eldara
Patchlist [outputdir]/ExploMiner_Patchlist_eldara
Ordered Patchlist [outputdir]/ExploMiner_Patchorder_eldara
patchdiag output [outputdir]/ExploMiner_patchdiag.out.eldara
filtered patchdiag output [outputdir]/ExploMiner_patchdiag.out.eldara_without_CURRENT
security patches output [outputdir]/ExploMiner_Security_Patches_eldara

Patch-Matrix-files should not be older than 45 days.
================================================================================
NOTICE: ExploMiner does now also include the revision of patches included
in the Solaris Recommended Patch Set (see "fps:") in addition
to the latest revision (see "current:"), and – if this revision
is lower than the latest patch revision – the respective release
date.

IMPORTANT: ExploMiner is primarily intended for reactive, break-fix support.
It shows the latest revision (see "current") of any patch that is
found to be relevant, eventually preceded by the revision of that
patch that is included in the Solaris Recommended Patch Set
(see "fps") from the day when ExploMiner was run.

Patches listed in its output might be relevant to any known issues,
but their presence herein does not necessarily manifest a general
patch recommendation.

ExploMiner is not primarily intended for proactive patch management!

IMPORTANT: Please note: Despite the instructions on MOS, some customers may
have improperly loaded attachments into this system that contain
electronic protected health information (ePHI).
Should you encounter any ePHI, immediately delete all copies from
this system and purge any local copies.
See the GCS Health Legislation Management section of the MOS Desk
Manual for procedures on how to do this.
To learn about how to recognize ePHI and Oracle’s need to keep it out
of GCS systems, visit the HIPAA Regulatory Compliance workspace at
https://stbeehive.oracle.com/teamcollab/overview/Regulatory+Compliance+-+Health+Legislation+Management+(HIPAA+and+HITECH)

NOTICE: PatchId: 123894: revision from showrev-p.out (-29) > (-25) from patchdiag.xref
NOTICE: PatchId: 123894: revision from showrev-p.out (-29) > (-25) from EIS patchdiag.xref
NOTICE: PatchId: 119252: revision from showrev-p.out (-30) > (-29) from EIS patch.list
NOTICE: PatchId: 119315: revision from showrev-p.out (-21) > (-19) from EIS patch.list
NOTICE: PatchId: 119368: revision from showrev-p.out (-05) > (-04) from EIS patch.list
NOTICE: PatchId: 120094: revision from showrev-p.out (-32) > (-30) from EIS patch.list
NOTICE: PatchId: 120199: revision from showrev-p.out (-16) > (-15) from EIS patch.list
NOTICE: PatchId: 120286: revision from showrev-p.out (-04) > (-03) from EIS patch.list
NOTICE: PatchId: 120292: revision from showrev-p.out (-04) > (-02) from EIS patch.list
NOTICE: PatchId: 120410: revision from showrev-p.out (-34) > (-33) from EIS patch.list
NOTICE: PatchId: 120460: revision from showrev-p.out (-19) > (-17) from EIS patch.list
NOTICE: PatchId: 121118: revision from showrev-p.out (-17) > (-16) from EIS patch.list
NOTICE: PatchId: 121308: revision from showrev-p.out (-22) > (-20) from EIS patch.list
NOTICE: PatchId: 122212: revision from showrev-p.out (-42) > (-40) from EIS patch.list
NOTICE: PatchId: 122259: revision from showrev-p.out (-04) > (-03) from EIS patch.list
NOTICE: PatchId: 122470: revision from showrev-p.out (-05) > (-03) from EIS patch.list
NOTICE: PatchId: 123005: revision from showrev-p.out (-08) > (-07) from EIS patch.list
NOTICE: PatchId: 123893: revision from showrev-p.out (-29) > (-22) from EIS patch.list
NOTICE: PatchId: 123894: revision from showrev-p.out (-29) > (-25) from EIS patch.list
NOTICE: PatchId: 124457: revision from showrev-p.out (-03) > (-02) from EIS patch.list
NOTICE: PatchId: 124628: revision from showrev-p.out (-13) > (-10) from EIS patch.list
NOTICE: PatchId: 124630: revision from showrev-p.out (-44) > (-42) from EIS patch.list
NOTICE: PatchId: 125533: revision from showrev-p.out (-16) > (-15) from EIS patch.list
NOTICE: PatchId: 126365: revision from showrev-p.out (-18) > (-16) from EIS patch.list
NOTICE: PatchId: 144325: revision from showrev-p.out (-02) > (-01) from EIS patch.list
No file ‘sysconfig/ifconfig-a-modlist.out’ found
SunOS_check

/Patch_Clusters/SUNOS_pkgadd.patch_matrix is older than 45 days

/Patch_Clusters/SUNOS_Kernel.patch_matrix is older than 45 days

/Patch_Clusters/SUNOS_Library.patch_matrix is older than 45 days

/Patch_Clusters/SUNOS_SMF.patch_matrix is older than 45 days

/Patch_Clusters/SUNOS_NTP.patch_matrix is older than 45 days

/Patch_Clusters/SUNOS_vold.patch_matrix is older than 45 days

/Patch_Clusters/SUNOS_timezones.patch_matrix is older than 45 days

/Patch_Clusters/SUNOS_syslogd.patch_matrix is older than 45 days

/Patch_Clusters/SUNOS_UFS.patch_matrix is older than 45 days

/Patch_Clusters/SUNOS_MTB.patch_matrix is older than 45 days

/Patch_Clusters/SUNOS_ZFS.patch_matrix is older than 45 days

/Patch_Clusters/SUNOS_VXFS.patch_matrix is older than 45 days

/Patch_Clusters/SUNOS_zones.patch_matrix is older than 45 days
non-global native zones installed: 2
non-global branded zones installed: 0
non-global clustered zones installed: 0

/Patch_Clusters/SUNOS_Printing.patch_matrix is older than 45 days

/Patch_Clusters/SUNOS_Java.patch_matrix is older than 45 days

/Patch_Clusters/SUNOS_Webconsole.patch_matrix is older than 45 days

/Patch_Clusters/SUNOS_smpatch.patch_matrix is older than 45 days

/Patch_Clusters/SUNOS_SMC.patch_matrix is older than 45 days

/Patch_Clusters/SUNOS_SunVTS.patch_matrix is older than 45 days

/Patch_Clusters/SUNOS_FMA.patch_matrix is older than 45 days
Sun_Server_check
OBP_check
Network_check

/Patch_Clusters/COMMS_bge.patch_matrix is older than 45 days

/Patch_Clusters/COMMS_nxge.patch_matrix is older than 45 days

/Patch_Clusters/COMMS_tcp-ip.patch_matrix is older than 45 days

/Patch_Clusters/COMMS_ipmp.patch_matrix is older than 45 days

/Patch_Clusters/COMMS_socket.patch_matrix is older than 45 days

/Patch_Clusters/COMMS_TLI.patch_matrix is older than 45 days

/Patch_Clusters/COMMS_RPC.patch_matrix is older than 45 days

/Patch_Clusters/COMMS_nscd.patch_matrix is older than 45 days

/Patch_Clusters/COMMS_LDAPclient.patch_matrix is older than 45 days

/Patch_Clusters/COMMS_inetd.patch_matrix is older than 45 days

/Patch_Clusters/COMMS_NFSclient.patch_matrix is older than 45 days
OSP_check

/Patch_Clusters/OSP_mpt_sas.patch_matrix is older than 45 days

/Patch_Clusters/OSP_mpt.patch_matrix is older than 45 days

/Patch_Clusters/OSP_qlc.patch_matrix is older than 45 days

/Patch_Clusters/OSP_SAN.patch_matrix is older than 45 days

/Patch_Clusters/OSP_sd.patch_matrix is older than 45 days

/Patch_Clusters/OSP_DiskUtils.patch_matrix is older than 45 days

/Patch_Clusters/OSP_VXVM.patch_matrix is older than 45 days

/Patch_Clusters/OSP_VXVM-GUI.patch_matrix is older than 45 days

/Patch_Clusters/OSP_VXVM-GUI.patch_matrix is older than 45 days
rootdg: 0

/Patch_Clusters/OSP_SDS.patch_matrix is older than 45 days

/Patch_Clusters/OSP_st.patch_matrix is older than 45 days
Graphics_check

/Patch_Clusters/GRAPH_X11.patch_matrix is older than 45 days

/Patch_Clusters/GRAPH_X11.patch_matrix is older than 45 days

/Patch_Clusters/GRAPH_X11.patch_matrix is older than 45 days

/Patch_Clusters/GRAPH_X11.patch_matrix is older than 45 days

/Patch_Clusters/GRAPH_X11.patch_matrix is older than 45 days

/Patch_Clusters/GRAPH_X11.patch_matrix is older than 45 days

/Patch_Clusters/GRAPH_X11.patch_matrix is older than 45 days

/Patch_Clusters/GRAPH_X11.patch_matrix is older than 45 days

/Patch_Clusters/GRAPH_X11.patch_matrix is older than 45 days

/Patch_Clusters/GRAPH_X11.patch_matrix is older than 45 days
Security_check

/Patch_Clusters/Security_BSM.patch_matrix is older than 45 days
================================================================================
ExploMiner Operational Risk Index calculation [Aug/03/11]
——————————————————————————–
Patch eOri: 1316
Alert eOri: 24944
Total eOri: 26260
Average eOri: 26838
Deviation from the Average: -3%
(A negative result means a lower risk in comparison to the average)
(A positive result means a higher risk in comparison to the average)
================================================================================


In attachment file you can see how can report looks. The report was generate for of our production system Mx000 class server.

ExploMiner_EIS_Patchlist_server —————— detail list of required patches with description and source place for installation
ExploMiner_eOri_server —————————- ExploMiner Operational Risk Index calculation
ExploMiner_Output_server.html ——————- Full Explominer report in HTML format
ExploMiner_Patchlist_server ———————– This file contains a list of Patches and their dependent Patches
ExploMiner_Patchorder_server ——————– Just a list of required to install patches
ExploMiner_Security_Patches_server ————- List of Security-Patches are NOT up-to-date


Eldar Aydayev ©
UNIX Systems Professional Consultant | Aydayev’s Investment Business Group
1676. 23rd Ave, Noriega St. San Francisco, CA 94122
E-mail: eldar@aydayev.com
URL:
http://eldar.aydayev.com
LinkedIn:
http://www.linkedin.com/in/eldar
Phone: +1 (650) 2062624