Skip Headers
Oracle® Enterprise Manager System Monitoring Plug-in for Oracle TimesTen In-Memory Database User's Guide
Release 12.1.0.2.0

E28645-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

1 Installing the System Monitoring Plug-in for TimesTen

The System Monitoring Plug-In for Oracle TimesTen In-Memory Database extends Oracle Enterprise Manager Cloud Control to add support for monitoring TimesTen databases.

This chapter focuses on the installation of the TimesTen plug-in.

Topics include:

Note:

The instructions and screenshots of this user's guide are based on Oracle Enterprise Manager Cloud Control 12c Release 3.

Installation prerequisites

Before installing the System Monitoring Plug-In for TimesTen:

  • Install Oracle Enterprise Manager Cloud Control 12c Release 2 (or higher) for OMS, Enterprise Manager Repository, and Agent. Make sure the agent can successfully communicate with your Oracle Enterprise Manager Server and can upload data.

  • Install Oracle TimesTen In-Memory Database Release 11.2.1.8 (or later) or 11.2.2.1 (or later).

Note:

The Oracle Enterprise Manager Cloud Control Agent and the TimesTen database must reside on the same machine.

When you configure your TimesTen target, you need to know:

  • The name of your TimesTen instance

  • The DSN. The DSN must be a system DSN that is described in either your sys.odbc.ini file or the ODBC Data Source Administrator on MS Windows.

  • The TimesTen database username and password

    • The username and password are required when you configure the TimesTen target.

    • The user you specify when you configure the TimesTen target must have ADMIN privileges. The user cannot be the instance administrator.

Note:

Be sure the TimesTen database specified by the instance and DSN is loaded.

For information on your TimesTen instance, run the ttStatus or ttVersion utility.

Additional requirements

Additional requirements or considerations include:

  • Use direct linked connections to define your target DSN. Client/Server connections are not supported for your target DSN.

  • The System Monitoring Plug-in for TimesTen generates temporary files. Each temporary file could require between 10 KB to 30 KB of free space on the Oracle Enterprise Manager Agent file system. If the Oracle Enterprise Manager Agent file system is full, the Oracle Enterprise Manager Agent can no longer monitor the TimesTen database. For information about the system requirements for the Oracle Enterprise Manager Agent, see "CPU, RAM, and Hard Disk Space Requirements for Management Agents" in the Oracle Enterprise Manager Cloud Control Basic Installation Guide.

  • The Operating System User who installs the Oracle Enterprise Manager Agent must belong to the TimesTen users group of the installation being monitored. Also, make sure the user has read access to /etc/TimesTen/instance_info. For more information about the TimesTen users group, see "Create the TimesTen users group" in the Oracle TimesTen In-Memory Database Installation Guide.

  • For optimal performance, make sure TimesTen is on a different machine than the Oracle Enterprise Management Service (OMS) and the Enterprise Manager Repository.

  • Make sure the My Oracle Support credentials are set up using the SYSMAN user. This is required to enable updates (plug-ins) to be downloaded from the My Oracle Support site. For more information, see "Saving Preferred Credentials to Access My Oracle Support" in the Oracle Enterprise Manager Lifecycle Management Administrator's Guide.

  • Make sure the Software Library (also known as the local store) is configured. Updates are downloaded to this local store before being deployed into Oracle Enterprise Manager Cloud Control. For more information, see "Configuring an OMS Shared Filesystem Location" in the Oracle Enterprise Manager Cloud Control Administrator's Guide.

Installing the System Monitoring Plug-in for TimesTen

To install the TimesTen plug-in for TimesTen, you must:

Download the plug-in

