Oracle Audio Technologies B31679-01 Manuale Utente

Oracle TimesTen In-Memory Database Installation GuideRelease 7.0 B31679-01For last-minute updates, see the TimesTen release no

2 Oracle TimesTen In-Memory Database Installation GuideBackground readingFor a Java reference, see:• Horstmann, Cay and Gary Cornell. Core Java(TM) 2,

92 Oracle TimesTen In-Memory Database Installation Guide4. Load the data store from the file using ttMigrate with the -noCharsetConversion command lin

Data Store Upgrades 93Upgrade modesTimesTen allows you to perform these kinds of upgrades:In-place upgradesIn-place upgrades are available for moving

94 Oracle TimesTen In-Memory Database Installation GuideOnline upgrades with replicationWhen upgrading to a new major release of TimesTen, you may hav

Data Store Upgrades 95a Client/Server online upgrade from a TimesTen version prior to 6.0” on page 113.• If you are upgrading from a version of TimesT

96 Oracle TimesTen In-Memory Database Installation Guideutility. (See "ttAdmin" in Oracle TimesTen In-Memory Database API Reference Guide.)

Data Store Upgrades 97Performing an offline upgradeYou can do an offline upgrade by exporting the data store into an external file using either the tt

98 Oracle TimesTen In-Memory Database Installation GuideNote: After ttMigrate has been used, all autorefresh cache groups in the destination data stor

Data Store Upgrades 99Note: Before moving a replicated data store to another machine, you should be experienced with TimesTen replication. We highly a

100 Oracle TimesTen In-Memory Database Installation GuideReducing data store sizeOnce a data store has been defined with a particular size for the per

Data Store Upgrades 101Note: The temporary partition size of a data store may be changed by simply modifying the TempSize attribute of the DSN, unload

About this Guide 3• Microsoft ODBC 2.0 Programmer’s Reference and SDK Guide, included online in PDF format, provides information on ODBC for UNIX deve

102 Oracle TimesTen In-Memory Database Installation Guidethe steps outlined in “Moving between 32-bit and 64-bit data stores” on page 101.If you need

Data Store Upgrades 103Now upgrade data store subscriber1 from release 5.1 to release 7.0. Perform the following steps:1. On the machine subscriberhos

104 Oracle TimesTen In-Memory Database Installation GuidePerforming an online upgrade with replicationIn “Performing an offline upgrade” on page 97 we

Data Store Upgrades 105release data store using ttMigrate from the newer release, and then reconnecting all applications to the upgraded data store.No

106 Oracle TimesTen In-Memory Database Installation Guide2. Connect all applications to the active data store, if they are not already connected.3.

Data Store Upgrades 107After the above procedures have been carried out on the upgrade system, the active system can be upgraded using the same steps.

108 Oracle TimesTen In-Memory Database Installation GuideOnline upgrade exampleThis section describes how to do an online upgrade of two bi-directiona

Data Store Upgrades 109Follow the steps listed here in the order they are presented. The online upgrade procedures are:Step Upgrade System Active Syst

110 Oracle TimesTen In-Memory Database Installation Guide3. Wait for all replication updates to be sent to the data store active. You can verify that

Data Store Upgrades 1116. Use ttMigrate to back up the data store upgrade. If the data store is very large, this step could take a significant amount

4 Oracle TimesTen In-Memory Database Installation GuideTimesTen documentation uses these conventions in command line examples and descriptions:TimesTe

112 Oracle TimesTen In-Memory Database Installation Guide9. Use ttMigrate to load the backup created in Step 6 into a new version of the data store up

Data Store Upgrades 113Performing a Client/Server online upgrade from a TimesTen version prior to 6.0OverviewA user application linked with a 5.0 or l

114 Oracle TimesTen In-Memory Database Installation Guiderelease of TimesTen. For example, a 5.0 client can connect to a 7.0 Server DSN.Note: Applicat

Data Store Upgrades 115The TTCONNECTINI file at the TimesTen 5.1.x client machine contains:[my_server_51]Network_Address=my_serverTCP_PORT=15102Becaus

116 Oracle TimesTen In-Memory Database Installation GuidePerforming a Client/Server online upgrade from TimesTen version 6.0 and aboveAs of TimesTen 7

Data Store Upgrades 1173. Use ttMigrate to migrate the data store from the old version to the new version. See “Moving between 32-bit and 64-bit data

118 Oracle TimesTen In-Memory Database Installation GuideThese tables do not take up much space and are helpful when debugging upgrade problems. Howev

