Install sql_diagnoser

This topic describes how to install sql_diagnoser.

Environment requirements

Java Development Kit (JDK) 8 or later is required.

Prerequisites

The default port 8080 of sql_diagnoser is not occupied. You can also customize a port.

Procedure

1. Download the sql_diagnoser installation package from OceanBase Download Center and decompress it.

2. Run the following command to install sql_diagnoser: nohup java -jar /home/admin/sql-diagnoser-4.2.0.0.jar &.

   To specify a listening port, add -Dserver.port to the code. Here is an example: nohup java -Dserver.port=9090 -jar /home/admin/sql-diagnoser-4.2.0.0.jar &.

3. Visit localhost:8080 from a browser and check whether the tool is installed. After the tool is installed, logs are stored in ${user.home}/logs/ob-tool/.