To download the plug-in, make sure you are on the Oracle Enterprise Manager Cloud Control home page and are logged in as user SYSMAN.

  1. From the Setup menu, select Extensibility, then select Self Update.

    Figure 1-1 Select Self Update

    Description of Figure 1-1 follows
    Description of "Figure 1-1 Select Self Update"

    The Self Update page displays.

  2. Click Check Updates.

    Figure 1-2 Click Check Updates

    Description of Figure 1-2 follows
    Description of "Figure 1-2 Click Check Updates"

    The Confirmation dialog displays. You should see the informational message: "A job has been submitted successfully to check for new updates from Oracle".

  3. Click OK.

    Figure 1-3 Checking for updates

    Description of Figure 1-3 follows
    Description of "Figure 1-3 Checking for updates"

    The Self Update page displays with a Most Recent Refresh Time status indicating the status of the updates.

    • If you see a green check mark next to the Most Recent Refresh Time status, then Enterprise Manager has finished checking for updates. Locate the Plug-in folder.

    • If you see a status of Submitted or In Progress... for the Most Recent Refresh Time status, then Enterprise Manger is still checking for updates. Click the refresh button located in the top right of the Oracle Enterprise Manager Cloud Control page to refresh the status of the Most Recent Refresh Time. After you see a green check mark next to the Most Recent Refresh Time status, locate the Plug-in folder.

  4. Click on the name Plug-in.

    Figure 1-4 Plug-in folder

    Description of Figure 1-4 follows
    Description of "Figure 1-4 Plug-in folder"

    The Plug-in Updates page displays. In the Plug-in Name column, locate Oracle TimesTen In-Memory Database. Confirm the Status column is equal to Available.

  5. In the Plug-in Name column, click Oracle TimesTen In-Memory Database.

    Figure 1-5 Plug-in Updates

    Description of Figure 1-5 follows
    Description of "Figure 1-5 Plug-in Updates"

    Locate the Download button located under Plug-in Updates at the top of the page.

  6. Click Download.

    Figure 1-6 Download plug-in

    Description of Figure 1-6 follows
    Description of "Figure 1-6 Download plug-in"

    The Schedule Download dialog displays indicating that you can download the plug-in either immediately or later. When you choose Select, Enterprise Manager downloads the plug-in immediately.

  7. Click Select.

    Figure 1-7 Schedule Download dialog

    Description of Figure 1-7 follows
    Description of "Figure 1-7 Schedule Download dialog"

    A confirmation dialog displays indicating that the update (plug-in) is downloading.

  8. Click OK.

    You have successfully downloaded the plug-in. You can verify the plug-in has been downloaded by reviewing the Plug-in Updates page. You should see the Oracle TimesTen In-Memory Database plug-in with a status of Downloaded

    You are now ready to deploy the plug-in on the Oracle Management Server.

Deploy the plug-in on OMS

You must deploy the plug-in on both the Oracle Management Server (OMS) and one or more Management Agents. After you successfully deploy the plug-in, both OMS and the agent know the plug-in exists. You then configure your TimesTen database as one of the targets for the agent and the agent begins the process of monitoring your target.

You must deploy the plug-in on OMS before deploying the plug-in on one or more Management Agents.

Note:

If there is a failure when deploying the plug-in, the Management Repository could be in an inconsistent state. It is recommended that you back up the Management Repository before deploying the plug-in.

To deploy the plug-in on OMS, make sure you are on the Oracle Enterprise Manager Cloud Control home page and are logged in as user SYSMAN.

  1. From the Setup menu, select Extensibility, then select Plug-ins.

    Figure 1-9 Choose Extensibility, then Plug-ins

    Description of Figure 1-9 follows
    Description of "Figure 1-9 Choose Extensibility, then Plug-ins"

    The Plug-ins page displays and you see the plug-ins that have been downloaded and can be deployed. Locate the Databases folder in the Name column.

  2. Expand the Databases folder in the Name column and click Oracle TimesTen In-Memory Database.

    Figure 1-10 Choose TimesTen In-Memory Database plug-in

    Description of Figure 1-10 follows
    Description of "Figure 1-10 Choose TimesTen In-Memory Database plug-in"

    You are now ready to deploy the plug-in on OMS. Locate the Deploy On tab at the top of the page.

  3. From the Deploy On menu, select Management Servers....

    Figure 1-11 Deploy on OMS

    Description of Figure 1-11 follows
    Description of "Figure 1-11 Deploy on OMS"

    The Deploy Plug-in on Management Servers General page displays. The plug-in Oracle TimesTen In-Memory Database is displayed in the Name column and the Version is auto-filled. Prepare to enter the Repository SYS user password.

  4. In the *Repository SYS Password field, enter the Repository SYS user password.

    Figure 1-12 Repository SYS Password

    Description of Figure 1-12 follows
    Description of "Figure 1-12 Repository SYS Password"

    Locate the Continue button in the bottom right of the page.

  5. Click Continue.

    Figure 1-13 Click Continue

    Description of Figure 1-13 follows
    Description of "Figure 1-13 Click Continue"

    The Deploy Plug-in on Management Servers Prerequisite Checks page displays. You should see a check to the left of the Prerequisite Checks column. To the right of this column, you should see the text "Successfully Completed." In the Management Servers table, all rows should have a check in the Status column. Make sure all these conditions are met.

  6. Click Next.

    Figure 1-14 Prerequisite checks successful

    Description of Figure 1-14 follows
    Description of "Figure 1-14 Prerequisite checks successful"

    The Deploy Plug-in on Management Servers Review page displays. In the name column, verify the plug-in name is Oracle TimesTen In-Memory Database. Verify the version is correct.

    You are ready to deploy the plug-in.

  7. Click Deploy.

    Figure 1-15 Review of the deploy on OMS

    Description of Figure 1-15 follows
    Description of "Figure 1-15 Review of the deploy on OMS"

    The Deploy Plug-in on Management Servers Confirmation page displays with a message indicating the deployment of the plug-in is in progress. The deployment can take several minutes. You may monitor the deployment status by clicking Show Status or going to the Recent Deployment Activities page.

  8. Click Show Status.

    Figure 1-16 Confirmation of the deployment to OMS

    Description of Figure 1-16 follows
    Description of "Figure 1-16 Confirmation of the deployment to OMS"

    The Plug-ins Deployment Activities page displays showing the status of the deployment steps in table format. The last step located in the last row of the table is named "Update inventory." Once this step is completed, make sure there are green checks in the Status column of each row in the Deployment Steps table. Such checks indicate all steps in the deployment process are completed and are successful. Also, make sure there is a green check in the Status column in the deployment table located at the top of the page. If auto refresh is set to off, you may want to set autorefresh to 15 seconds, so you can see the steps as they are completed.

    Figure 1-17 Deployment to OMS successful

    Description of Figure 1-17 follows
    Description of "Figure 1-17 Deployment to OMS successful"

    The plug-in is deployed on OMS.