119IndexIndexNumerics64-bit platforms, supported 19AAccess Controlauthentication 13Cache Connect 8Client/Server 8daemon home directory 12daemon port 1

120 Oracle TimesTen In-Memory Database Installation GuideFfiles.odbc.ini 39documentation 85driver, verifying installation on Windows42enabling large f

Index 121to a new patch release 96Nnamesinstances23non-root installationlimitations 7prerequisites 37OODBC installation 73ODBCINI fileenvironment vari

About this Guide 5Technical SupportFor information about obtaining technical support for TimesTen products, go to the following Web address:http://www

122 Oracle TimesTen In-Memory Database Installation GuideTimesTen daemonon AIX 61TimesTen instance administrator 9TimesTen instance usersexternal user

6 Oracle TimesTen In-Memory Database Installation Guide

71Access ControlIntroductionAccess ControlWith TimesTen you can optionally install a layer of internal security, which throughout the TimesTen documen

8 Oracle TimesTen In-Memory Database Installation GuideCache ConnectFor Cache Connect, the TimesTen internal user must match the Oracle user. External

Access Control 9% ttDaemonAdmin -startTo stop an instance:% ttDaemonAdmin -stopInstance data storeA DSN for a minimal instance-wide data store is defi

10 Oracle TimesTen In-Memory Database Installation GuideNote: All examples in the TimesTen documentation set use the name timesten to represent the in

Access Control 11automatically converts the external user name to upper case, rendering it case insensitive. The PWDCrypt attribute allows you to encr

Copyright ©1996, 2007, Oracle. All rights reserved.ALL SOFTWARE AND DOCUMENTATION (WHETHER IN HARD COPY OR ELECTRONIC FORM) ENCLOSED AND ON THE COMPAC

12 Oracle TimesTen In-Memory Database Installation GuideInstallation directories, files and the daemon portInstallation of TimesTen must be performed

Access Control 13been selected. If this file is missing, an error occurs after Access Control is enabled. This file is readable and writable only by t

14 Oracle TimesTen In-Memory Database Installation GuideMaintaining users and privilegesTimesTen allows the instance administrator to create, drop and

Access Control 15All other changes to the TimesTen instance can only be made by uninstalling and re-installing the same or a differently release of Ti

16 Oracle TimesTen In-Memory Database Installation Guide

172TimesTen Installation This chapter contains configuration information that you will need to review before installing TimesTen on your system, in th

18 Oracle TimesTen In-Memory Database Installation Guide• Building and running the demo applications• Viewing the online documentationFinally, this ch

TimesTen Installation 19Platforms and configurationsPlatform supportTimes Ten Data Manager and TimesTen Client/Server are supported in the following e

20 Oracle TimesTen In-Memory Database Installation GuideJDK supportNote: TimesTen supports the Sun JVM and the BEA WebLogic JRockit JVM for Linux and

TimesTen Installation 21Client/Server configurationsA TimesTen client on any supported platform can connect to a TimesTen server on any platform where

iiiContentsAbout this GuideTimesTen documentation . . . . . . . . . . . . . . . . . . . . . 1Background rea

22 Oracle TimesTen In-Memory Database Installation GuideCache Connect is supported on the 32-bit and 64-bit platforms specified in this table:Replicat

TimesTen Installation 23Installation instancesOn UNIX, you can install more than one instance of any TimesTen release. By default, the instance name f

24 Oracle TimesTen In-Memory Database Installation GuideChoosing the appropriate TimesTen componentsTimesTen allows you to select the components of Ti

TimesTen Installation 25Installation prerequisites Before installing TimesTen, make sure the appropriate requirements are met for your operating syste

26 Oracle TimesTen In-Memory Database Installation GuideOther Client/ServerSettingsThe maximum number of concurrent IPC connections to a TimesTen Serv

TimesTen Installation 273. Scroll down the list of parameters to semmns and change its value to a minimum of 4096 or greater.4. For HP-UX 11i systems,

28 Oracle TimesTen In-Memory Database Installation GuideThe C development tools are required if native development will be done on the machine.Large p

TimesTen Installation 29When TimesTen uses large pages, the HugePages_Free file in /proc/meminfo changes.Semaphores To view existing kernel parameter

30 Oracle TimesTen In-Memory Database Installation GuideFor Red Hat 3.0, install:compat-libstdc++-7.3-2.96.123For Red Hat 4.0, install:compat-libstdc+

TimesTen Installation 31ryps3# modload /kernel/sys/semsysryps3# modload /kernel/sys/shmsysIncreasenumber ofsemaphoresFor Solaris 10 systems, the defau

