Oracle Audio Technologies B31679-01 manual

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.[...]

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 [...]

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 . . . . . . . [...]

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[...]

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. . . . . . . . . . . . . . . . . . . . . .[...]

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 . . . . . . . . . . . . . . . . . . . . [...]

Contents vii Index[...]

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

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[...]

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[...]

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 [...]

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 [...]

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[...]

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

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[...]

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 [...]

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[...]

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[...]

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[...]

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[...]

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[...]

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 [...]

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 .)[...]

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

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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, [...]

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[...]

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[...]

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[...]

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[...]

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 [...]

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:[...]

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[...]

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[...]

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[...]

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[...]

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 = [...]

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[...]

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 .[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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 [...]

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[...]

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[...]

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[...]

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[...]

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 [...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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 `[...]

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 [...]

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[...]

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 [...]

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[...]

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[...]

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, [...]

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[...]

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[...]

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 [...]

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[...]

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[...]

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[...]

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 ?[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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 [...]

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 [...]

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[...]

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?[...]

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[...]

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 [...]

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 [...]

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[...]

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 [...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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 [...]

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[...]

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. [...]

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[...]

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[...]

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[...]

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[...]

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[...]

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 [...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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[...]

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,[...]