Resumen del contenido incluido en la página 1
Oracle TimesTen
In-Memory Database
Installation Guide
Release 7.0
B31679-01
For last-minute updates, see the TimesTen release notes.
Resumen del contenido incluido en la página 2
Copyright ©1996, 2007, Oracle. All rights reserved. ALL SOFTWARE AND DOCUMENTATION (WHETHER IN HARD COPY OR ELECTRONIC FORM) ENCLOSED AND ON THE COMPACT DISC(S) ARE SUBJECT TO THE LICENSE AGREEMENT. The documentation stored on the compact disc(s) may be printed by licensee for licensee’s internal use only. Except for the foregoing, no part of this documentation (whether in hard copy or electronic form) may be reproduced or transmitted in any form by any means, electronic or mechanical, in
Resumen del contenido incluido en la página 3
Contents About this Guide TimesTen documentation . . . . . . . . . . . . . . . . . . . . . 1 Background reading . . . . . . . . . . . . . . . . . . . . . . . 2 Conventions used in this guide . . . . . . . . . . . . . . . . . . . 3 Technical Support . . . . . . . . . . . . . . . . . . . . . . . . 5 1 Access Control Introduc
Resumen del contenido incluido en la página 4
Platform support . . . . . . . . . . . . . . . . . . . . . . . 19 JDK support . . . . . . . . . . . . . . . . . . . . . . . . . 20 Client/Server configurations . . . . . . . . . . . . . . . . . . 21 Cache Connect to Oracle . . . . . . . . . . . . . . . . . . . . 21 Replication configurations . . . . . . . . . .
Resumen del contenido incluido en la página 5
Installing TimesTen on HP-UX Memory Windows . . . . . . . . . . . 54 Use a separate instance for each memory window . . . . . . . . . . 54 Using TimesTen in a memory window . . . . . . . . . . . . . . . 55 Address Space Considerations . . . . . . . . . . . . . . . . . . 55 Troubleshooting. . . . . . . . . . . . . . . . . . . . . . . . 56 Installing
Resumen del contenido incluido en la página 6
3 Data Store Upgrades Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . 87 Data store compatibility . . . . . . . . . . . . . . . . . . . . 87 Data type compatibility . . . . . . . . . . . . . . . . . . . . 87 Data store character set . . . . . . . . . . . . . . . . . . . . 88 Data type conversion . . . .
Resumen del contenido incluido en la página 7
Index Contents vii
Resumen del contenido incluido en la página 8
viii Oracle TimesTen In-Memory Database Installation Guide
Resumen del contenido incluido en la página 9
About this Guide This document contains all necessary information for installing the Oracle TimesTen® In-Memory Database (TimesTen) Data Manager, Client and Server components. The TimesTen CD contains a README.TXT file that holds the release notes. These notes list product information and late changes to the printed documentation. The release notes are also available in PDF format. The PDF file is named README.pdf. TimesTen documentation TimesTen documentation is available on the product di
Resumen del contenido incluido en la página 10
Oracle TimesTen In-Memory Contains a complete reference to all TimesTen SQL Database SQL Reference statements, expressions and functions, including Guide TimesTen SQL extensions. Oracle TimesTen In-Memory Contains a complete reference to the TimesTen error Database Error Messages messages and information on using SNMP Traps with and SNMP Traps TimesTen. Oracle TimesTen In-Memory Describes how to use the TTClasses C++ API to use Database TTClasses Guide the features available in TimesTen to
Resumen del contenido incluido en la página 11
• Microsoft ODBC 2.0 Programmer’s Reference and SDK Guide, included online in PDF format, provides information on ODBC for UNIX developers. For a conceptual overview and programming how-to of ODBC, see: • Kyle Geiger. Inside ODBC. Redmond, WA: Microsoft Press. 1995. For a review of SQL, see: • Melton, Jim and Simon, Alan R. Understanding the New SQL: A Complete Guide. San Francisco, CA: Morgan Kaufmann Publishers. 1993. • Groff, James R. / Weinberg, Paul N. SQL: The Complete Reference, Seco
Resumen del contenido incluido en la página 12
TimesTen documentation uses these conventions in command line examples and descriptions: If you see... It means... fixed width Variable; must be replaced with an appropriate value. italics [ ] Square brackets indicate that an item in a command line is optional. { } Curly braces indicated that you must choose one of the items separated by a vertical bar ( | ) in a command line. | A vertical bar (or pipe) separates arguments that you may use more than one argument on a single command line. ..
Resumen del contenido incluido en la página 13
timesten A sample name for the TimesTen instance administrator. You can use any legal user name as the TimesTen administrator. On Windows, the TimesTen instance administrator must be a member of the Administrators group. Each TimesTen instance can have a unique instance administrator name. DSN The data source name. Technical Support For information about obtaining technical support for TimesTen products, go to the following Web address: http://www.oracle.com/support/contact.html About this
Resumen del contenido incluido en la página 14
6 Oracle TimesTen In-Memory Database Installation Guide
Resumen del contenido incluido en la página 15
1 Access Control Introduction Access Control With TimesTen you can optionally install a layer of internal security, which throughout the TimesTen documentation set and in the installation scripts is referred to as “Access Control.” The Access Control feature of TimesTen provides an environment of basic control for applications that use the internally defined privileges. In TimesTen, user privileges are granted on a instance wide-basis. A user’s privileges apply to all data stores in a give
Resumen del contenido incluido en la página 16
Cache Connect For Cache Connect, the TimesTen internal user must match the Oracle user. External Client/Server users must match the Oracle user. If you are using the Cache Connect Administrator interface, the user must be an internal TimesTen user. Replication If Access Control is enabled, replication daemon administration and replication schema changes are restricted to users having the ADMIN privilege. See “Privileges” on page 13. Changes are applied to a replicated subscriber data store
Resumen del contenido incluido en la página 17
% ttDaemonAdmin -start To stop an instance: % ttDaemonAdmin -stop Instance data store A DSN for a minimal instance-wide data store is defined by TimesTen at install time to guarantee that TimesTen always has something with which to connect. The following is the definition of the instance DSN for a root installation: [TT_instance] Driver=install_dir/lib/libtten.suffix DataStore=/var/TimesTen/instance/TT_instance The following is the definition of the instance DSN for a non-root installation:
Resumen del contenido incluido en la página 18
Note: All examples in the TimesTen documentation set use the name timesten to represent the instance administrator. For details on establishing the TimesTen instance administrators group, see “Create the TimesTen instance administrators group” on page 37. On Windows systems, the user System automatically becomes the TimesTen instance administrator when Access Control is selected at install time. On UNIX systems, a TimesTen instance administrator user is the OS user who installs that instanc
Resumen del contenido incluido en la página 19
automatically converts the external user name to upper case, rendering it case insensitive. The PWDCrypt attribute allows you to encrypt a password rather to use cleartext passwords, and it also provides a way to deal with the special characters and case sensitivity used in passwords that might create difficulties if specified in clear text within the PWD DSN attribute. Before installation Several steps must be taken to prepare a machine for TimesTen installation. These steps are needed on
Resumen del contenido incluido en la página 20
Installation directories, files and the daemon port Installation of TimesTen must be performed by the chosen instance administrator user. The instance administrator owns all files in the installation directory tree. Only the instance administrator can operate the instance. Installation directories The installer suggests default destination directories, based on the user performing the installation. Instance home directory The instance may be installed in any directory to which the instance