You are now ready to deploy the plug-in on the Management Agent.

Deploy the plug-In on the Management Agent

You must deploy the plug-in on OMS before deploying the plug-in on one or more Management Agents.

Note:

The TimesTen database, the plug-in, and the agent monitoring the database must be on the same machine.

To deploy the plug-in on the Management Agent, make sure you are on the Oracle Enterprise Manager Cloud Control home page.

  1. From the Setup menu, select Extensibility, then select Plug-ins.

    Figure 1-18 Choose Extensibility, then Plug-ins

    Description of Figure 1-18 follows
    Description of "Figure 1-18 Choose Extensibility, then Plug-ins"

    The Plug-ins page displays and you see the plug-ins that have been downloaded and can be deployed. Locate the Databases folder in the Name column.

  2. Expand the Databases folder in the Name column and click Oracle TimesTen In-Memory Database.

    Figure 1-19 Choose Oracle TimesTen In-Memory Database plug-in

    Description of Figure 1-19 follows
    Description of "Figure 1-19 Choose Oracle TimesTen In-Memory Database plug-in"

    You are now ready to deploy the plug-in on the Agent. Locate the Deploy On tab at the top of the page.

  3. From the Deploy On menu, select Management Agent....

    Figure 1-20 Deploy on Management Agent

    Description of Figure 1-20 follows
    Description of "Figure 1-20 Deploy on Management Agent"

    The Deploy Plug-in on Management Agent General page displays. The plug-in Oracle TimesTen In-Memory Database 11g is displayed in the Name column and the Version is auto-filled. Locate the Continue button below the Target Types table.

  4. Click Continue.

    Figure 1-21 Click Continue

    Description of Figure 1-21 follows
    Description of "Figure 1-21 Click Continue"

    You can now choose the agent where you wish to deploy the plug-in. Note that the agent status must be up as indicated by the green up arrow in the Status column of the Management Agents table.

  5. In the Management Agents table, locate the row that contains the correct agent as identified by management agent. Click in this row and then click Continue.

    Figure 1-22 Choose agent and click Continue

    Description of Figure 1-22 follows
    Description of "Figure 1-22 Choose agent and click Continue"

    The Deploy Plug-in on Management Agent Prerequisite Checks page displays. In the Management Agent table, verify the Status column has a green check and the Error Message column contains the text "No Error."

  6. Click Next.

    Figure 1-23 Prerequisite checks

    Description of Figure 1-23 follows
    Description of "Figure 1-23 Prerequisite checks"

    The Deploy Plug-in on Management Agent Review page displays. In the name column, verify the plug-in name is Oracle TimesTen In-Memory Database and the version is correct. Make sure that you see the text "Management Agents that passed the prerequisite checks" and make sure the Management Agent is correct.

    You are ready to deploy the plug-in.

  7. Click Deploy.

    The Deploy Plug-in on Management Agent Confirmation page displays with a message indicating the deployment of the plug-in has started on selected agents. The deployment can take several minutes. You may monitor the deployment status by clicking Show Status or going to the Recent Deployment Activities page.

  8. Click Show Status.

    Figure 1-25 Confirmation dialog

    Description of Figure 1-25 follows
    Description of "Figure 1-25 Confirmation dialog"

    The Plug-ins Deployment Activities page displays showing the status of the deployment steps in table format. The last step located in the last row of the table is named "Update inventory." Once this step is completed, make sure there are green checks in the Status column of each row in the Deployment Steps table. Such checks indicate all steps in the deployment process are completed and are successful. Also, make sure there is a green check in the Status column in the Deployment table located at the top of the page. If auto refresh is set to off, you may want to set autorefresh to 15 seconds, so you can see the steps as they are completed.

    Figure 1-26 Deployment of agent successful

    Description of Figure 1-26 follows
    Description of "Figure 1-26 Deployment of agent successful"

    The plug-in is deployed on the Management Agent. Repeat Steps 1-9 to deploy the plug-in on additional Management Agents.

