Oracle Audio Technologies B31679-01 manuel d'utilisation

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130

Aller à la page of

Un bon manuel d’utilisation

Les règles imposent au revendeur l'obligation de fournir à l'acheteur, avec des marchandises, le manuel d’utilisation Oracle Audio Technologies B31679-01. Le manque du manuel d’utilisation ou les informations incorrectes fournies au consommateur sont à la base d'une plainte pour non-conformité du dispositif avec le contrat. Conformément à la loi, l’inclusion du manuel d’utilisation sous une forme autre que le papier est autorisée, ce qui est souvent utilisé récemment, en incluant la forme graphique ou électronique du manuel Oracle Audio Technologies B31679-01 ou les vidéos d'instruction pour les utilisateurs. La condition est son caractère lisible et compréhensible.

Qu'est ce que le manuel d’utilisation?

Le mot vient du latin "Instructio", à savoir organiser. Ainsi, le manuel d’utilisation Oracle Audio Technologies B31679-01 décrit les étapes de la procédure. Le but du manuel d’utilisation est d’instruire, de faciliter le démarrage, l'utilisation de l'équipement ou l'exécution des actions spécifiques. Le manuel d’utilisation est une collection d'informations sur l'objet/service, une indice.

Malheureusement, peu d'utilisateurs prennent le temps de lire le manuel d’utilisation, et un bon manuel permet non seulement d’apprendre à connaître un certain nombre de fonctionnalités supplémentaires du dispositif acheté, mais aussi éviter la majorité des défaillances.

Donc, ce qui devrait contenir le manuel parfait?

Tout d'abord, le manuel d’utilisation Oracle Audio Technologies B31679-01 devrait contenir:
- informations sur les caractéristiques techniques du dispositif Oracle Audio Technologies B31679-01
- nom du fabricant et année de fabrication Oracle Audio Technologies B31679-01
- instructions d'utilisation, de réglage et d’entretien de l'équipement Oracle Audio Technologies B31679-01
- signes de sécurité et attestations confirmant la conformité avec les normes pertinentes

Pourquoi nous ne lisons pas les manuels d’utilisation?

Habituellement, cela est dû au manque de temps et de certitude quant à la fonctionnalité spécifique de l'équipement acheté. Malheureusement, la connexion et le démarrage Oracle Audio Technologies B31679-01 ne suffisent pas. Le manuel d’utilisation contient un certain nombre de lignes directrices concernant les fonctionnalités spécifiques, la sécurité, les méthodes d'entretien (même les moyens qui doivent être utilisés), les défauts possibles Oracle Audio Technologies B31679-01 et les moyens de résoudre des problèmes communs lors de l'utilisation. Enfin, le manuel contient les coordonnées du service Oracle Audio Technologies en l'absence de l'efficacité des solutions proposées. Actuellement, les manuels d’utilisation sous la forme d'animations intéressantes et de vidéos pédagogiques qui sont meilleurs que la brochure, sont très populaires. Ce type de manuel permet à l'utilisateur de voir toute la vidéo d'instruction sans sauter les spécifications et les descriptions techniques compliquées Oracle Audio Technologies B31679-01, comme c’est le cas pour la version papier.

Pourquoi lire le manuel d’utilisation?

Tout d'abord, il contient la réponse sur la structure, les possibilités du dispositif Oracle Audio Technologies B31679-01, l'utilisation de divers accessoires et une gamme d'informations pour profiter pleinement de toutes les fonctionnalités et commodités.

Après un achat réussi de l’équipement/dispositif, prenez un moment pour vous familiariser avec toutes les parties du manuel d'utilisation Oracle Audio Technologies B31679-01. À l'heure actuelle, ils sont soigneusement préparés et traduits pour qu'ils soient non seulement compréhensibles pour les utilisateurs, mais pour qu’ils remplissent leur fonction de base de l'information et d’aide.

