1. The "connection to database fail, please check connection parameters" error is reported. What can I do?

    You can check whether the specified username (-u), password (-p), port number (-P), and service name (-d) of the database are correct.

  2. The "TNS:listener does not currently know of service requested in connect descriptor" error is reported. What can I do?

    You can check whether the value of the -d parameter is the service name of the database.

  3. The agent fails to start because a JDK whose version is earlier than 1.8 is installed on the local machine. What can I do?

    When you use the collector, the JDK on the local server is prioritized. If the JDK version is earlier than 1.8, the system will prompt that the version is not supported. You can forcibly specify JAVA_PATH in the collect_.sh script as the JDK installation directory by replacing JAVA_PATH='which java' with JAVA_PATH=''.

  4. How do I run the collector on macOS?

    You must install JRE of JDK V1.8 or later on the local server and download the collector of the Linux version.

  5. Why is the number of index objects in the collection results inconsistent with the actual number? Unique indexes and primary indexes in Oracle databases are merged into the DDL statements of Table objects.

  6. When I try to collect data from an Oracle Database Express Edition database, an error message is returned indicating that the sqltext information is missing. What can I do?

    You can run alter system set control_management_pack_access="DIAGNOSTIC+TUNING";exec dbms_workload_repository.create_snapshot(); on your database. You can then re-collect data without restarting the database.

  7. The "insufficient account permission, please refer to user guide and re-configure account" error is reported. What can I do?

    You can check whether the permissions specified in the Collect database data topic in User Guide have been granted to the account, or re-authorize the account by running the SQL statements specified in that topic.

  8. The "GC overhead limit exceeded" error is reported. What can I do?

    You can expand the physical memory of the collector and expand the startup memory by adding -Xmx16g to the value of the JVM_OPTIONS parameter in the startup script.

  9. How do I view a large file in the collection results on macOS or Linux?

    You can copy a large file to a temporary directory, use the split -b 10m eoa_tmp_objects_ext.csv command to split the file into small files, and then view them separately. These small files will be named as xaa or xab and saved in the same directory.

  10. The "transaction log is not configured, please refer to FAQ and modify log configuration" error is reported. What can I do? You can perform the following steps to enable the log service. Proceed with caution when you enable the log service.

    1. Set a path to store the archive files based on the running environment of the Oracle database.

      alter system set log_archive_dest_1='location=<file_path>';
      
    2. If permitted, shut down the database and bring the database into the mount state.

      shutdown immediate
      startup mount
      
    3. Configure the archiving mode for the database.

      alter database archivelog
      
    4. Open the database.

      alter database open
      
    5. Run the following SQL statement to verify whether SUPPLEMENTAL_LOG_DATA is enabled.

      select t.SUPPLEMENTAL_LOG_DATA_MIN from v$database t
      

      If the returned value is NO, SUPPLEMENTAL_LOG_DATA is disabled. Execute the following statement:

      alter database add supplemental log data;