You are now ready to create a TimesTen target.

Configure a TimesTen target

You must configure a TimesTen target that is monitored by Enterprise Manager Cloud Control. You can configure a TimesTen target for each unique DSN. When you configure your TimesTen target, use a Data Manager DSN. Client/server DSNs are not supported.

  1. From the Setup menu, select Add Target, then select Add Targets Manually.

    Figure 1-27 Add target manually

    Description of Figure 1-27 follows
    Description of "Figure 1-27 Add target manually"

    The Add Targets Manually page displays. Locate Add Targets Manually in the middle left section of the page.

  2. Click in the circle to the left of the text Add Targets Declaratively by Specifying Target Monitoring Properties.

    Figure 1-28 Add Non-Host Targets

    Description of Figure 1-28 follows
    Description of "Figure 1-28 Add Non-Host Targets "

    The Target Type select list displays. You are now ready to select TimesTen In-Memory Database 11g.

  3. Expand the drop-down list labeled Target Type and select TimesTen In Memory Database 11g.

    Figure 1-29 Choose target type

    Description of Figure 1-29 follows
    Description of "Figure 1-29 Choose target type"

    You are now ready to search for the Monitoring Agent. Locate the Monitoring Agent search box below the Target Type select list.

  4. Click the Search icon located to the right of Monitoring Agent.

    The Search and Select Targets - Oracle Enterprise Manager page displays. You are now ready to choose the monitoring agent for your TimesTen target. Locate the Targets table with columns Target Name, Target Type, and On Host. Identify the Target Name of your agent. Make sure the Target Type is Agent and double check the On Host column to make sure the host name is correct.

  5. Click in the row that identifies the Target Name of your agent and click Select.

    Figure 1-30 Select Management Agent

    Description of Figure 1-30 follows
    Description of "Figure 1-30 Select Management Agent"

    The Search and Select Targets - Oracle Enterprise Manager page closes and you are returned back to the Add Targets Manually page. Notice the agent you selected is auto-filled in the Monitoring Agent text field. Double check the Target Type is TimesTen In Memory Database 11g and the agent is correct.

    You are now ready to add the target.

  6. Click Add Manually...

    Figure 1-31 Click Add Manually

    Description of Figure 1-31 follows
    Description of "Figure 1-31 Click Add Manually"

    The Add TimesTen In Memory Database 11g page displays. Prepare to enter the target properties for your target. The first property is the target name.

    In the Target Name text field, you define the TimesTen target name. Choose a name that is a meaningful identifier. (For example, hostname.instance.DSN).

  7. In the Target Name text field, type the TimesTen target name.

    Notice the Target Type, Agent, and Credential Type text fields, located below the Target Name text field, are auto-filled. You are now ready to enter the TimesTen monitoring credentials properties.

  8. In the *TimesTen database user name text field, type the TimesTen database user who has ADMIN privileges. Note: This user cannot be the TimesTen instance administrator.

  9. In the *TimesTen password text field, type the password for the TimesTen database user who has ADMIN privileges. Note: This user cannot be the TimesTen instance administrator.

  10. In the *Confirm TimesTen password text field, re-type the password. You are now ready to enter the TimesTen properties.

  11. In the *Data Source Name text field, type the DSN. The DSN must be a system DSN that is described in either your sys.odbc.ini file or the ODBC Data Source Administrator on MS Windows.

  12. In the *TimesTen instance name text field, type the name of your TimesTen instance. (Use the ttStatus utility if you cannot recall the instance name).

    Figure 1-32 Add TimesTen specific information

    Description of Figure 1-32 follows
    Description of "Figure 1-32 Add TimesTen specific information "

    You are now ready to test your connection to make sure that your target is deployed successfully and configured properly.

  13. Click Test Connection.

    The Confirmation dialog displays. You should see the informational message: "Test Connection succeeded." If you do not see the "Test Connection succeeded" message, make sure your instance name and DSN are correct and the TimesTen database for the DSN is loaded into memory.

  14. In the Test Connection dialog, click Close.

    Figure 1-33 Test Connection successful

    Description of Figure 1-33 follows
    Description of "Figure 1-33 Test Connection successful"

    The Confirmation dialog closes. Locate the OK tab at the top right of the page.

  15. Click OK.

    A second Confirmation dialog displays. You should see the informational message "Add Target - Completed Successfully." The target type (TimesTen In Memory Database 11g), Target name, and Agent are also displayed.

  16. Click Close.

    Figure 1-34 Target added successfully

    Description of Figure 1-34 follows
    Description of "Figure 1-34 Target added successfully"

    Your target has been successfully added.

