ORAchk (EXAchk) und der Collection Manager (Teil 1)

ORAchk & EXAchk sind wichtige Tools im täglichen Oracle DBA Geschäft. Allerdings habe diese Tools wenn man Sie einmalig oder mehrfach startet den großen Nachteil das man jeweils einzelne Reports erhält und diese nicht miteinander vergleichen kann, oder eine Historie erhält. Es bedeutet im Umkehrschluss man muss sich selbst eine „Ordnung“ überlegen und die Verwaltung übernehmen.

Genau an diesem Punkt kommt nun der „Collection Manager“ ins Spiel, der eine komplette APEX Anwendung ist und die Verwaltung sämtlicher Collections (Reports) für die Datenbanken im Unternehmen übernimmt.

Grundvorraussetzung ist eine  lauffähige APEX Umgebung

Step by Step die Installation


laufende Oracle DB 11.2, 12.1, 12.2 und Listener Konfiguration abgeschlossen

Download apex18.1

http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html">http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html" data-wplink-url-error="true">http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html">http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html


Installationsverzeichnis erstellen

mkdir /u01/apex

unzip apex_18.1.zip

APEX Setup

Anlegen eines neuen Tablespace



Base Directory ist „/u01/apex“

Wichtig für das Setup des „Embedded PL/SQL Gateway (EPG)“ im späteren Verlauf der Installation

cd /u01/apex/apex

SQL> con sys AS SYSDBA

-- @apexins.sql tablespace_apex tablespace_files Temp_TBL images

SQL> @apexins.sql APEX APEX TEMP /i/

Ändern des  Admin Passwort "apxchpwd.sql"

SQL> con sys AS SYSDBA
SQL> @apxchpwd.sql


Ich nutze das „Embedded PL/SQL Gateway“ (EPG)

Das Base Directory ist „/u01/apex“

Es darf nicht „/u01/apex/apex“ im Folgenden Step angegeben werden da sonst die Images nicht korrekt installiert werden


SQL> @apex_epg_config.sql /u01/apex

Nun muss der User ANONYMOUS entsperrt werden



Port check für XML DB Protocol Server





Soll der Port auf 8080 gesetzt werden dann wie folgt umsetzen

SQL> EXEC DBMS_XDB.sethttpport(8080)

Das war die Installation. Zum Abschluss sollte man unbedingt die Logfiles prüfen ansonsten kann man aus dem Browser APEX starten


oder für den Administration Workspace


So sollte der Login Screen aussehen


Im Teil 2 beschreibe ich dann wie man den Collection Manager für Exachk oder ORAchk konfiguriert und dann mit den Collections arbeiten kann.


Stay tuned :-)










exachk 18.2.0_20180518 released

Oracle released the new Version of exachk. The version is shown as 18.2.0_2018052018 so far so good. The next sentence in the Note is: „What’s new in exachk may be found in the „What’s New in″ section of the User’s Guide available here..“

The new Release model from Oracle is really confusing. From my point of view it makes no sense that you download a Version as 18.2.0 and then the Documentation has a Version






New exachk version available


Oracle Support released a new exachk Version

What is new?

  • all related checks in the same place
  • new checkboxes at the top of the report to allow you to selectively show or hide checks based on their status
  • all checks which have passed are hidden by default
  • E-Business Suite checks are now grouped by the module they apply to and the E-Business Suite
  • Reduced execution time
  • Improved security for files and connection details
  • receive HTML report via email from adhoc exachk run
  • asrexacheck 4.0 released and integrated
  • exachk output now also available in JSON format which can be utilized by non-Oracle monitoring and analytics tools
  • Enhanced email configuration functions

So keep your exachk uptodate.

New exachk Version released


Oracle Support released Exachk Version The whole description was found as MOS article “Oracle Exadata Database Machine Exachk or HealthCheck (Doc ID 1070954.1)”.

What are the innovations: a lot of Bugs are fixed.

New Functions

Auto-update when in daemon mode without user intervention
Automatic download from My Oracle Support
GoldenGate support
Siebel support

New Features

