Oracle® Enterprise Manager

System Monitoring Plug-in for Oracle TimesTen In-Memory Database Release Notes

Release 11.2.1

E13082-02

June 2009

This document was first written and published in November 2007. The content has not changed since then.This documentation contains the following sections:

Platforms
Software requirements and installation
Known problems
Documentation Accessibility

1 Platforms

The Oracle TimesTen In-Memory Database Plug-in is supported on all TimesTen 7.0 platforms.

2 Software requirements and installation

For software requirements please refer to the Oracle Enterprise Manager System Monitoring Plug-in for Oracle TimesTen In-Memory Database Installation Guide.

For information on installing Oracle Enterprise Manager Agent 10.2.0.1 or later:

http://download.oracle.com/docs/cd/B16240_01/doc/nav/portal_booklist.htm

3 Known problems

This section lists known problems and limitations.

3.1 Access control

In some versions of Oracle Enterprise Manager, if access control is enabled, after clicking Test Connection, you must re-enter the password. If you click OK to add the target after doing a Test Connection, the plug-in gets a TimesTen authentication error. The password can be re-entered after the target is added by choosing Monitoring Configuration on the target's main page.

3.2 Collecting metrics

The plug-in can no longer collect metrics for the target in these situations:
- If access control is enabled and the user of the target is dropped.
- If access control is enabled and the user's password is changed while the plug-in is running.
- If a database that corresponds to a target DSN is unloaded.
- If the TimesTen daemon for a target DSN is stopped.

3.3 Credentials

The EM Agent Credentials (host username/password) need to be set correctly for the EM Agent to work.

3.4 Database destroyed

If a TimesTen database being monitored by the plug-in is destroyed, the plug-in's script continues to run (unsuccessfully) once per minute until the target is removed.

3.5 Direct-linked DSN

The plug-is not designed to use Client/Server DSNs. Only direct-linked DSNs should be used.

3.6 Performance

The plug-in should be not be deployed on the same machine as either the Enterprise Manager Oracle Management Server or the Oracle Enterprise Manager Repository.
When a TimesTen database is recreated using ttDestroy or with the overwrite attribute, the metrics in the SYS.MONITOR table are reset to zero. If the database was being monitored during this re-creation, some performance rates may temporarily become negative. This behavior corrects itself and is not an error.
The performance of the plug-in reports suffers if the server on which the Enterprise Manager Oracle Management Server or the Enterprise Manager Repository database is low on memory or is CPU bound or I/O bound.

3.7 Remove a target

If you remove a target and try to add it again with the same name, you may get an EM error such as: java.sql.SQLException: ORA-20600: The specified target is in the process of being deleted. You can either wait and retry, or use a different target name.

3.8 Target properties

The Target Properties page may lose values (for example, comment, line of business). This does not affect either the accuracy or the performance of the plug-in.

3.9 O/S user

The EM Agent and TimesTen instance should be installed as the same O/S user.

3.10 Windows

The host username must be specified as windows_domain\username.
The security privilege Log on as a batch user must be granted to the user who runs the EM Agent service.

4 Documentation Accessibility

Our goal is to make Oracle products, services, and supporting documentation accessible to all users, including users that are disabled. To that end, our documentation includes features that make information available to users of assistive technology. This documentation is available in HTML format, and contains markup to facilitate access by the disabled community. Accessibility standards will continue to evolve over time, and Oracle is actively engaged with other market-leading technology vendors to address technical obstacles so that our documentation can be accessible to all of our customers. For more information, visit the Oracle Accessibility Program Web site at http://www.oracle.com/accessibility/.

Accessibility of Code Examples in Documentation

Screen readers may not always correctly read the code examples in this document. The conventions for writing code require that closing braces should appear on an otherwise empty line; however, some screen readers may not always read a line of text that consists solely of a bracket or brace.

Accessibility of Links to External Web Sites in Documentation

This documentation may contain links to Web sites of other companies or organizations that Oracle does not own or control. Oracle neither evaluates nor makes any representations regarding the accessibility of these Web sites.

Deaf/Hard of Hearing Access to Oracle Support Services

To reach Oracle Support Services, use a telecommunications relay service (TRS) to call Oracle Support at 1.800.223.1711. An Oracle Support Services engineer will handle technical issues and provide customer support according to the Oracle service request process. Information about TRS is available at http://www.fcc.gov/cgb/consumerfacts/trs.html, and a list of phone numbers is available at http://www.fcc.gov/cgb/dro/trsphonebk.html.

Oracle Enterprise Manger Monitoring Plug-in for Oracle TimesTen In-Memory Database Release Notes, Release 11.2.1

E13082-02

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

If this software or related documentation is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, the following notice is applicable:

U.S. GOVERNMENT RIGHTS Programs, software, databases, and related documentation and technical data delivered to U.S. Government customers are "commercial computer software" or "commercial technical data" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, duplication, disclosure, modification, and adaptation shall be subject to the restrictions and license terms set forth in the applicable Government contract, and, to the extent applicable by the terms of the Government contract, the additional rights set forth in FAR 52.227-19, Commercial Computer Software License (December 2007). Oracle USA, Inc., 500 Oracle Parkway, Redwood City, CA 94065.

This software is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications which may create a risk of personal injury. If you use this software in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure the safe use of this software. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software in dangerous applications.

Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.

This software and documentation may provide access to or information on content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services.