You can now verify and view information about your new target.

Verifying and validating the plug-in

After waiting a few minutes for the plug-in to start collecting data:

  1. From the Targets menu, select All Targets on the Enterprise Manager Cloud Control 12c home page.

    The All Targets page displays. Locate the Refine Search panel under All Targets.

  2. Expand Target Type, then Databases and click TimesTen In Memory Database 11g.

    Figure 1-35 Choose TimesTen In Memory Database 11g

    Description of Figure 1-35 follows
    Description of "Figure 1-35 Choose TimesTen In Memory Database 11g"

    The target table displays. For each row in the table, confirm the column Target Type contains TimesTen In Memory Database 11g and each row of the table contains the name of the target you previously configured. For more information on configuring a TimesTen target, see "Configure a TimesTen target".

    For each target type row, locate the column Target Status. Verify there is a green up arrow indicating the status is Up.

    Figure 1-36 Verify the TimesTen target is Up.

    Description of Figure 1-36 follows
    Description of "Figure 1-36 Verify the TimesTen target is Up."

    You are now ready to verify there are no metric errors.

  3. In the target table, locate the row that contains your TimesTen target. In the column Target Name, click the Target Name. (The target name is the name of the TimesTen target you configured).

    Figure 1-37 Click the target name

    Description of Figure 1-37 follows
    Description of "Figure 1-37 Click the target name"

    The TimesTen target page displays.

  4. From the TimesTen IMDB menu, select Monitoring, then select Metric Collection Errors.

    Figure 1-38 Choose Metric Collection Errors

    Description of Figure 1-38 follows
    Description of "Figure 1-38 Choose Metric Collection Errors"

    The Metric Collection Errors page displays a table with metric collection error information. Verify the first column named Metrics contains the text "There are no errors!"

    You are now ready to verify the TimesTen reports.

  5. From the TimesTen IMDB menu, select Information Publisher Reports.

    The Information Publisher Reports page displays.

  6. Select a TimesTen report. For example, choose TimesTen IMDB Connections Reports.

    Verify the report displays and there are no errors. For information on reports, see "Viewing reports".

Setting preferred credentials for a target

In order to use the transaction monitor, you must set preferred credentials for your TimesTen target. For more information on the transaction monitor, see "Transaction monitor".

To set the preferred credentials for a target:

  1. Make sure you are on the Enterprise Manager Cloud Control 12c home page. From the Setup menu, select Security, then select Preferred Credentials.

    The Preferred Credentials page displays. Locate TimesTen In Memory Database 11g in the Target Type column.

  2. Click TimesTen In Memory Database 11g.

    Figure 1-40 Preferred Credentials Page

    Description of Figure 1-40 follows
    Description of "Figure 1-40 Preferred Credentials Page"

    You are now ready to set the preferred credentials for your TimesTen target.

  3. Click Manage Preferred Credentials.

    Figure 1-41 Click Manage Preferred Credentials

    Description of Figure 1-41 follows
    Description of "Figure 1-41 Click Manage Preferred Credentials"

    The TimesTen In Memory Database 11g Preferred Credentials page displays.

  4. In the Target Preferred Credentials table, locate the row that contains your TimesTen target. In the column Target Name, click the Target Name. (The target name is the name of the TimesTen target you configured).

    Figure 1-42 Click the target name

    Description of Figure 1-42 follows
    Description of "Figure 1-42 Click the target name"

  5. Click Set.

    The Select Named Credentials page displays.

  6. Click in the circle to the left of the text New.

    Figure 1-44 Select Named Credential page

    Description of Figure 1-44 follows
    Description of "Figure 1-44 Select Named Credential page"

    The Select Named credential page refreshes. You are now required to enter the preferred credentials for your TimesTen target. The first property is the UserName.

  7. In the *UserName text field, type the user who has access to the target host. The username must be the Operating System username of the TimesTen instance administrator.

  8. In the *Password text field, type the password for the user who has access to the target host. The password must be the Operating System password of the TimesTen instance administrator.

  9. In the *Confirm password text field, re-type the password.

  10. Click in the check box to the left of the text Save As.

  11. In the Save As text field, type the name you wish to use for the preferred credentials. The credentials are saved with this name.

  12. Click Test and Save.

    Figure 1-45 Click Test and Save

    Description of Figure 1-45 follows
    Description of "Figure 1-45 Click Test and Save"

    The information dialog displays with the text "Named credential association completed successfully".

    Figure 1-46 Successful named credential association

    Description of Figure 1-46 follows
    Description of "Figure 1-46 Successful named credential association"

You have successfully associated the credential with your TimesTen target.

Changing the monitoring configuration of a target

