RTView DataServer for Oracle Quick Start Guide, Version 5.1.1 (On-Premise)

This document describes how to download and install the RTView DataServer for Oracle for use with Enterprise Monitor, how to configure the data server including defining the connection information for the Solution Package for Oracle, how to add alert and historian database connections, how to add connections to Enterprise Monitor, and how to verify that your setup is working properly in Enterprise Monitor.

Note: This flow assumes that you have already downloaded, installed, and have RTView Central Servers (Enterprise Monitor) up and running. See the RTView Enterprise Monitor Configuration Guide for more information.

Note: If you are interested in setting up High Availability (failover) for your DataServer, review Configuring High Availability for DataServer Deliverables prior to starting this flow.

Note: In addition to using the RTView Configuration Application for configuring your connections, you can use the Property Editor REST API to import initial connections or automate connection updates. See Property Editor REST API for more information.

Before You Get Started

  • You must have Java installed and you should know the installation directory path.
  • You should know the correct full path to the directory containing the jar files for each of your solution packages.
  • You should know the connection settings for your solution packages:

Oracle Coherence connections: The configuration required to use this solution package cannot be set up via the RTView Configuration Application. See the rtvapm/ocmon/conf/sample.properties file for information on configuring this solution package.

Oracle Database connections: Connection Name, Connection Type (RAC/Standard/XE), URL for the connection type, and username/password (if defined).

Connector for Oracle Enterprise Manager connections: The configuration required to use this solution package cannot be set up via the RTView Configuration Application. See the rtvapm/oemcon/conf/sample.properties file for information on configuring this solution package.