iv Oracle TimesTen In-Memory Database Installation GuidePlatform support . . . . . . . . . . . . . . . . . . .

32 Oracle TimesTen In-Memory Database Installation Guideaccess 12 data stores, add the following line to /etc/system and reboot before using TimesTen:

TimesTen Installation 33Replication For replication, TCP send and receive buffers should be increased to a minimum of 512KB. You may need to embed the

34 Oracle TimesTen In-Memory Database Installation GuideTo increase the maximum data segment (malloc space) a process may use, change the kernel value

TimesTen Installation 35The temporary directory is operating system-dependent. Usually it is located in these directories:• On Windows, C:\Documents a

36 Oracle TimesTen In-Memory Database Installation Guidesegments are ownership and permissions restricted to that of a particular operating system gro

TimesTen Installation 37Prerequisites for non-root installations on UNIX systemsAs discussed in Chapter 1, “Access Control,” on UNIX systems, you can

38 Oracle TimesTen In-Memory Database Installation Guide# setprivgrp timesten MLOCKThe getprivgrp command can be used to check the privileges of a gro

TimesTen Installation 39This step is only necessary if you want the TimesTen instance to start each time the machine is rebooted.Note: If you install

40 Oracle TimesTen In-Memory Database Installation GuideSee the TimesTen Developer’s Guide for more information about using TimesTen.Installing TimesT

TimesTen Installation 41By default, Access Control is not enabled. See Chapter 1, “Access Control” for more details.Custom setup also lets you choose

Contents vInstalling TimesTen on HP-UX Memory Windows . . . . . . . . . . . 54Use a separate instance for each memory window .

42 Oracle TimesTen In-Memory Database Installation GuideVerifying installationTo verify that TimesTen has been properly installed, check that the driv

TimesTen Installation 43The ODBC Administrator attempts to connect to the TimesTen Server and display a message to let you know if it was successful.

44 Oracle TimesTen In-Memory Database Installation Guide1. On the Windows desktop, choose Start > Settings > Control Panel > Administrative T

TimesTen Installation 45Installing TimesTenTo install TimesTen on your Solaris system, follow these steps: 1. Log in as the TimesTen instance administ

46 Oracle TimesTen In-Memory Database Installation GuideIn addition, setup.sh also accepts these options:The CD contains tar files of TimesTen. If the

TimesTen Installation 47• On 64-bit systems, prompts you to install one of the following releases:– 32-bit (default)– 64-bit• Prompts you to:– Install

48 Oracle TimesTen In-Memory Database Installation Guide• Copies the daemon scripts into the appropriate directories.• If installed by user root, conf

TimesTen Installation 49To stop the daemon manually, use the utility command: ttDaemonAdmin -stopTo start the daemon manually, use the utility command

50 Oracle TimesTen In-Memory Database Installation Guide# mkdir /cdromMount the CD-ROM, as follows:• If your system is configured to mount the CD-ROM

TimesTen Installation 51Specify the option at the end, outside the quotation marks. In addition, setup.sh also accepts these options:The CD contains t

vi Oracle TimesTen In-Memory Database Installation Guide3 Data Store UpgradesIntroduction . . . . . . . . . . . . . . .

52 Oracle TimesTen In-Memory Database Installation Guide• On 64-bit systems, prompts you to install one of the following releases:– 32-bit (default)–

TimesTen Installation 53• Copies the daemon scripts into the appropriate directories.• If installed by user root, configures the system to start the d

54 Oracle TimesTen In-Memory Database Installation GuideIf you installed TimesTen as root, the daemon startup file on HP-UX is: /etc/rc.config.d/tt_TT

TimesTen Installation 55<instance> command to determine which port is being used by the instance.Using TimesTen in a memory windowIn order to us

56 Oracle TimesTen In-Memory Database Installation Guideapplication SHMEM_MAGIC may result with an Invalid Argument error (EINVAL, errno=22) when atte

TimesTen Installation 57• Not enough core (ENOMEM, errno=12) indicates a problem allocating the requested amount of shared memory. Can you attach with

58 Oracle TimesTen In-Memory Database Installation Guide# mount /usr/cdrom/TimesTen7.0After the CD-ROM setup is complete, you can install TimesTen as

TimesTen Installation 59The CD contains tar files of TimesTen. If the setup script cannot find the tar files to extract from, it prompts you for their

60 Oracle TimesTen In-Memory Database Installation Guide– Data Manager only– Client only• Prompts you for the location of your TimesTen installation

TimesTen Installation 61Working with the TimesTen daemon and serverThe TimesTen daemon starts automatically when the operating system is booted and op