When you configure your TimesTen target, you specify the TimesTen username and password. If you change the password for this TimesTen user in the TimesTen database, you must update the password in the Enterprise Manager Cloud Control monitoring configuration. For more information on configuring your TimesTen target, see "Configure a TimesTen target".

To change the monitoring configuration of your TimesTen target:

  1. From the Targets menu, select All Targets on the Enterprise Manager Cloud Control 12c home page.

    The All Targets page displays. Locate the Refine Search panel under All Targets.

  2. Expand Target Type, then Databases and click TimesTen In Memory Database 11g.

    Figure 1-47 Choose TimesTen In Memory Database 11g

    Description of Figure 1-47 follows
    Description of "Figure 1-47 Choose TimesTen In Memory Database 11g"

    Locate the row that contains the target name.

    Figure 1-48 Locate the TimesTen target

    Description of Figure 1-48 follows
    Description of "Figure 1-48 Locate the TimesTen target"

    You are now ready to update the password.

  3. Right-click the Target Name located in the Target Name column of the row containing the TimesTen target and select Target Setup, then Monitoring Configuration.

    Figure 1-49 Change the monitoring configuration

    Description of Figure 1-49 follows
    Description of "Figure 1-49 Change the monitoring configuration"

    The target monitoring configuration page displays. Note that the Data Source Name, the TimesTen instance name, and the TimesTen username are auto-filled.

  4. In the TimesTen password text field, type the new password. This password must be the same password that exists in the TimesTen database for your TimesTen user. For example, if the TimesTen user name is appuser, and in the TimesTen database, you modified the TimesTen password for appuser to be newpassword, then in the TimesTen password field, type newpassword. For more information on changing a password in the TimesTen database, see "ALTER USER" in the Oracle TimesTen In-Memory Database SQL Reference.

  5. Click OK.

    The Saved Successfully dialog displays indicating the settings are saved correctly in the repository.

  6. In the Saved Successfully dialog, click OK.

    Figure 1-51 Monitoring configuration saved successfully

    Description of Figure 1-51 follows
    Description of "Figure 1-51 Monitoring configuration saved successfully"

    The Saved Successfully dialog closes.

You can verify the new monitoring configuration of your target. For more information on verifying a TimesTen target, see "Verifying and validating the plug-in".

Uninstalling the System Monitoring Plug-in for TimesTen

You must remove all TimesTen targets before you can undeploy the plug-in. For example, if you have three TimesTen targets and two targets are deployed to one agent and the third target is deployed to a second agent, you must:

  • Remove target 1 on agent 1.

  • Remove target 2 on agent 1.

  • Remove target 3 on agent 2.

You then undeploy and delete the plug-in from the Oracle Enterprise Manager Cloud Control.

To uninstall the System Monitoring Plug-in for TimesTen 11g:

Remove the TimesTen target

For each TimesTen target you wish to remove:

  1. From the Targets menu, select All Targets on the Enterprise Manager Cloud Control 12c home page.

    Figure 1-52 Choose All Targets

    Description of Figure 1-52 follows
    Description of "Figure 1-52 Choose All Targets"

    The All Targets page displays. Locate the Refine Search panel under the text "All Targets."

  2. Expand Target Type, then Databases and click TimesTen In Memory Database 11g.

    Figure 1-53 Choose TimesTen In Memory Database 11g

    Description of Figure 1-53 follows
    Description of "Figure 1-53 Choose TimesTen In Memory Database 11g"

    The target table displays. For each row in the table, confirm the column Target Type is TimesTen In Memory Database 11g. Also, confirm each row of the table contains the name of the target you previously configured. For more information on configuring a TimesTen target, see "Configure a TimesTen target".

    Locate the row that contains the target name you wish to remove.

  3. Right-click the Target Name located in the Target Name column of the row containing the TimesTen target and select Target Setup, then Remove Target...

    Figure 1-54 Remove target

    Description of Figure 1-54 follows
    Description of "Figure 1-54 Remove target"

    The Confirmation dialog displays the text "You have chosen to remove TimesTen_target_name (TimesTen In Memory Database 11g). Do you want to proceed?"

    The TimesTen_target_name is the name of your TimesTen target. For example, testhost.tt1122.sampledb_1122.

  4. Click Yes.

    Figure 1-55 Remove target confirmation dialog

    Description of Figure 1-55 follows
    Description of "Figure 1-55 Remove target confirmation dialog"

    The Information dialog displays the text "Target TimesTen_target_name (TimesTen In Memory Database 11g) has been deleted" where TimesTen_target_name is the name of your TimesTen target.

  5. Click OK.

    Figure 1-56 Target removed

    Description of Figure 1-56 follows
    Description of "Figure 1-56 Target removed"

    Verify the row that contained the TimesTen target has been removed from the target table.

