Views

Enterprise

Enterprise view is the starting point where you add, remove and arrange the items you would like to monitor, view some basic information about them, enable and disable items, view and configure alerts

What's on the Enterprise view?

Group.  A group item is a logical group of servers such as Production and Development, or Europe and US. A group shows the number of servers within a group and their states. All alert triggered for all servers within a group are shown next to the group icon. You can double-click on the group icon to open the group's overview and you can drag and drop servers to and from a group. You can also start/stop monitoring all servers withing a group by right-clicking on a group and selecting Start/Stop monitoring command. Groups can be nested withing other groups.


Oracle database.  Once an Oracle database is added an icon is placed on the Enterprise view showing some vital information about it including the caption, the database state, the number of active and waiting users, percentage of free space in data files, cpu and memory utilization if monitoring operating system option was selected and an alert icon if alerts were triggered for this database


Database states. An icon in the left upper corner shows the current instance and database state

Instance down
Shutdown pending
Instance up, database not mounted
Database mounted
Database open
Database open read-only

Oracle Real Application Clusters database.  An Oracle RAC item shows an Oracle RAC cluster as a single item on Enterprise view. All alerts triggered for any node in the cluster are displayed next to the Enterprise view item. Also green and red squares inside an Oracle RAC item show whether the nodes in the cluster are up or down respectively


Disabled items.  If you are not interested in watching an item on the Enterprise view you can disable it by right-clicking on it and choosing Stop Monitoring . Once an item is disabled statistics is not gathered for this item until it is reenabled again. A disabled item is shown in gray color.


An item may also become disabled if a connection to it cannot be established for a certain period of time. In this case the item stays disabled but is pinged at regular intervals until a connection is established again and reenabled automatically. Timeout and pinging interval parameters can be adjusted in Settings dialog.

Physical standby.  An Oracle physical standby icon is different in that it shows the sequence of the last redo log shipped from the primary database and the last that has been applied. Its database state icon shows that a physical standby is in the mounted state.


Link.  Two or more items on Enterprise view can be linked if they form a group or a relationship such as Oracle primary/standby databases. Insider recognizes these relationships automatically as you add items so you need not manually define them


OS host.  Operating system host icon shows the system type (the icon in the left upper corner) and some vital information about system load, including load average for UNIX systems and cpu and memory utilization if monitoring operating system option was selected and an alert icon if alerts were triggered for this operating system host.


Web server.  Once a Web server is added an icon is placed on the Enterprise view showing some vital information about it including the response time and cpu and memory utilization if monitoring operating system option was selected and an alert icon if alerts were triggered for this web server.


Alert notification.  When an alert is triggered for a database a pop-up alert notification is displayed for a couple of seconds to draw user's attention. Once the alert notification closes the alert can be viewed by clicking on alert icon next to an item


Alert list.  All alerts currently active for an item can be accessed by clicking on a small alert icon in the right upper corner of the item they are triggered for. Alerts are ordered by severity first, then by the time (most recent first). Click on the alert you are interested in to see detailed information about the alert. If you right-click on an alert in the alert list you access a pop-up menu where you can choose to disable or configure the alert


Alert history.  To view the log of alerts for an enterprise item right-click on the item and choose Alert History . It will bring an Alert History dialog where you can see the full history of alerts for this item ordered by time the alert was triggered


You can filter alert history by severity, alert type and time range and export the alerts to an HTML file

Adding and removing items

To add an Oracle database to Enterprise view right click anywhere inside the view and choose Add Oracle Database. This will bring up an Oracle database configuration window. Depending on what driver type you choose you will either have to fill in parameters using a tnsnames entry or fully specify an Oracle connection parameters

You can also choose to assign a meaningful name to your item such as "Sales db" (optional)

OCI driver. 

If you have Oracle client software installed on you workstation you can use Oracle OCI driver (default) to establish connections to you databases. Select a TNS name from a list of tnsnames entries or type in a tns name for your database, enter username, password and connection type. Refer to User Configuration section for Oracle account requirements

[Tip]Tip
If your tnsnames.ora file is not found (TNS names list is not populated) press Locate tnsnames button next to TNS names combo and navigate to your tnsnames file, then press OK

Thin driver. 

If you don't have Oracle client software installed on you workstation you can use Oracle thin driver to establish connections to you databases. Oracle thin driver requires no Oracle client software of you machine. Just type in the host name, listener port (1521 is the default for Oracle), service name or SID, enter username, password and connection type. Refer to User Configuration section for Oracle account requirements

Web server.  To add a Web (HTTP) server to Enterprise view right click anywhere inside the view and choose Add Web Server. This will bring up a Web server configuration window.

You can choose to assign a meaningful name to your server such as "Intranet" (optional)

Enter the URL to your web server

Operating system host.  To add a OS host to Enterprise view right click anywhere inside the view and choose Add host. This will bring up a OS host configuration window.

