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 [Errno 111] Connection refused error for Oracle plugins

      When installing Oracle database monitoring plugins, you may encounter the following error: DPY-6005: cannot connect to database. [Errno 111] Connection refused This error indicates that there is an error connecting to the Oracle database server. Here ...

    • 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 do I add the Dell iDRAC plugin for Windows?

      Prerequisites Install the latest version of the Net-SNMP package. Follow these steps to install and configure it. Install Python 3.6. Plugin Installation Create a folder named idrac. Download the files from our GitHub repository and place them in the ...

    • How to troubleshoot my Windows PowerShell Plugin?

      By default, the Site24x7 monitoring Windows agent will run as a SYSTEM user. In case, if you would like to verify if the plugin script is giving the output properly as SYSTEM user, follow these steps: Download PsExec from this link and extract the ...

    • Error 2503 during Windows server monitoring agent installation

      Issue Facing the error 2503 during the installation of the Windows server monitoring agent. Cause During installation, the installer package files have to be written to the "C:\Windows\Temp" folder. When Windows is unable to write these files to this ...