Your TimesTen target is removed. Repeat Steps 1-5 to remove additional targets. If all targets are removed, you can undeploy and then delete the plug-in from the Oracle Enterprise Manager Cloud Control.

Undeploy the plug-in from the Management Agent

You must undeploy the plug-in from all the Management Agents that are monitoring TimesTen targets.

Note:

Undeploy the plug-in from the Management Agents before you undeploy the plug-in from the Oracle Management Service (OMS).

Make sure you have removed all TimesTen targets. For more information on the steps to remove a TimesTen target, see "Remove the TimesTen target".

To undeploy the plug-in from the Management Agent, make sure you are on the Oracle Enterprise Manager Cloud Control home page.

  1. From the Setup menu, select Extensibility, then select Plug-ins.

    Figure 1-57 Choose Extensibility, then Plug-ins

    Description of Figure 1-57 follows
    Description of "Figure 1-57 Choose Extensibility, then Plug-ins"

    The Plug-ins page displays and shows the Plug-ins table. Locate the Databases folder in the Name column.

  2. Expand the Databases folder in the Name column and click Oracle TimesTen In-Memory Database.

    Figure 1-58 Choose Oracle TimesTen In-Memory Database plug-in

    Description of Figure 1-58 follows
    Description of "Figure 1-58 Choose Oracle TimesTen In-Memory Database plug-in"

    You are now ready to undeploy the plug-in from the Agent. Locate the Undeploy From tab at the top of the page.

  3. From the Undeploy From menu, select Management Agent....

    Figure 1-59 Undeploy from Management Agent

    Description of Figure 1-59 follows
    Description of "Figure 1-59 Undeploy from Management Agent"

    The Undeploy Plug-in on Management Agent General page displays. Note that the plug-in Oracle TimesTen In-Memory Database is displayed in the Name column. Locate the Add... tab below Management Agent with this plug-in.

  4. Click Add...

    The Search and Select: Targets - Oracle Enterprise Manager page displays. You are now ready to choose the agent to undeploy. Below the text "Select Status Up Agents where TimesTen In-Memory Database is deployed," make sure the Target Type column equals Agent.

  5. In the Target table, locate the row that contains the correct agent as identified by target name and host. Click in this row and then click Select.

    Figure 1-61 Choose agent to undeploy

    Description of Figure 1-61 follows
    Description of "Figure 1-61 Choose agent to undeploy"

    The Management Agent table is updated with the name of the Management Agent you selected.

  6. Click Continue.

    Figure 1-62 Click Continue

    Description of Figure 1-62 follows
    Description of "Figure 1-62 Click Continue"

    The Undeploy Plug-in From Management Prerequisite Checks page displays. Make sure there is a green check mark in the Status column of the Management Agent table.

  7. Click Next.

    The Undeploy Plug-in From Management Agent Review page displays and shows the informational message, "Undeployment of plug-ins from the Management Agent deletes the targets monitored by the plug-in, and also restarts the Management Agent. During downtime, the Management Agent will not be able to monitor any targets."

    In the Management Agent with this plug-in table, verify the name in the Management Agent column is correct.

  8. Click Undeploy.

    Figure 1-64 Click Undeploy

    Description of Figure 1-64 follows
    Description of "Figure 1-64 Click Undeploy"

    The Undeploy Plug-in from Management Agent Confirmation page displays with a message indicating the undeployment of the plug-in has started on selected agents. The undeployment time varies. You may monitor the undeployment status by clicking Show Status or going to the Recent Deployment Activities page.

  9. Click Show Status.

    Figure 1-65 Undeploy agent confirmation

    Description of Figure 1-65 follows
    Description of "Figure 1-65 Undeploy agent confirmation"

    The Plug-ins Deployment Activities page displays showing the status of the undeployment steps in table format. Verify the first step located in the first row of the table contains the text, "Start undeployment" and verify the last step located in the last row of the table contains the text, "Update inventory." This is the last step in the undeployment process. Make sure there are green checks in the Status column of each row in the Deployment Steps table. Such checks indicate all steps in the undeployment process are completed and are successful. Also, make sure there is a green check in the Status column in the undeployment table located at the top of the page.

    Figure 1-66 Undeployment successful

    Description of Figure 1-66 follows
    Description of "Figure 1-66 Undeployment successful"

    The plug-in is undeployed from the Management Agent. Repeat Steps 1-8 to undeploy each management agent that is monitoring the plug-in.

You are now ready to undeploy the plug-in from the Oracle Management Server (OMS).

Undeploy the plug-in from OMS

Before you undeploy the plug-in from OMS, make sure you have undeployed the plug-in from all the Management Agents that are monitoring the plug-in.