Support for X5 hardware and Exadata software version
Support for Virtual Machines on Exadata
Support for asymmetrically distributed RDBMS homes
Exadata, Supercluster,Zero Data Loss Recovery Appliance
Support for Single Instance using Oracle Restart
New report section: “Infrastructure Software and Configuration Summary”
Exadata, Supercluster,Zero Data Loss Recovery Appliance
New report section: “Findings needing further review”
New report section: “Platinum”
Exadata, Supercluster
Functionality for pre-patching subset of checks “-prepatch”

I just installed the new version and I hope that the new „pre-patching“ function works fine because it should be a great help in the future.



Why exachk?

Exachk is a comprehensive utility on an Exadata Systems for validating hardware, firmware, software and the configuration settings.

Normally after a system setup as a post installation step exachk validates the setup. If for any reason exachk isn’t installed on the compute node you can download it on My Oracle Support. The My Oracle Support note id : 1070954.1.

If installed you can locate the Software under the directory  “/opt/oracle.SupportTools” on the first compute node of an Exadata system.

Before running exachk check the installed version and if expired download and install the actual version from MOS. The current Production Version is:

[root@exachk_121021]# ./exachk -v


Starting the exachk from the command line it looks like the following output.

exachk_121021]# ./exachk -a

CRS stack is running and CRS_HOME is not set. Do you want to set CRS_HOME to /u01/app/[y/n][y]y

Checking ssh user equivalency settings on all nodes in cluster

Node txdb04 is configured for ssh user equivalency for root user

Searching for running databases . . . . .

. . . . . . . . . . . . . . . . . .

List of running databases registered in OCR
	All of above
None of above

Select databases from list for checking best practices. For multiple databases, select 10 for All or comma separated number like 1, 2 etc [1-11][10].

Depending from the system load the exachk finished here in this example after 20 minutes.

First of all there will be a summary with some major and detailed information’s concerning the installed system.


Weiterlesen „Why exachk?“

Troubleshooting an Exadata Environment on the command line

This article describes how you can do an effective Exadata troubleshooting from the command line and show some “tools” which you can used.

What are major components inside the Exadata System? (I know that there are some other components like KVM switches and PDU etc. but they makes normally very rare problems.)

  • Compute Node
  • Storage Cells
  • Infiniband Switches

Troubleshooting Exadata Compute Nodes

We have more or less three components on the Compute Node:

  • Clusterware, ASM
  • Oracle Rdbms
  • Config Files related to the Storage Cells

Clusterware, ASM and the Rdbms Software are the same as you are working on a RAC node there is no difference. While the Exadata System is directly connected to the Storage Cells you need to check for the Cell Config Files.

Troubleshooting the Compute Nodes

Type Description
OS Syslogs /var/log/messages
OS & Clusterware Exawatcher Logs ..oracle.oswatcher/osw/archive/
Oracle Rdbms Exachk Script Comprehensive Report very detailed
 ASM / Storage Cells related KFOD / V$Views ASM tools used by Support : KFOD, KFED, AMDU (Doc ID 1485597.1)Storage Cell config files

Troubleshooting Exadata Storage Cells

First a overview from the documentation


What are the components of the Storage Cell

  • Restart Server
  • Management Server
  • cellsrv

Troubleshooting the Storage Cell

Type Description
OS Syslogs /var/log/messages
Cell Server adrci You can use the ‘adrci’ tool like you were using it for the Rdbms Software
cellcli List alerthistory


Troubleshooting Infiniband Switch

Type Description
OS Exawatcher The Logfiles from the Exawatcher
Topology check ibdiagtoolsverify-topology Check all cables, links and speed. For more information use “-h” option
ibdiagtoolsinfinicheck Validate the configuration and performance



Troubleshooting an Exadata System looks very similar to an Oracle RAC environment with ASM and Clusterware. Major additional components are the Storage Cells and the Infinband Switches.

So if you would like to do a troubleshooting in a Exadata environment on the command line here are some additional tips:

  • Run the exachk every month and before and after every upgrade. Exachk is a very powerful tool. A must for the daily business.
    • Keep in mind that the new version has an option
    • “–diff <old_report> <new_report>”
      • So it is very easy to find differences between System changes
  •  Automate your work by some small shell scripts here an example for reading the alerthistory of the Storage Cells

for i in 1 2 3 4 5 6 7

ssh root@cell{$i} “cellcli –e list alerthistory |grep –I critical”

With these kind of easy scripts you can check your environment very fast and effectively.

Stay tuned while I will show the benefit of an exachk report.