IDERA

Oracle Advanced Tablespace Check

 GitHub: uptimesoftware/oracle-advanced-tablespace-check
Tags : database oracle
Category: plugin

Version Compatibility
Module Name
Uptime Monitoring Station Version
Oracle Advanced Tablespace Check 4.17.8, 7.7, 7.6, 7.5, 7.4, 7.3, 7.2
Oracle Advanced Tablespace Check 3.07.1, 7.0
Oracle Advanced Tablespace Check 2.06.0
Download Files

Oracle Advanced Tablespace Check 4.1

Oracle Advanced Tablespace Check 3.0

Oracle Advanced Tablespace Check 2.0

Information Table
Description: Allows for better monitoring of Oracle tablespaces.
Supported Monitoring Stations:7.8, 7.7, 7.6, 7.5, 7.4, 7.3, 7.2, 7.1
Supported Agents:None; no agent required
Installation Notes:

see below

Dependencies:

see below

Input Variables:
  • ODBC Driver - This can either be the path to the driver itself or the name of the ODBC driver.
  • Oracle DB Port
  • Oracle Username
  • Oracle User Password
Output Variables:
  • Available Space (KB)
  • Used Space (KB)
  • Free Space (KB)
  • Percent Free (pct)
Languages Used:
  • PHP

Notes:

###For Uptime 7.3:

This plugin has been replaced by the Oracle Extendable Tablespace Check. It provides the same general functionality but without the dependency on ODBC drivers. Please use that version instead going forth.

###Oracle Instant Client ODBC Driver Installation Steps

This plugin relies on Oracle’s Instant Client & ODBC drivers. As such you will need to install these drivers on your monitoring station. Below are steps for installing these drivers on both Windows & Linux based monitoring stations.

####Windows:

  1. Install the Oracle Instant Client drivers or have the Oracle Client installed on the monitoring station. To get the Instant Client Download for Oracle, download the 64 bit drive:

    http://www.oracle.com/technetwork/database/features/instant-client/index.html

    ie. instantclient-basic-windows.x64-12.1.0.1.0.zip

  2. Create a new directory C:\Oracle. Unzip the downloaded file into the new directory. You should now have C:\Oracle\instantclient_12_1 which contains a bunch of .dll & .sym files.

  3. Download the ‘Instant Client Package - ODBC’ from the same page above. ie. instantclient-odbc-windows.x64-12.1.0.1.0.zip . Extract this zip into the same C:\Oracle\instantclient_12_1 path.

  4. Open a command prompt in the C:\Oracle\instantclient_12_1 directory and run the odbc_install.exe which will install the Oracle ODBC drivers and setup the required Environment variables.

  5. Run the ‘Data Sources (ODBC)’ utility from the Windows ‘Administrative Tools’. Click on the ‘Drivers’ tab, and confirm that you have an ‘Oracle in instantclient’ driver listed, and note the name of the driver, as this is required as the ‘ODBC Driver Name’ when setting up the service monitor. (Likely it will be ‘Oracle in instantclient_12_1’ or ‘Oracle in OraClient12Home1’).

  6. Update the Path Environment Variable to include the path to the oracle driver. Append “;C:\Oracle\instantclient_12_1” to end of the variable. To set this variable Go to System Properties > Advanced > Environment Variables > Under System variables find Path and edit it.

  7. Install the plugin and setup your monitors. Remember to change the ‘ODBC Driver Name’ value in the service monitor config to match the name of the driver as it shows up in the Data Sources (ODBC) utility. The curly Braces { } are important here.

On Windows,the Oracle ODBC Drivers may also require the Microsoft Visual C++ 2010 SP1 Redistributable Package (x64)

If your having trouble with installing just the Oracle InstantClient & ODBC , another option is to install these drivers as part of the ‘Oracle Data Access Components’ which is a bundle of Oracle drivers full fleged installer compared to the zips mentioned above. This bundle can be found on the Oracle website here: http://www.oracle.com/technetwork/database/windows/downloads/index.html

####Linux:

(These steps refer to the .rpm versions of the various Oracle drivers, but they also provide .zip versions that can be installed on SUSE)

  1. Install unixODBC via your package manager (ie. yum install unixodbc) . This will install unixODBC into your ‘/usr/lib64/’ directory.

  2. Download and Install the latest version of the ‘Oracle Instant Client Basic’ package, available from Oracle here( http://www.oracle.com/technetwork/database/features/instant-client/index.html). Keep in mind that Uptime 7.2 comes bundled with 64bit Apache/PHP so you will need the Linux x86-64 package. ie. oracle-instantclient12.1-basic-12.1.0.1.0-1.x86_64.rpm . (The 12.1 package works with 11g Databases as well). This package will install some of the required binaries/drivers for Oracle into /usr/lib/oracle//client64/lib/

  3. Download and install the ‘ ODBC: Additional libraries’ package from Oracle (ie. oracle-instantclient12.1-odbc-12.1.0.1.0-1.x86_64.rpm ). This provides the actual libsqora.so ODBC Driver we need from Oracle.

  4. Go into the directory where the Oracle ODBC drivers were installed and note the path for libsqora.so. (Likely it will be /usr/lib/oracle/12.1/client64/lib/libsqora.so.12.1 if you installed the 12_1 version of the instant client). This is required when setting up the service monitor.

  5. Edit the oracle_tablespace_check.sh script that should be located in the /scripts/MonitorOracleTablespaceCheck/ directory and confirm that the LD_LIBRARY_PATH environment variable matches the location where the Oracle Drivers were installed in step #2 above. dependencies: Oracle InstantClient & ODBC Drivers see readme for install steps

October 7, 2013 |

Comments

comments powered by Disqus
Copyright © 2015 IDERA, Inc.   Legal   Privacy Statement