To undeploy the plug-in from OMS, make sure you are on the Oracle Enterprise Manager Cloud Control home page.

  1. From the Setup menu, select Extensibility, then select Plug-ins.

    Figure 1-67 Choose Extensibility, then Plug-ins

    Description of Figure 1-67 follows
    Description of "Figure 1-67 Choose Extensibility, then Plug-ins"

    The Plug-ins page displays and shows the Plug-ins table. Locate the Databases folder in the Name column.

  2. Expand the Databases folder in the Name column and select Oracle TimesTen In-Memory Database.

    Figure 1-68 Choose TimesTen In-Memory Database plug-in

    Description of Figure 1-68 follows
    Description of "Figure 1-68 Choose TimesTen In-Memory Database plug-in"

    You are now ready to undeploy the plug-in from OMS. Locate the Undeploy From tab at the top of the page.

  3. From the Undeploy From menu, select Management Servers....

    Figure 1-69 Undeploy from OMS

    Description of Figure 1-69 follows
    Description of "Figure 1-69 Undeploy from OMS"

    The Undeploy Plug-in from Management Server General page displays. Note that the plug-in Oracle TimesTen In-Memory Database is displayed in the Name column and the Version is auto-filled. You must enter the Repository SYS user.

  4. In the *Repository SYS Password column, type the Repository SYS user password.

    Figure 1-70 Repository SYS Password

    Description of Figure 1-70 follows
    Description of "Figure 1-70 Repository SYS Password"

    Locate the Continue tab in the bottom right of the page.

  5. Click Continue.

    The Undeploy Plug-in From Management Server Review page displays. In the Management Servers table, verify the Management Server name is correct.

  6. Click Undeploy.

    Figure 1-72 Review Undeploy from OMS

    Description of Figure 1-72 follows
    Description of "Figure 1-72 Review Undeploy from OMS"

    The Undeploy Plug-in from Management Server Confirmation page displays with a message indicating the undeployment of the plug-in is in progress. The undeployment time varies. You may monitor the undeployment status by clicking Show Status or going to the Recent Deployment Activities page.

  7. Click Show Status.

    Figure 1-73 Undeploy from OMS confirmation

    Description of Figure 1-73 follows
    Description of "Figure 1-73 Undeploy from OMS confirmation"

    The Plug-ins Deployment Activities page displays showing the status of the undeployment steps in table format. Verify the last step located in the last row of the table contains the text, "Remove plugin's oracle home." This is the last step in the undeployment process. Make sure there are green checks in the Status column of each row in the Deployment Steps table. Such checks indicate all steps in the undeployment process are completed and are successful. Also, make sure there is a green check in the Status column in the undeployment table located at the top of the page.

    Figure 1-74 Undeployment of OMS successful

    Description of Figure 1-74 follows
    Description of "Figure 1-74 Undeployment of OMS successful"

    The plug-in is undeployed from OMS.

You are now ready to delete the plug-in from OMS and the Management Agent.

Delete the plug-in

When you delete the plug-in, you remove the plug-in from the Oracle Enterprise Manager Cloud Control. To delete the plug-in, make sure you are on the Oracle Enterprise Manager Cloud Control home page.

  1. From the Setup menu, select Extensibility, then select Self Update.

    Figure 1-75 Choose Extensibility, then Self Update

    Description of Figure 1-75 follows
    Description of "Figure 1-75 Choose Extensibility, then Self Update"

    The Self Update page displays. Locate the Plug-in folder.

  2. Click on the name Plug-in.

    Figure 1-76 Plug-in folder

    Description of Figure 1-76 follows
    Description of "Figure 1-76 Plug-in folder"

    The Plug-in Updates page displays. In the Plug-in Name column, locate Oracle TimesTen In-Memory Database. Confirm the Status column is equal to Downloaded.

  3. In the Plug-in Name column, click Oracle TimesTen In-Memory Database.

    Figure 1-77 Plug-in updates

    Description of Figure 1-77 follows
    Description of "Figure 1-77 Plug-in updates"

    Prepare to expand the Actions tab located under Plug-in Updates at the top of the page.

  4. Expand Actions and choose Delete.

    Figure 1-78 Delete plug-in

    Description of Figure 1-78 follows
    Description of "Figure 1-78 Delete plug-in"

    The Delete Update dialog displays indicating the delete will remove the update (plug-in) permanently. Prepare to confirm the delete by clicking Delete.

  5. Click Delete.

    Figure 1-79 Delete Update confirmation

    Description of Figure 1-79 follows
    Description of "Figure 1-79 Delete Update confirmation"

    A confirmation dialog displays indicating that the update (plug-in) has been deleted permanently.

  6. Click OK.

    Figure 1-80 Plug-in deleted

    Description of Figure 1-80 follows
    Description of "Figure 1-80 Plug-in deleted"

You have successfully deleted the plug-in. You can verify the plug-in has been deleted by reviewing the Plug-in Updates page. You should no longer see the TimesTen plug-in.