Install and configure an Oracle plugin in Windows

Install and configure an Oracle plugin in Windows

Prerequisites

  1. Ensure that the Site24x7 Windows server monitoring agent is installed in the system where the Oracle instance is running.

  2. Ensure python3 is installed in the system and add it to the Windows path. 
    Refer to the link below for adding python3 to the Windows path:
    https://support.site24x7.com/portal/en/kb/articles/run-python-plugin-scripts-in-windows-servers

  3. The module cx_Oracle requires a Visual Studio C++ compiler. Before installing cx_Oracle, download and install the Visual Studio C++ build tools from the link below:
    https://visualstudio.microsoft.com/downloads/






  4. Set the build path of Visual Studio in the PATH environment variable to load the required libraries so that the Visual Studio C++ compiler can interpret the cx_Oracle package.
    Example path:
    C:\Program Files (x86)\Microsoft Visual Studio\2017\Community\VC\Auxiliary\Build

  5. Install the cx_Oracle Python package using Command Prompt with the help of the command given below:
    pip3 install cx_Oracle

  6. Grant the following permissions to the user:
    "grant select_catalog_role to {username}"
    "grant create session to {username}"

Plugin installation


  1. Download the required plugin files from our Oracle Full Stack Monitoring plugins repository on GitHub.
    For example, if you want to add the OracleBlockingLocks plugin, download OracleBlockingLocks.py and OracleBlockingLocks.cfg.

  2. Once downloaded, update the configuration file (.cfg) for the downloaded plugin.
    Instructions and details for the .cfg file are provided in the README file of the respective plugin.

    For example, for the plugin OracleBlockingLocks, the .cfg file will look like the following:
    [ORCL]
    hostname=<HOSTNAME>
    port=<PORT>
    sid=<SID>
    username=<USERNAME>
    password=<PASSWORD>
    logs_enabled="False"
    log_type_name =None
    log_file_path=None
    oracle_home=None

    Note:     Update the <HOSTNAME>, <PORT>, <USERNAME>, and <PASSWORD> with the appropriate details.

  3. After adding the configuration details in the .cfg file, create a folder with the same name as the .py and .cfg files, add the files to it, and move the folder containing the files into the Windows agent's Plugins directory:
    C:\Program Files(x86)\Site24x7\WinAgent\monitoring\Plugins\

    For example, for the OracleBlockingLocks plugin:
    1. Create a folder named OracleBlockingLocks.
    2. Put the OracleBlockingLocks.py and OracleBlockingLocks.cfg files into the OracleBlockingLocks folder.
    3. Move the folder into the Windows agent's directory given below:
      Windows -> C:\Program Files(x86)\Site24x7\WinAgent\monitoring\Plugins\OracleBlockingLocks
The agent will automatically execute the plugin within five minutes and send performance data to the Site24x7 data center.

    • Related Articles

    • Troubleshoot the "ORA-12514" error when installing Oracle plugins

      When installing the Oracle database monitoring plugins, you may encounter the following error: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor: This error typically occurs during attempts to establish a ...

    • How to view perfmon counters in Windows?

      To monitor specific Windows performance (perfmon) counters with Site24x7's plugin integration, you need to get the names of the performance counters from the Windows Performance Monitor on your server. Follow the steps below to get the names of the ...

    • How to uninstall the Site24x7 Windows Server Monitoring Agent

      Method 1: To uninstall the Site24x7 Windows Server Monitoring Agent, click the link below: https://staticdownloads.site24x7.com/server/Site24x7WindowsAgentUninstall.zip Unzip and execute the Uninstall.bat file in the Command Prompt as an ...

    • Troubleshoot connection errors in the MySQL plugin

      When configuring the MySQL plugin, you may encounter the following errors: Error : Connection Error - This error typically indicates that there is a problem establishing a connection to the database. Sometimes, this message is supplemented with an ...

    • Troubleshoot the "pymysql module not found" error when installing the MySQL plugin

      If you're encountering the pymysql module not found error, it likely means that the pymysql Python library is not installed on the server. pymysql is a Python package that provides a way to interact with MySQL databases using Python code and is used ...