Oracle Diagnostics.

Oracle diagnostics is one of the tools that aim at achieving enhanced supportability for your Oracle Applications instance.

Oracle diagnostics provides a series of predefined test that can be run against your ebusiness suite to determine any performance or configuration bottlenecks. The diagnostics tests are divided into various categories ranging form technical and functional areas. Separate test groups are created for each application with oracle applications like General Ledger, Applications DBA etc. For each product the tests are further categorized into problem areas like installation issues, data issues customizations etc.

A periodic execution of these test is recommended by oracle to check the sanity of your Oracle Applications instance over a period of time.

Oracle diagnostics test are mostly written in JSP,JAVA or PLS/SQL with the user interface mostly being web based in the form of HTML or JSP.(Though there is also a command line interface available).

The web based interface for Oracle diagnostics can either be launched from Oracle Applications Manager or via the CRM administrators console (http:///OA_HTML/jtflogin.jsp).

The web base interface can be launched either as standalone HTML user via the URL http://:/OA_HTML/jtfqalgn.htm or as an administrative -level user through the CRM administrators console or Oracle Applications Manager Console.

The command line interface can be used by the following command

java -DJTFDBCFILE= -Dframework.Logging.system.filename=
-Dservice.Logging.common.filename= oracle.apps.jtf.regress.qatool.QAConsole

Apart from the predefined test Oracle diagnostics also allows for creating custom test and unit test cases. You can also create most of these test using user Interface also that is without any coding involved.

Oracle diagnostics tools are come as a product within Oracle Applications with the product name IZU. In case your Oracle Applications instances does not have this product, you must first install this product using AD Splicer.

The results of the diagnostics test can be viewed as a report in a web based user interface for a particular diagnostics test session. This output can be saved to the local PC and uploaded to metalink for further support. The diagnostics test results and the associated statistics are also available at the database level in the following tables JTF_DIAGNOSTIC_LOG and JTF_DIAGNOSTIC_STATS.

Further you can also use Oracle Applications Manager to schedule automatic execution of diagnostics tests.

Since the results of the diagnostics test might contain potentially sensitive data segregated diagnostic roles are available to restrict the type of test available to a particular user. Diagnostic roles include Super User, Application User, End User and Anonymous user.

The latest release of Oracle diagnostics is 2.4,once you have installed/available IZU in Oracle Applications you can apply the latest Oracle diagnostics 2.4 test using adpatch. However its important to note that Oracle Diagnostics can be installed only on systems 11.5.4 and higher. Also JDK 1.3.1 or higher is recommend to use oracle diagnostics.

This current version of Oracle diagnostics tools are launched directly within Oracle applications. Once you have completed the installation of Oracle diagnostics you can assign the seeded responsibility 'Oracle Diagnostics Tool' to any valid ebusiness suite user.

You can refer to metalink note 358831.1 for details instructions on doing this.

Complete reference on Oracle Diagnostics is also available in the Oracle Applications Supportability Guide in the applications documentation CD.