Table des matières du manuel d’utilisation

  • Page 1

    Oracle T imesT en In-Memory Dat abase Inst allation Guide Release 7.0 B31679-01 For last-minute updates, see the TimesT en release notes.[...]

  • Page 2

    Copyright ©1996, 2007, Oracle. All rights reserved. ALL SOFTW ARE AND DOCUMENT A TION (WHETHER IN HARD COPY OR ELECTRONIC FORM) ENCLOSED AND ON THE COMP ACT DISC(S) ARE SUBJECT T O THE LICENSE AGREEMENT . The documentation stored on the compact disc(s) may be pri nted by licensee for licensee’ s internal us e only . Except for the foregoing, no [...]

  • Page 3

    iii Contents About this Guide T imesT en documentation . . . . . . . . . . . . . . . . . . . . . 1 Background reading . . . . . . . . . . . . . . . . . . . . . . . 2 Conventions used in this guide . . . . . . . . . . . . . . . . . . . 3 T echnical Support . . . . . . . . . . . . . . . . . . . . . . . . 5 1 Access Control Introduction . . . . . . . [...]

  • Page 4

    iv Oracle T imesT en In-Memory Database Installation Guide Platform support . . . . . . . . . . . . . . . . . . . . . . . 19 JDK support . . . . . . . . . . . . . . . . . . . . . . . . . 20 Client/Server configurations . . . . . . . . . . . . . . . . . . 21 Cache Connect to Oracle . . . . . . . . . . . . . . . . . . . . 21 Replication configuration[...]

  • Page 5

    Contents v Installing TimesT en on HP-UX Memory W indow s . . . . . . . . . . . 54 Use a separate instance for each memory window . . . . . . . . . . 54 Using T imesT en in a memory window . . . . . . . . . . . . . . . 55 Address Space Considerations . . . . . . . . . . . . . . . . . . 5 5 T roubleshooting. . . . . . . . . . . . . . . . . . . . . .[...]

  • Page 6

    vi Oracle T imesT en In-Memory Database Installation Guide 3 Dat a Store Upgrades Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . 87 Data store compatibility . . . . . . . . . . . . . . . . . . . . 87 Data type compatibility . . . . . . . . . . . . . . . . . . . . 87 Data store character set . . . . . . . . . . . . . . . . . . . . [...]

  • Page 7

    Contents vii Index[...]

  • Page 8

    viii Oracle T imesT en In -Memory Database Install ati on Gui de[...]

  • Page 9

    1 About this Guide This document contains all necessa ry information fo r installing the Oracle T imesT en® In-Memory Database (TimesT en) Data Manager , Client and Server components. The T imesT en CD contains a READM E.TXT file that holds the release notes. These notes list product information and late changes to the printed do cu mentation. The[...]

  • Page 10

    2 Oracle T imesT en In -Memory Database Installation Gui de Background reading For a Java reference, see: • Horstmann, Cay and Gary Cornell. Core Java (T M) 2, Volume I-- Fundamentals (7th Edition) (Core Java 2) . Prentice Hall P TR; 7 edition (August 17, 2 004). A list of books ab out ODBC and SQL is in t he Microsoft ODBC manual included in you[...]

  • Page 11

    About this Guide 3 • Microsoft ODBC 2.0 Programmer’s Reference and SDK Guide , included online in PDF format, provides informatio n on ODB C for UNIX developers. For a conceptual overview and pr ogramming how-t o of ODB C, see: • Kyle Geiger . Inside ODBC . Redmon d, W A: Mi crosoft Press. 1995. For a review of SQ L, see: • Melton, Jim and [...]

  • Page 12

    4 Oracle T imesT en In -Memory Database Installation Gui de T imesT en documentation uses thes e conventions in command line examples and descriptions: T imesT en documentat ion uses these variables to identify path, file and user names: If you see... It means... fixed width italics V ariable; must be replaced with an appropriate value. [ ] Square [...]

  • Page 13

    About this Guide 5 T echnical Support For information about obtaining techn ical support for T imesT en products, go to the following W eb address: http://www .oracle.com/ support/contact.html timesten A sample name for the TimesT en instance administrator . Y ou can use any legal user name as the T imesT en administrato r . On Windows, the T imesT[...]

  • Page 14

    6 Oracle T imesT en In -Memory Database Installation Gui de[...]

  • Page 15

    7 1 Access Contr ol Introduction Access Control W ith T imesT en you can optionally install a layer of intern al security , which throughout the TimesT en docum entat ion set and in the installation scripts is referred to as “Access Control.” The Access Control feature of T imesT en provides an environment of basic control for applications that[...]

  • Page 16

    8 Oracle T imesT en In-Memo ry Datab ase Installation Guide Cache Connect For Cache Connect, the T imesT en inte rnal user must match the Oracle user . External Client/ Server users mu st match the Oracle user . If you are using the Cache Connect Administrato r interface, the user must be an internal T imesT en user . Replication If Access Control [...]

  • Page 17

    Access Contr ol 9 % ttDaemonAdmin -start T o stop an instance: % ttDaemonAdmin -stop Inst ance data store A DSN for a minimal instance-wide data sto re is defin e d by TimesT en at install time to guarantee that TimesT en alw a ys has som ething with which to connect. The following is the definition of the inst ance DSN for a root installation: [TT[...]

  • Page 18

    10 Oracle T imesT en In-Memory Database Installation Guide Note: All examples in the TimesT en d ocum entation set use the name timesten to represent the in stance administrator . For details on estab lishing the T ime sT en instance admini strators group, see “Create the TimesTen instance ad ministrators group” on page 37 . On W indows systems[...]

  • Page 19

    Access Contr o l 11 automatically converts the external us er name to upper case, rendering it case insensitive. The PW DCrypt attribute allows you to encr ypt 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 specifie[...]

  • Page 20

    12 Oracle T imesT en In-Memory Database Installation Guide Inst allation dir ectories, files and the daemon port Installation of TimesT en must be performed by the chosen instan ce administrator user . The instance admi nistrator owns all files in the installation directo ry tree. Onl y th e instance administrator can operate the instance. Inst all[...]

  • Page 21

    Access Contr o l 13 been selected. If this file is missing , an error occurs after Access Control is enabled. This file is readable and writable only by the instance administrator . Passwords are stored in encrypted form and are not known to the instance administrator as one way hashes, so they cannot be recovered. Daemon port Though the instance r[...]

  • Page 22

    14 Oracle T imesT en In-Memory Database Installation Guide Maint aining users and privileges T imesT en allows the instance admini strator to create, drop and alter users when Access Control is enable d. It also allows the instance administrator to grant and revoke pr iv ileges fo r users. For details see Chapter 5, “SQL Statements in the Oracle [...]

  • Page 23

    Access Contr o l 15 All other changes to the T imesT en instance can only be made by uninstalling and re-install ing the same or a d ifferently release of T imesT en. (See “Changing the daemon port number on UNIX” on page 39 and “ORACLE_HOME environment variable” on page 77 .)[...]

  • Page 24

    16 Oracle T imesT en In-Memory Database Installation Guide[...]

  • Page 25

    17 2 T imesT en Installation This chapter contains configuration information that you wil l need to review before installing TimesT en on your system, in the sections: • Platforms and co nfigurations • Installation instances • Choosing the appropriat e TimesTen components • Installation prerequisit e s • Operating system security consider[...]

  • Page 26

    18 Oracle T imesT en In-Memory Database Installation Guide • Building and running the demo appl ications • V iewing the onli ne documentation Finally , this chapter contains inform ati on that helps you troubleshoot any problems that may arise during the installation process: • Installation problems[...]

  • Page 27

    T imesT en Installation 19 Plat forms and configurations Plat form support T imes T en Data Manager and TimesT en Cli en t/Serv er are supported in the following environments:. Environme nt 32-bit 64-b it Microsof t Windows 2000, Windows XP and Windows Server 2003 for Intel IA-32 and EM64T and AMD6 4 CPUs. Ye s Ye s Solaris 10 for AM D6 4 C PUs . Y[...]

  • Page 28

    20 Oracle T imesT en In-Memory Database Installation Guide JDK support Note: TimesT en suppo rts the Sun JVM and the BEA W ebLogi c JRockit JVM for Linux and W indows x86 systems. For details on JRockit, see www.bea.com . T imesT en supports the follo wing JDKs on the specified platforms: Environment JDK 1.4 JDK 5.0 BEA WebLogic JRockit 5.0 Microso[...]

  • Page 29

    T imesT en Installation 21 Client/Server configurations A T imesT en client on any support ed platform can connect to a T imesT en server on any platform where TimesT en is supported. A T imesT en 6.0 client can connect to a 6.0 T imesT en Server of any patch level. If the -insecure-ba ckwards-compat option is set in the ttendaemon.op tions file, a[...]

  • Page 30

    22 Oracle T imesT en In-Memory Database Installation Guide Cache Connect is supported on the 32-bit and 64-bit platforms specified in this table: Replication configurations T imesT en-to-TimesT en Replication is supported only between identical platforms and bit-levels. Environment 32-bit 64-bit Microsof t Windows 2000, Windows XP and Windows Serve[...]

  • Page 31

    T imesT en Installation 23 Inst allation inst ances On UNIX, you can install more th an one instance of any T imesT en release. By default, the instan ce name for this release is tt70. If an instance of a partic ular release of TimesT en already exists on the machine, and you would like to in stall a second instance of the same T imesT en release, [...]

  • Page 32

    24 Oracle T imesT en In-Memory Database Installation Guide Choosing the appropria te T i mesT en component s T imesT en allows you to select the components of T imesT en that you wish to install. Component s available on Windows Component s available on UNIX If you have already installed some component s and you wou ld li ke to add a component, you[...]

  • Page 33

    T imesT en Installation 25 Inst allation prerequisites Before installin g T imesT en, make su re the appropriate requirements are met for your operating system . On platforms where JDBC is supporte d you must h ave the appropriate version of the JDK installed on your machine to use JDBC. See “Platforms and co nfigurations” on page 19 to learn w[...]

  • Page 34

    26 Oracle T imesT en In-Memory Database Installation Guide Other Client/ Server Settings The maximum number of concurrent IPC connection s to a TimesT en Server allowed by T imesT en is 9,999. However, system limits can take precedence on the number of connec tions to a single DSN. Client/ Server users can increase the file de scriptor limit to sup[...]

  • Page 35

    T imesT en Installation 27 3. Scroll do wn the list of parameters to semmn s and change its value to a minimum of 4096 or greater . 4. For HP-UX 1 1i systems, also s croll down the li st of parameters to shmmax and change its value to a maxim um of 0x40 000000. Note: The value 0x 240000000 (a 24 followed by seven zero es) indicates that the largest[...]

  • Page 36

    28 Oracle T imesT en In-Memory Database Installation Guide The C development t ools are required if native development will be done on the machine. Large pages Large pages can be enabled only if the running Linux kernel supports large pages (also called “huge pages” in Linux community). If large pages are supported by the ke rnel, there should [...]

  • Page 37

    T imesT en Installation 29 When T imesT en uses lar ge pages, the HugePag es_Free file in /proc / meminfo changes. Semaphores T o view existing kernel parameter settings, log in as root and use: # /sbin/sysctl -a Shared memory T o increase the shared memory si ze to 2048 MB, for example, as root , edit the /etc/sys ctl.conf file by adding the line:[...]

  • Page 38

    30 Oracle T imesT en In-Memory Database Installation Guide For Red Hat 3.0, install: compat-libstd c++-7.3-2.96. 123 For Red Hat 4.0, install: compat-libstd c++-296-2.96. 132.7.2 These packages can be install either using the rpm command o r by using the Red Hat GUI installer found in “Legacy Softw are Develo pment.” Replication For replication[...]

  • Page 39

    T imesT en Installation 31 ryps3# modload /ke rnel/sys/sems ys ryps3# modload /ke rnel/sys/shms ys Increase number of semaphores For Solaris 10 systems, the defau lt semaph ore settings should be sufficient without entries in / etc/system . On other Solaris systems, you may need to increase the number of semaphores. T imesT en consumes 1 SEMMNI per[...]

  • Page 40

    32 Oracle T imesT en In-Memory Database Installation Guide access 12 data stores, add the following line to /etc/system and reboot before using T imesT en: set shmsys:sh minfo_shmseg= 12 Other changes Other changes that you m a y need to m ake to your Solaris system include the following: • T o allow a lar ge number of connec tions to a data stor[...]

  • Page 41

    T imesT en Installation 33 Replication For replication, TCP se nd and receive buffers should be increased to a minimum of 512KB. Y ou may need to embed th e followin g commands into a script that can be run at system boot time: # /usr/sbin/ndd -set /dev/tcp tcp xmit_ hiwat=524288 # /usr/sbin/ndd -set /dev/tcp tcp_re cv_hiwat=52428 8 T ru64 UNIX Sem[...]

  • Page 42

    34 Oracle T imesT en In-Memory Database Installation Guide T o increase the maximum data segm ent (malloc space) a process may use, change the kernel values per_proc_data_size and max_per_proc_ data_size For example, to change all of these values to 10GB: 1. Create a text file, kerne lparams , that contains the following: per_proc_addr ess_space = [...]

  • Page 43

    T imesT en Installation 35 The temporary directory is operating system-dependent. Usually it is located in these directories: • On W indows, C:Docume nts and Setti ngs%USERNAME% Local SettingsTemp • On Solaris, Linux and T ru64 UNIX, /tmp • On HP-UX and AIX, /var/tm p Y ou can change the location of your tem porary directory by setting th[...]

  • Page 44

    36 Oracle T imesT en In-Memory Database Installation Guide segments are ownership and permissions restricted to that of a particular operating system group. This mode only w ork s if TimesT en is inst alled and running as root . See the Oracle T i mesT en In-Memory Database API Refer ence Guide .[...]

  • Page 45

    T imesT en Installation 37 Prerequisites for non-root inst allations on UNIX systems As discussed in Chapter 1, “Access Control,” on UNIX systems, you can install T imesT en as a non-root us er . This entire se ction applies to all UNIX platforms on which Ti mesT en is supported, unless oth erwi se indicated. However , you may need to perform c[...]

  • Page 46

    38 Oracle T imesT en In-Memory Database Installation Guide # setprivgrp times ten MLOCK The getprivgrp command can be used to check the privileges of a group: $ getprivgrp times ten timesten: MLOCK Note: On Linux and Tru64 systems, root privileges are required to use MemoryLock attribut e. On Solaris sy stems, you must be installed as root to use M[...]

  • Page 47

    T imesT en Installation 39 This step is only necessary if you want the T imesT en instance to start each time the machine is rebooted. Note: If you install these scripts into your system directory , you must manually remove them in the case that you want to un instal l your T imesT en instance, using # setuproot -unins tall Configure the syslog mes[...]

  • Page 48

    40 Oracle T imesT en In-Memory Database Installation Guide See the TimesTen Developer’s Guide for more information about using Ti m e s Ten . Inst alling T imesT en on Windows systems This section discusses installation and related issues for W indows systems. For a list of W indows platforms supported by TimesT en , see “Platforms and co nfigu[...]

  • Page 49

    T imesT en Installation 41 By default, Access Control is not enabled. See Chapter 1, “Access Control” for more details. Custom setup also lets you choose other custo m opt ion s. The installation program adds Time sT en directories to the system environment variables LIB and IN CLU DE. In addition, instal lation prompts y ou to add a directo ry[...]

  • Page 50

    42 Oracle T imesT en In-Memory Database Installation Guide V erifying inst allation T o verify that T imesT en has been properly installed, check that the driver files are available and that the services are running: 1. Check that the T imesT en 7.0 Start menu shortcut has been added to the W indows Desk top St a r t > P r o g r a m s menu. 2. O[...]

  • Page 51

    T imesT en Installation 43 The ODBC Administrator attempts to connect to the TimesT en Server and display a message to let you know if it was successful. When you click this button, the T imesT en Client verifies that : • ODBC, W indows sockets, and the T i mesT en Client are in stalled on the machine. • The T imesT en Server you have selected [...]

  • Page 52

    44 Oracle T imesT en In-Memory Database Installation Guide 1. On the W indows desktop, choose S tart > Settings > Control Panel > Administrative T ools > Services. This displays all currently available services. 2. Select TimesT en Data Manager 7.0 . 3. Click S tart to start the service. If the service is already running, click St o p t[...]

  • Page 53

    T imesT en Installation 45 Inst alling T imesT en T o install Ti mesT en o n your Solaris system, follow these steps: 1. Log in as the T imesT en instance administrator if installing as non-root, or log in as user root. 2. Load the CD-ROM into the CD drive as follows: • If the V olume Manager i s installed on t he system, you do n’t have to exp[...]

  • Page 54

    46 Oracle T imesT en In-Memory Database Installation Guide In addition, setup.sh also accepts these options: The CD contains tar files of T imesT en. If the setup script cannot find the tar files to extract from, it prompts you for their location. 4. Enter your response to the setu p script prompts. Note: T o install or uninstal l TimesT en without[...]

  • Page 55

    T imesT en Installation 47 • On 64-bit systems, prompt s you to install one of the follow ing releases: – 32-bit (default) – 64-bit • Prompt s you to: – Install a new instance – Upgrade an existing instance (This op tion allows you to incrementally install the Cache Connect option. The m ajor and minor version num bers of the T imesT en[...]

  • Page 56

    48 Oracle T imesT en In-Memory Database Installation Guide • Copies the daemon script s into the appropriate directories. • If installed by user root , configures the system to start the daemon when the system boots. • Creates the directory where data stores created by the T imesT en demo applications w ill reside. By defaul t they reside in [...]

  • Page 57

    T imesT en Installation 49 T o stop the daemon manually , use the utility command: ttDaemonAdmin -stop T o start the daemon manua lly , use the utility command: ttDaemonAdmin -start Uninst alling TimesT en T o uninstall all T imesT en components: 1. Log in as the T imesT en instance administrator if you installed as non- root, or log in as user roo[...]

  • Page 58

    50 Oracle T imesT en In-Memory Database Installation Guide # mkdir /cdrom Mount the CD-ROM, as follows: • If your system is configured to mount the CD-ROM at /cdrom , type: # /etc/mount /cdro m • Otherwise, mount the CD-ROM device name to the /cdrom directory , as follows: # /etc/mount -r cdfs CD -ROM_device_na me /cdrom where CD-ROM_device_nam[...]

  • Page 59

    T imesT en Installation 51 Specify the option at the end, outside th e quotation marks. In additio n, setup.sh also accepts these options: The CD contains tar files of T imesT en. If the setup script cannot find the tar files to extract from, it prompts you for their location. 4. Enter your response to the setu p script prompts. Note: T o install o[...]

  • Page 60

    52 Oracle T imesT en In-Memory Database Installation Guide • On 64-bit systems, prompt s you to in stall one of the following releases: – 32-bit (default) – 64-bit • Prompt s you to: – Install a new instance – Upgrade an existing instance (This op tion allows you to incrementally install the Cache Connect option. The major an d minor ve[...]

  • Page 61

    T imesT en Installation 53 • Copies the daemon scripts into the appropriate directories. • If installed by user root , configures the system to start the daemon when the system boots. • Creates the directory where data stores created by the T imesT en demo applications w ill reside. By defaul t they reside in /var/ TimesTen/ TTinstance /D emo[...]

  • Page 62

    54 Oracle T imesT en In-Memory Database Installation Guide If you installed T imesT en as root , th e daemon startup file on HP-UX is: /etc/rc.confi g.d/tt_ TTinstance If you installed Ti mesT en as a non-root user, It is: install_dir /startup T o stop the daemon manually , use the utility command: ttDaemonAdmin -stop T o start the daemon manua lly[...]

  • Page 63

    T imesT en Installation 55 <instance> command to determine which port is being used by the instance. Using TimesT en in a memory window In order to use a T imesT en instance running in a memory window , you must launch your app lication using the HP-UX setmemwindow(1M) command. For example, given instance tt_ins1 , use: % setmemwindow -j -i `[...]

  • Page 64

    56 Oracle T imesT en In-Memory Database Installation Guide application SHMEM_MAGIC may result with an Invalid Argument error ( EINVAL, errno=22 ) when attempting to connect to T imesT en. If a connection is made to a data store with ExclAccess=1 , then memory windows will not be used . In this case, T i me sT en does not allocate shared memory but [...]

  • Page 65

    T imesT en Installation 57 • Not enough core ( ENOMEM, errno=12 ) indicates a problem allocating the requested amo unt of shared m emory . Can you att ach with small PermSize and Te m p S i z e attributes? • Shared memory can be fragmented. Sometimes, you can attach with increasingly larger segments until you allocate what you want. Are you att[...]

  • Page 66

    58 Oracle T imesT en In-Memory Database Installation Guide # mount /usr /cdrom/TimesTen7.0 After the CD-ROM setu p is complete, you can install T imesT en as follows: 5. Still logged in as user root or the TimesT en instance administrator , run the setup script by typing: # cd mount_dir # ./setup.sh where mount_dir is the directory where the CD is [...]

  • Page 67

    T imesT en Installation 59 The CD contains tar files of T imesT en. If the setup script cannot find the tar files to extract from, it prompts you for their location. 6. Enter your response to the setu p script prompts. Note: T o install or uninstall TimesT en without having to respond to prompts, use the -bat ch flag with the setup.sh script. Batch[...]

  • Page 68

    60 Oracle T imesT en In-Memory Database Installation Guide – Data Manager only – Client only • Prompts you for the location of your T imesT en installati on and specific files, if insta lling as a non-root user . • Prompts you to specify the daemon port number . If no instances of T imesT en are installed on the mach ine, or if no instances[...]

  • Page 69

    T imesT en Installation 61 Working with the T imesT en daemon and server The T imesT en daemon starts automa tically when the operating system is booted and operates continually in the background. Application developers do not interact with timestend directly; no application code runs in the daemon and application deve lop ers do not, in gen eral, [...]

  • Page 70

    62 Oracle T imesT en In-Memory Database Installation Guide Inst alling T imesT en on Linux systems This section discusses installation and some related topi cs fo r Linux systems. Note: Before beginning installation, b e sure that the prerequisit es defined in “Installation prerequisites” on page 25 hav e been met. Inst alling T imesT en T o in[...]

  • Page 71

    T imesT en Installation 63 removes all files it had installed. In additi on, setup.sh also accepts these options: The CD contains tar files of T imesT en. If the setup script cannot find the tar files to extract from, it prompts you for their location. 4. Enter your response to the setu p script prompts. Note: T o install or uninstall TimesT en wit[...]

  • Page 72

    64 Oracle T imesT en In-Memory Database Installation Guide minor version num bers of the T imesT en release must match exactly .) – Display information abou t an existing instance or – Quit the installation. • Prompts you to chose the default instance name or chose a name for your T imesT en instance. See “Installation instances” on page [...]

  • Page 73

    T imesT en Installation 65 • If there are other instances of th e same patch release of TimesT en installed on the sam e machine, prompts you to provide a uniqu e port to be used by the T imesT en daemon. • If the T i mesT en Server is being installed, prom pts you to configure the Server: server name, port number and logging options . • Prom[...]

  • Page 74

    66 Oracle T imesT en In-Memory Database Installation Guide 1. Log in as the T imesT en instance administrator if you installed as non- root, or log in as user root. 2. The T imesT en setup script i s in the install_dir/ bin directory . Run the script with the -uninstall flag in a directory outside of the installation directo ry , by ty ping: # inst[...]

  • Page 75

    T imesT en Installation 67 • Y ou can run the setup script with the option -ins tall or - uninstall (default is - insta ll ). When you use the - uni nstall option, the script stop s th e daemon if it is running and rem oves all files it had installed. Note: T o uni nstall T imesT en, you must run setup.sh -uninstal l in a directory outside of the[...]

  • Page 76

    68 Oracle T imesT en In-Memory Database Installation Guide release are assigned default answ ers and may produce unexpected results when batch files from different versions are used. The setup script performs these acti ons (unless your an swers resulted in termination of the installation process): • Prompt s you to: – Install a new instance ?[...]

  • Page 77

    T imesT en Installation 69 • Copies the daemon scripts into the appropriate directories. • If installed by user root , configures the system to start the daemon when the system boots. • Creates the directory where data stores created by the T imesT en demo applications w ill reside. By defaul t they reside in /var/ TimesTen/ TTinstance /D emo[...]

  • Page 78

    70 Oracle T imesT en In-Memory Database Installation Guide T o start the daemon manua lly , use the utility command: ttDaemonAdmin -start Uninst alling TimesT en T o uninstall all T imesT en components: 1. Log in as the T imesT en instance administrator if you installed as non- root, or log in as root . 2. The T imesT en setup script i s in the ins[...]

  • Page 79

    T imesT en Installation 71 Note: The Cache Adm inistrator will not work if it is running on a W indows machine with the Windows Firewall ON (this is the usual setting). In this case, the W indows Administrator must add an exception to allow the Cache Administrator to connect through the Windows Firewall. For details on setting the envi ron men t va[...]

  • Page 80

    72 Oracle T imesT en In-Memory Database Installation Guide 4. Click Next or Previous to view additional messages. Note: Y ou can also use the ttDaemonLog utility to view messag es logged by the T imesT en Data Manager . For a description of the system administration ut ili ties, see "Util ities" in the Oracle T imesT en In- Memory Databas[...]

  • Page 81

    T imesT en Installation 73 *.debug /var/ adm/syslog/sy slog.log user.err; user. warn; user.info /var/adm/mes sages T o make changes to /etc/syslog.c onf , you must have root privileg es or be the TimesT en instance administrator . Changes only take effect after the syslog daemon ( syslog d ) process is terminated (with the command kill -1 ) and res[...]

  • Page 82

    74 Oracle T imesT en In-Memory Database Installation Guide Environment modifications This section describes various enviro nment variables that you may need to set, depending on the features of TimesT en that your application uses. The following table summ arizes, in alphabetical order, the environment variables detailed in this section and other p[...]

  • Page 83

    T imesT en Installation 75 P A TH environment variable T imesT en provides utilit ies for managing and deb ugg ing T imesT en applications. T o make these utilit ies readily available, include the bin directory found in install_dir in the P A TH environment variable. Note: install_dir is the directory where T imesT en is installed. On W indows, the[...]

  • Page 84

    76 Oracle T imesT en In-Memory Database Installation Guide application. If TimesT en cannot lo cate a user DSN file, the syst em DSN file located in /var/TimesTen/sy s.odbc.ini will be used. Also, see “Defining data sources for the dem o appl icati ons” on page 83 for more information on the .odbc.ini file. For non-root installations, TimesT en[...]

  • Page 85

    T imesT en Installation 77 CLASSP A TH environment variable On W indows and UNIX platforms, add install_dir /demo and install_dir /lib/ttjdbc jdk_version .jar . to the CLASSP A TH environment variable. Fo r example, for JDK 5.0, set the CLASSP A TH environm en t variable to: install_dir /lib/ ttjdbc5.jar . ORACLE_HOME environment variable On platfo[...]

  • Page 86

    78 Oracle T imesT en In-Memory Database Installation Guide On HP-UX 64-bit systems, add install_dir / lib to the LD_LIBRARY_PA TH environment variable. If you are using the Cache Connect to Oracle option, SHLIB_PATH must also contain $ORACLE_HOME/ lib and must not cont ain $O RACLE_HOME/li b32 . See “ORACLE_HOME environment variable” o n page 7[...]

  • Page 87

    T imesT en Installation 79 We b server configu ration The T imesT en daemon contains an embedded web server , that is used for the Cache Administrator if the Cache Connect to Oracle option is installed. If you select to enable the web server at install time, TimesT en enables it by setting the -webserver option in the ttendaemon.options file. This [...]

  • Page 88

    80 Oracle T imesT en In-Memory Database Installation Guide CGIROOT — A subdirectory of WEBRO OT where the CGI scripts are located. The path should begin and en d with a '/' on all platforms. The default is /cgi-bin/ . PERL — The path to the Perl interpreter . The path is set by the T imesT en installation scripts. Do not change the d [...]

  • Page 89

    T imesT en Installation 81 column and index defini tions. When Ti mesT en restores a table in a new data store, it also restores the table’ s indexes. Note: The ttMigra te utility cannot migrate data stores across dif ferent hardware platforms. For example, you cannot migrate a W indows data store to a Solaris data store. The release of ttMigrate[...]

  • Page 90

    82 Oracle T imesT en In-Memory Database Installation Guide % /opt/TimesTen /tt70/bin/t tMigrate -rx DSN=S alestt70 sales.dat Using the ttBulkCp utility The ttBulkCp uti lity copies table data between T imesT en data stores and ASCII files. The data files used by ttBulkCp can only con tain rows from a single table. They also do not store the table?[...]

  • Page 91

    T imesT en Installation 83 % /opt/tt60/32/ bin/ttBulkCp -o DSN=source600 able able.save % /opt/tt60/32/ bin/ttBulkCp -o DSN=source600 baker baker.sav e Next create a new data source name, sour ce_ tt70 for the T imesT en 7.0 data store, and execute the commands: % /opt/TimesTen /tt70/bin/t tIsql -connStr DSN=source_tt7 0 -f create.sql % /opt/TimesT[...]

  • Page 92

    84 Oracle T imesT en In-Memory Database Installation Guide A sample file containing definitions for the DSNs required by the T imesT en demo applicat ions is provided in /var/Tim esTen/ sys.odbc.ini , if yo ur product was installed as root. If installed by a non-root user the f ile i s located in install_dir /info/ sys.odbc.ini . Building the demo [...]

  • Page 93

    T imesT en Installation 85 • Is the T imesT en service running? T o start the service, double-click Control Panel > Administrative T ools > Services , choose the TimesT en Data Manager service, and click S tart . Building and running the JD BC demo applications Source code for a demo applicatio n is provided in the install_dir / /demo/jdbc [...]

  • Page 94

    86 Oracle T imesT en In-Memory Database Installation Guide Inst allation problems T o avoid problems during inst allation, make sure you have met all prerequisites. Using inform ation in the installation g uide and the release notes, check that: • Y ou are running a supported version of the OS. • Y ou have sufficient disk space. • On UNIX, yo[...]

  • Page 95

    87 – 3 Data S tor e Upgrades Introduction When a T imesT en data store is loaded into shared memory , many of its attributes are fixed, including size, logging options, TimesT en software release number , and the location of its checkpoint and log files on disk. This chapter describes the steps requi red to change these attributes and to upgrade [...]

  • Page 96

    88 Oracle T imesT en In-Memory Database Installation Guide backward-compatible data t ypes, see “Type specifications” on page 8 in the Oracle T imesT en In-Memory Database SQL Reference Guide . Because some of the new Oracle data types have the same names as the backward-compatible TimesT en data types, a set of aliases has been added for addre[...]

  • Page 97

    Data S tore Up gr ades 89 the same as the character set speci fied for the Oracle database that the T imesT en data store connects to. • Replication is not possible between data stores with different character sets. Because data stores created with versions of T imesT en prior to 7.0 do not h ave a data st ore character set specified, a special d[...]

  • Page 98

    90 Oracle T imesT en In-Memory Database Installation Guide Converting dat a types to Oracle dat a types Note: If you intend to use your data store with T imesT en Cache Connect to Oracle, you must convert your data types to Oracle data types. However , you will not b e able to perform an online upgrade usin g replication. T o convert the data types[...]

  • Page 99

    Data S tore Up gr ades 91 Dat a store character set conversion Beginning with T imesT en 7.0, a char acter set must be specified for each T imesT en data store usi ng the DSN attribute DatabaseCharacterSet . In some cases, you may need to change the configured data store character set as part of the upgrad e proc ess. There are two dif ferent cases[...]

  • Page 100

    92 Oracle T imesT en In-Memory Database Installation Guide 4. Load the data store from the file using ttMigrate with the -noCharsetCon version command line option. This option ensures that no character values are changed when the data is loaded into the DSN using the new character set. For example: ttMigrate -r -noCh arsetConversi on DSN=SalesDat a[...]

  • Page 101

    Data S tore Up gr ades 93 Upgrade modes T imesT en allows you to perform th ese kinds of upgrades: In-place upgrades In-place upgrades are av ailable for moving to a new patch release of T imesT en, such as moving from the first patch release of 7.0, v ersion 7.0.1.0.0, to the second patch release of 7.0, versi o n 7. 0.2.0.0. As lo ng as your T im[...]

  • Page 102

    94 Oracle T imesT en In-Memory Database Installation Guide Online upgrades with replication When upgrading to a new major rel ease of TimesT en, y ou may have a mission critical data store that needs to remain continuously availab le to your applications. Y ou can use TimesT en replicatio n to keep two copies of a data store synchronized, even when[...]

  • Page 103

    Data S tore Up gr ades 95 a Client/Server online upgrade fro m a TimesTen version prior to 6.0” on page 113 . • If you are upgrading from a version of T imesT en th at is 6.0 or above, the process is much easier . Starting with 7.0, T imesT en Server is able to talk directly to all versions of TimesT en Client fro m 6.0 onward. There is no need[...]

  • Page 104

    96 Oracle T imesT en In-Memory Database Installation Guide utility . (See "tt Admin" in Oracle T imesT en In-Memory Databa se API Refer e nce Guide .) In order to unload a data store: 1. Disconnect all applications from the data store. 2. In this example, the data store original is from the previous release. The data store upgrade is in t[...]

  • Page 105

    Data S tore Up gr ades 97 Performing an offline upgrade Y ou can do an offline upgrade by exporting the data store into an external file using either the ttMigrate or ttBackup utility , then restoring the data store with the desired changes. These update procedures require that all ap plications be disconnect ed from the dat a store and that the da[...]

  • Page 106

    98 Oracle T imesT en In-Memory Database Installation Guide Note: After ttMig rate has been used, all autorefresh cache groups in the destination data store have AUTOREFRESH ST A TE set to OFF , no matter how it was s et on the source d ata store. Reset AUT OREFRESH ST A TE to ON by using the ALTER CACHE GROUP statement. Moving to a different direct[...]

  • Page 107

    Data S tore Up gr ades 99 Note: Before mo ving a repli cated data store to another machine, you should be experienced with TimesT en replication. W e highly advise calling T imesT en customer support for help with this procedure. T o copy a data store from one system to another with the same CPU architecture and operating system: 1. Back up the dat[...]

  • Page 108

    100 Oracle T imesT en In-Memory Data base Installation Guid e Reducing dat a store size Once a data store has been define d with a particular size for the permanent partition (indicat ed by the PermSize DSN attribu te), it cannot be loaded at a smaller size, even if tables or rows are deleted. A copy of the data store made with ttBackup also has th[...]

  • Page 109

    Data S tore Upgrades 101 Note: The temporary partiti on size of a data store may be changed by simply modifying the Te m p S i z e attribu te of th e DSN, unloadin g the data store from memory , and then reconnecting to it. See “Unloading a data store” on page 95 for the steps to unload a data store from memory . Moving between 32-bit and 64-bi[...]

  • Page 110

    102 Oracle T imesT en In-Memory Data base Installation Guid e the steps outlined in “Moving between 32-bit and 64-bit data stores” on page 101 . If you need to upgrade two or more data stores that are replicating to each other , you must perform a few extra steps in order to ensure that replication will continu e to operat e during and after th[...]

  • Page 111

    Data S tore Upgrades 103 Now upgrade data store subscriber1 from release 5.1 to release 7.0. Perform the f ollowing steps: 1. On the machine subscriberhost , use the 5.1 release’ s ttAdmin ut ili ty to stop the replication daemon: ttAdmin -repS top subscribe r1 2. Use the 5.1 release’ s ttDestroy utility t o destroy data st ore subscriber1 , wh[...]

  • Page 112

    104 Oracle T imesT en In-Memory Data base Installation Guid e Performing an online upgr ade with replication In “Performing an offlin e upgrade” on page 97 we showed how to perform various maintenance operations on TimesT en data stores that require that all applications be stopped. Thi s section describes how to use the T imesT en replication [...]

  • Page 113

    Data S tore Upgrades 105 release data store using ttMigrate from the newer release, and then reconnecting all applications to the upgraded data store. Note: The ttMigrate -r -rename option, used to rename the o wner of data store tables, cannot be used with online upgrades. The general steps i n an online upgrade incl ude: • Disconnect all applic[...]

  • Page 114

    106 Oracle T imesT en In-Memory Data base Installation Guid e 2. Connect all applications to the active data store, if they are not already connected. 3. Disconnect all applicatio ns from the upgrade data store. 4. Set replication to the upgrade system to the pause state. 5. W ait for updates to propagate to the active system. 6. Stop replication. [...]

  • Page 115

    Data S tore Upgrades 107 After the above procedures have been carried out on the upgrade system, the active system can be upgraded using the same steps. Limit ations Online upgrades can be performed only on data stores for which all the user tables meet the replication requi rements. All the user tables must contain either a PRIMAR Y KEY declaratio[...]

  • Page 116

    108 Oracle T imesT en In-Memory Data base Installation Guid e Online upgrade example This section describes how to do an online upgrade of two bi- directionally replicated TimesT en data st ores, using a concrete example. W e ’ll refer to the two TimesT en systems being upgraded as the upgrade system, on which TimesT en will be upgraded alon g wi[...]

  • Page 117

    Data S tore Upgrades 109 Follow the steps listed here in the order they are presented. The online upgrade procedures are: Step Upgrad e System Active System 1. Use ttIsql to alter the replication scheme repscheme , sett ing static replication port numbers so that the data stores can talk across releases: Command> call ttR epStop; Command> ALT[...]

  • Page 118

    11 0 Oracle T imesT en In-Mem ory Database Installa tion Guide 3. W ait for all replication updates to be sent to the data store active . Y ou can verify that all updates have been sent by applying a recognizable update to a tabl e reserved for that purpose on the data store upgrade . When the update appears in the data store active , you know that[...]

  • Page 119

    Data S tore Upgrades 111 6. Use ttMigrate to back up the data store upgrade . If the data store is very large, this s tep could take a significant amount of time. If sufficient disk space is free on the /backup file system, th e following ttMigrate command can be used: ttMigrate -c DSN=upgrade /backup/upgra de.dat 7. If the ttMigrate command is suc[...]

  • Page 120

    11 2 Oracle T imesT en In-Mem ory Database Installa tion Guide 9. Use ttMigrate to load the backup created in Step 6 into a new version of the data store upgrade : ttMigrate -r "DSN=upgrad e;AutoCreate= 0" /backup/upg rade.dat If the data store is temporary ( T emporary =1), first use ttAdmin -ramLoad : ttAdmin -ram Load upgrade Note: In [...]

  • Page 121

    Data S tore Upgrades 11 3 Performing a Client/Server online upgrade from a T imesT en version prior to 6.0 Overview A user application linked with a 5.0 or later release of the T imesT en Client ODBC driver can connect to a Server DSN of a newer major 11 . U s e ttAdmin to start the replication agent on the new data store upgr ade and to begin send[...]

  • Page 122

    11 4 Oracle T imesT en In-Mem ory Database Installa tion Guide release of T i mesT en. For example, a 5.0 client can connect to a 7.0 Server DSN. Note: Applications linked to newer Ti mes T en clients cannot connect to a Server DSN of any older releases . For example, a 5.1 client cannot connect to a 5.0 Server DSN. Note: For security reasons, clie[...]

  • Page 123

    Data S tore Upgrades 11 5 The TTCONNECTINI file at the T imesT en 5.1.x client machine contains: [my_server_51 ] Network_Addre ss=my_server TCP_PORT=1510 2 Because TCP_PORT is set to the TimesT en 5.1 Server port nu mb er, the 5.1 server dynamically loads the co rrect driver for the s erver DSN. The .odbc.ini file at the T imesT en 5.1 Client machi[...]

  • Page 124

    11 6 Oracle T imesT en In-Mem ory Database Installa tion Guide Performing a Client/Server online upgrade from T imesT en versio n 6.0 and above As of T imesT en 7.0, T imesT en Server is able to talk directly to all user applications linked with TimesT en Client OD BC dri ver versi on 6.0 or higher . This makes the procedures for upgrading a TimesT[...]

  • Page 125

    Data S tore Upgrades 11 7 3. Use ttMigrat e to migrate the data store from the old version to the new version. See “Moving between 32-bit and 64-bit dat a stores” on page 101 for an example of this procedure. 4. Start the new version of T imesT en Server , if you have not already . The client applications now have acces s to the upgraded data s[...]

  • Page 126

    11 8 Oracle T imesT en In-Mem ory Database Installa tion Guide These tables do not take up much space and are helpful when debugging upgrade problems. However, you can drop these tables if you do not experience problems with replication after running ttMigrate . Example 3.1 For example, after two migration s, th e data store might contain tables wh[...]

  • Page 127

    11 9 Index Index Numerics 64-bit platforms, supported 19 A Access Control authentication 13 Cache Connect 8 Client/Server 8 daemon home directory 12 daemon port 13 directories and files 12 GroupRestrict 13 instance home directory 12 introduction 7 limitations 7 password file 12 privileges 13 Replication 8 security 7 TimesTen instan ce administrator[...]

  • Page 128

    120 Oracle T imesT en In-Memory Database Installation Guide F files .odbc.ini 39 documentation 85 driver, verifying installation on Windows 42 enabling large files 27 header 73 makefiles 84 ODBCINI environment variable 75, 76 online help 73 G GroupRestrict Access Control 13 H help online 73 HP-UX 19, 21, 22 installat ion 49 supported environment 19[...]

  • Page 129

    Index 121 to a new patch release 96 N names instances 23 non-root installation limitations 7 prerequisites 37 O ODBC installation 73 ODBCINI file environment variable 75, 76 off-line upgrade 93, 97 on-line upgrade 94 limitations 107 requirements 107 online documentation 85 online help 73 Oracle Connect Administrator web server configuratio n 79 wor[...]

  • Page 130

    122 Oracle T imesT en In-Memory Database Installation Guide TimesTen daemon on AIX 61 TimesTen inst ance administrator 9 TimesTen instance users external user 10 internal user 10 overview 10 TimesTen registry creating 38 TimesTen Server on AIX 61 on HP-UX 53 on Solaris 48, 69 on Windows 43 timestend process 48, 65, 69 timestend.pid file 48, 53, 60,[...]