Contents viiIndex

62 Oracle TimesTen In-Memory Database Installation GuideInstalling TimesTen on Linux systems This section discusses installation and some related topi

TimesTen Installation 63removes all files it had installed. In addition, setup.sh also accepts these options:The CD contains tar files of TimesTen. If

64 Oracle TimesTen In-Memory Database Installation Guideminor version numbers of the TimesTen release must match exactly.)– Display information about

TimesTen Installation 65• If there are other instances of the same patch release of TimesTen installed on the same machine, prompts you to provide a u

66 Oracle TimesTen In-Memory Database Installation Guide1. Log in as the TimesTen instance administrator if you installed as non-root, or log in as us

TimesTen Installation 67• You can run the setup script with the option -install or -uninstall (default is -install). When you use the -uninstall optio

68 Oracle TimesTen In-Memory Database Installation Guiderelease are assigned default answers and may produce unexpected results when batch files from

TimesTen Installation 69• Copies the daemon scripts into the appropriate directories.• If installed by user root, configures the system to start the d

70 Oracle TimesTen In-Memory Database Installation GuideTo start the daemon manually, use the utility command: ttDaemonAdmin -startUninstalling TimesT

TimesTen Installation 71Note: The Cache Administrator will not work if it is running on a Windows machine with the Windows Firewall ON (this is the us

viii Oracle TimesTen In-Memory Database Installation Guide

72 Oracle TimesTen In-Memory Database Installation Guide4. Click Next or Previous to view additional messages. Note: You can also use the ttDaemonLog

TimesTen Installation 73*.debug /var/adm/syslog/syslog.loguser.err; user.warn; user.info /var/adm/messagesTo make changes to /etc/syslog.conf, you mu

74 Oracle TimesTen In-Memory Database Installation GuideEnvironment modificationsThis section describes various environment variables that you may nee

TimesTen Installation 75PATH environment variableTimesTen provides utilities for managing and debugging TimesTen applications. To make these utilities

76 Oracle TimesTen In-Memory Database Installation Guideapplication. If TimesTen cannot locate a user DSN file, the system DSN file located in /var/Ti

TimesTen Installation 77CLASSPATH environment variableOn Windows and UNIX platforms, add install_dir/demo and install_dir/lib/ttjdbcjdk_version.jar. t

78 Oracle TimesTen In-Memory Database Installation GuideOn HP-UX 64-bit systems, add install_dir/lib to the LD_LIBRARY_PATH environment variable. If y

TimesTen Installation 79Web server configurationThe TimesTen daemon contains an embedded web server, that is used for the Cache Administrator if the C

80 Oracle TimesTen In-Memory Database Installation GuideCGIROOT — A subdirectory of WEBROOT where the CGI scripts are located. The path should begin a

TimesTen Installation 81column and index definitions. When TimesTen restores a table in a new data store, it also restores the table’s indexes.Note: T

1About this GuideThis document contains all necessary information for installing the Oracle TimesTen® In-Memory Database (TimesTen) Data Manager, Clie

82 Oracle TimesTen In-Memory Database Installation Guide% /opt/TimesTen/tt70/bin/ttMigrate -rx DSN=Salestt70 sales.datUsing the ttBulkCp utilityThe tt

TimesTen Installation 83% /opt/tt60/32/bin/ttBulkCp -oDSN=source600 able able.save% /opt/tt60/32/bin/ttBulkCp -oDSN=source600 baker baker.saveNext cre

84 Oracle TimesTen In-Memory Database Installation GuideA sample file containing definitions for the DSNs required by the TimesTen demo applications i

TimesTen Installation 85• Is the TimesTen service running? To start the service, double-click Control Panel > Administrative Tools > Services, c

86 Oracle TimesTen In-Memory Database Installation GuideInstallation problemsTo avoid problems during installation, make sure you have met all prerequ

87–3Data Store Upgrades IntroductionWhen a TimesTen data store is loaded into shared memory, many of its attributes are fixed, including size, logging

88 Oracle TimesTen In-Memory Database Installation Guidebackward-compatible data types, see “Type specifications” on page 8 in the Oracle TimesTen In-

Data Store Upgrades 89the same as the character set specified for the Oracle database that the TimesTen data store connects to.• Replication is not po

90 Oracle TimesTen In-Memory Database Installation GuideConverting data types to Oracle data typesNote: If you intend to use your data store with Time

Data Store Upgrades 91Data store character set conversionBeginning with TimesTen 7.0, a character set must be specified for each TimesTen data store u