You can choose to assign a meaningful name to your server such as "File server" (optional). See below for operating system configuration dialog

Operating system monitoring. 

If you are monitoring an Oracle database or a web server it is a good idea to get some additional information from the operating system on the machine where your database or web server is running. You will be able to see such vital information as CPU busy, used/free memory, swapping/paging activity and run-queues.

In addition to that a connection to OS enables Insider to track Oracle alert log errors and estimate archive log destination space. Enter the host name, type of operating system you have (Windows and UNIX are supported) username and password. Refer to User Configuration section for user account requirements.

If you are connecting to a UNIX box over ssh you have to also provide port and choose whether you want to connect using the shell (default). If you are connecting to a Windows machine locally (i.e. where Insider itself is installed) leave username and password fields blank. If you are connecting to a Windows host on another domain prefix the username with the domain name e.g. ANOTHER_DOMAIN\myusername

Removing items.  You can remove items on Enterprise view by right-clicking on an item and choosing Delete . If you want to remove multiple items click on each item while holding Ctrl key and choose Delete Selected

Configuring alerts

Enabling/disabling alerts on Enterprise view.  If you are not interested in receiving particular alert for an item right-click on the alert in the alert list and choose Disable ... menu


You can also acknowledge a critical alert from the alert popup menu. See Acknowledging alerts for more details

Configure alert shortcut.  You can use a convenient shortcut on an Enterprise item that will take you directly to this alert configuration by right-clicking on the alert in the alert list and choosing Configure this alert menu

External tools

Extending Insider functionality.  You can easily extend Insider functionality by configuring external tools such as SQL*Plus, ssh or SQL Developer right on an Enterprise View item. Right-click any item and select Tools>Configure menu to add external tools.


You can use predefined variables to avoid having to type in parameters you already entered for an Enterprise item. For example, if you created an Oracle Database Enterprise View item you can configure tools like SQL*Plus to open and connect to your database using the same user name, password and connection string. Once you add an external tool you can access it right from an Enterprise item pop-up menu. Some items like SQL*Plus are preconfigured and more can be added using Configure Tools dialog

Configuring external tools.  To configure external tools right-click any Enterprise view item and select Tools>Configure. You can add, remove, copy and rearrange external tools in the list or change parameters for an external tool.


Parameters.  You can choose the name for the external tool to display on the context menu, its window caption, the command to start the tool, its working directory and icon. To access the full list of predefined variables position the cursor to where you would like to insert a predefined variable and press Ctrl-Space. For example to add SQL*Plus as an external tool choose SQL*Plus as the name and window title and enter:

sqlplus ${username}/${password}@${tnsname}
on the command line. If you just need to capture the output of the command select Run as is and Capture Output to have the output displayed on the enterprise view console

Predefined variables.  To avoid having to type the same information twice you can use predefined variables e.g. to specify connection parameters for an external tool. Whenever Insider encounters such a variable it substitutes it with the actual value.

[Note]Note
Sensitive information like the username and password are always stored in encrypted form
${USERNAME}Oracle user name
${PASSWORD}Password for the account used to connect to Oracle
${TNSNAME}TNSNames entry used to connect to Oracle
${SERVICENAME}Service name
${CONNECT-FORM}Connect form
${CONNECTION-TYPE}Connection type: normal, sysdba, sysoper
${DRIVER-TYPE}Driver type: thin or OCI
${URL}URL
${HOST}Host
${ALIAS}Enterprise item name
${PORT}Port
${SID}SID used to connect to Oracle
${ORACLE_HOME}Oracle Home
${OS_HOST}Operating system host
${OS_PORT}Operating system port
${OS_USERNAME}Operating system account
${OS_PASSWORD}Operating system account password

Switching between views

Enterprise view is always on. You cannot close it because it's the application main view. All other views can be opened and closed.


When you open another view a tab is added at the top of the window as shown on the picture. To switch to another view simply select its tab. To close a view click on X button on its tab

Console

Insider may need to report some important information back to you or display the output of an external tool. These are typically shown on Enterprise console. Enterprise console is displayed on Enterprise view whenever a new message arrives. You can safely close it once you have read the message


Status Bar

Some useful statistics about Insider can be found on the status bar at the bottom of the application window. These include Insider internal database size, number of pending requests to the items on Enterprise View, allocated and used memory


Ideally the number of pending requests should be zero. It means that all the requests Insider sends to the monitored servers are processed in a timely manner. In some cases however such as when the network is too slow or some of the servers are too busy requests begin to accumulate. If a server is not responding for a prolonged period Insider cannot adequately display this server and eventually an internal alert will be raised and the number of pending requests is shown in red. By default Insider automatically increases the refresh rate if the server appears too slow. You can turn off this feature on a Data Collection page of the Settings dialog.