Oracle WebLogic connections: Connection Name, URL/path to the JMX connection of the WebLogic Server to which you want to connect, username/password used to connect (if defined), java.class.path (path to the wlfullclient.jar and webserviceclient.jar files, java.remote.provider.protocol.pkgs key, java.naming.security.principal (JMX username), java.naming.security.credentials (JMX password), and the name and value of any additional properties you would like to monitor for your WebLogic Servers.

  • If you are upgrading to a new version of the DataServer, review the General Upgrade Steps document to see if there are any additional steps required.

Downloading the RTView DataServer for Oracle

  • Open a browser and navigate to https://sl.flexnetoperations.com.

  • Login using your RTView Download Center account login/password.

If you do not have an RTView Download Center account, contact sl@flexnetoperations.com about helping you to create an account.

The RTView Download Center page displays.

  • Click the SL Corporation link in the Browse My Software and Documentation region.

The list of available Product Lines displays.

  • Click RTView DataServer for Oracle.

The Product Information page displays.

  • Click RTView DataServer for Oracle.

The Product Download page displays.

  • Click the RTViewDataServerOracle_<version>.zip file or, if you want to download multiple files, select the check box next to the different deliverables and click the Download Selected Files button.

The compressed file(s) is/are saved to your machine.

Registration

When you install the DataServer, a temporary license key is included. SL Corporation will send you a permanent key that you will need to add to your RTView license key file so that you can extend the operation of your monitoring system.

This is a universal key that will enable you to run RTView on different machines and platforms. It is your responsibility to ensure you use RTView within the terms of your End User License Agreement (EULA).

To update your RTView system with your new license key, open a command window and:

  • Navigate to RTViewDataServerOracle/rtvapm/rtview/lib.
  • Edit the KEYS file using a text editor.
  • Copy/paste the new replacement key to the file.
  • Save the KEYS file.

Installing and Starting the RTView DataServer for Oracle

Note: If using UNIX, do not include spaces in your installation directory path. The start_server.sh and stop_server.sh scripts will not function properly if spaces are included in the installation directory path.

  • Extract All (Windows)/unzip (UNIX/Linux) the file to the directory of your choice. For UNIX/Linux, use unzip -a to unzip the file.

  • Open a command window and set the JAVA_HOME environment variable to point to your Java Installation. For example:

export JAVA_HOME=/opt/Java/jdk1.7.0 (UNIX/Linux)

set JAVA_HOME=C:\Program Files (x86)\Java\jre1.8.0_201 (Windows)

Or, in Windows, you can set JAVA_HOME as an environment variable (in Control Panel > System > Advanced system settings), where it will then be used by all command windows and when you double-click on a .bat file.

  • In the command window, navigate to the RTViewDataServerOracle directory and type:

start_server.bat (Windows)

./start_server.sh (UNIX/Linux)

Or, in Windows, you can double-click on the start_server.bat file.

Note: This script starts the Data Server on port 3278 with HTML Server (Eclipse Jetty, by default) on port 3270. If these ports conflict with other processes running on your system, you can change the first two digits of the ports by using -portprefix: and specifying the first two digits you want to use for the ports in the command line. For example: start_server.bat -portprefix:44 (which would change the ports to 4478 for the Data Server and 4470 for HTML Server). If you want to save your port prefix, you can change the port prefix in the RTView Configuration Application (see the next section), or you can use -saveportprefix: command line argument (for example: start_server.bat -portprefix:44 -saveportprefix).

Configuring the Data Server

Next, you need to create your connections for each of your solution packages using the RTView Configuration Application.

  • Open a browser and type:

http://localhost:3270/rtvadmin (for a local installation using Eclipse Jetty)

http://<IP address>:3270/rtvadmin (for a remote installation using Eclipse Jetty)

Note: If you specified a different port at startup (due to a port conflict), you must use the port you specified in the command line. For example, if you specified 44 as your port prefix in the command line at startup, then you would use:

http(s)://<IP address>:4470/rtvadmin

The Authentication required dialog displays.

  • Log in using rtvadmin/rtvadmin as the username/password.

The RTView Configuration Application displays.

  • Click RTView DataServer for Oracle.

The RTView Configuration Application displays with the General tab open.

  • As previously mentioned, if you modified the port at startup, you should modify the port prefix so that you do not need to specify the port on the command line every time you run the startup script. To do so, navigate to Server Configuration > General > General Tab > Ports > Port Prefix and define a new port prefix. If you change the Port Prefix to 44 then, after saving your changes and restarting your data server, you would access the RTView Configuration Application for the RTView DataServer for Oracle using the following URL: http(s)://localhost:4470/rtvadmin (instead of the default http(s)://localhost:3270/rtvadmin URL)
  • Under Solution Package Configuration, select the desired solution package you want to configure and click the link below to view the steps required to set up the configuration for the solution package using the RTView Configuration Application:

Data Cache: No configuration necessary.

Oracle Coherence: Configuration cannot be set up via the RTView Configuration Application. See the rtvapm/ocmon/conf/sample.properties file for information on configuring this solution package.

Oracle Database

Oracle Enterprise Manager: Configuration cannot be set up via the RTView Configuration Application. See the rtvapm/oemcon/conf/sample.properties file for information on configuring this solution package.

Oracle WebLogic

  • Optionally, you can create a Historian Database Connection and configure the historian settings. See the link below for more information:

Configuring the Historian Database (Optional)

Configuring Alerts 

Connecting Your Data Server to Enterprise Monitor

Next, you need to connect your data server to Enterprise Monitor. To do so:

  • Click Server Configuration > EM Integration.

The EM INTEGRATION tab displays.

  • Click the Integrate with Enterprise Monitor toggle.

Note: This field can be enabled by default by setting the RTVDS_INTEGRATEENABLED environment variable to 1 (for example: RTVDS_INTEGRATEENABLED=1).

The Central Server URL field and associated Announce this RTView Data Server to  the Central Server toggle display.

  • Specify the Central Server URL to be used to connect to your RTView Central Server. By default, a local connection is defined (localhost:10018) and does not need to be modified if your Central Server and Data Server are on the same machine. If they are on different machines, enter the URL containing the IP address and the port like so:

http://<IP address>:10070/rtview-central-rtvdata

Note: You can specify a different default for the Central Server URL field by specifying the RTVDS_CENTRALURL environment variable (for example: RTVDS_CENTRALURL=http://localhost:10070/rtview-central-rtvdata).

  • Click the Announce this RTView Data Server to  the Central Server toggle to automatically connect the data server to RTView Central.

Note: This field can be enabled by default by setting the RTVDS_ANNUNCIATEENABLED environment variable to 1 (for example: RTVDS_ANNUNCIATEENABLED=1).

The following fields display:

RTView Data Server Name: Define the name of the data server that you want to display in Enterprise Monitor. Modifying the default name in this field is optional. However, for our example, enter Oracle_Data_Server so that we can verify our change in our verification section later in this document. This field can be defined by default by defining the RTVDS_NAME environment variable (for example: RTVDS_NAME=ORCLMON_LOCAL). Note: You can only enter alphanumeric characters, underbars, and dashes in the data server name.

RTView Data Server URL: The URL that the Central Server should use for connecting to this RTView Data Server. The default depends on the HTML Server Enabled option on the Data Server tab. If the HTML Server Enabled option is selected, the default is http://hostname:3270/rtvdata. If disabled, the default is hostname:3278 where 32 is the Port Prefix for this project and hostname is the RTView Server Host. This field can be defined by default by defining the RTVDS_URL environment variable (for example: RTVDS_URL=http://myhost:3270/rtvdata).

RTView Query URL: The URL that HTML clients should use to query this RTView Data Server. The default depends on the HTML Server Enabled option on the Data Server tab. If the HTML Server Enabled option is selected, the default is http://hostname:3270/rtvquery where 32 is the Port Prefix for this project and hostname is the RTView Server Host. If HTML Server Enabled is disabled, this field is blank. This field can be defined by default by defining the RTVDS_QUERYURL environment variable (for example: RTVDS_QUERYURL=http://myhost:3270/rtvquery).

RTView Data Server Host: The Host name or IP address that the Central Server and html clients should use for connecting to this RTView Data Server. If not specified, the IP address for the host is used. This field can be defined by default by defining the RTVDS_HOST environment variable (for example: RTVDS_HOST=localhost).

CITypes to Exclude: The CI Types, if any, that you want to exclude from the Service Model in the Central Server. If not specified, all CI Types for the configured solution packages are included in the Service Model. To select the CI Types you want to exclude, click the associated  button to display the CI Types to Exclude dialog, select the desired CI Types, and click OKThis field can be defined by default by defining the RTVDS_CITYPESTOEXCLUDE environment variable (for example: RTVDS_CITYPESTOEXCLUDE=OC-CACHE,OC-CLUSTER).

Saving Your Changes and Restarting the Data Server

  • Once you have created all of your connections, click the SAVE button in the RTView Configuration Application.

  • For your changes to go into effect, you must stop and restart the data server by either:
    • clicking the  button (in the upper right-hand corner of the window)...
    • or by typing the following in your installation directory in the command window:

stop_server.bat (Windows)

./stop_server.sh (UNIX/Linux)

start_server.bat (Windows)

./start_server.sh (UNIX/Linux)

Verifying Your Setup

To verify your setup:

  • Open a browser, access the RTView Configuration Application for RTView Central Servers (Enterprise Monitor) using http://localhost:10070/rtview-central-rtvadmin, and log in using rtvadmin/rtvadmin as the username/password.

Your data server (Oracle_Data_Server, for our example) displays in the list below RTView Central Servers. You can edit your data server connections/configurations in the RTView Configuration Application for  RTView Central (http://localhost:10070/rtview-central-rtvadmin) or in the RTView Configuration Application for the RTView DataServer for Oracle deliverable (http://localhost:3270/rtvadmin).

  • Open a browser, access Enterprise Monitor (for example, http://localhost:10070/rtview-central-classic), and log in using admin/admin as the username/password.
  • Click Admin > Architecture System Overview and check to make sure that your newly connected data server (Oracle_Data_Server in our example) displays in the Data Servers region and that CI Metrics are being collected.

  • You can also check the incoming data in your caches by opening a browser and accessing the following URL:

http(s)://localhost:3270/common (for a local installation using Eclipse Jetty)

http(s)://<IP address>:3270/common (for a remote installation using Eclipse Jetty)

The RTView Cache Viewer application displays, which allows you to view the details for the caches that are collecting data.