Instruction/ maintenance manual of the product B31679-01 Oracle Audio Technologies
Go to page of 130
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 .
iii Contents About this Guide T imesT en documentation . . . . . . . . . . . . . . . . . . . . . 1 Background reading . . . . . . . . . . . . . . . . . . . . . . . 2 Conventions used in this guide . . . . . . . . . . . . . . . . . . . 3 T echnical Support .
iv Oracle T imesT en In-Memory Database Installation Guide Platform support . . . . . . . . . . . . . . . . . . . . . . . 19 JDK support . . . . . . . . . . . . . . . . . . . . . . . . . 20 Client/Server configurations . . . . . . . . . . . . . . . . .
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 .
vi Oracle T imesT en In-Memory Database Installation Guide 3 Dat a Store Upgrades Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . 87 Data store compatibility . . . . . . . . . . . . . . . . . . . . 87 Data type compatibility . . . . .
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.
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).
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 .
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...
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 .
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.
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 .
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.
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 .
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 passw.
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.
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.
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.
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 nfiguration.
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 hel.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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).
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.
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.
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.
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.
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 .
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.
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 .
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.
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.
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 , y.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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 • .
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.
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.
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.
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.
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.
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 .
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.
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 # .
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.
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 .
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.
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.
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.
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.
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 .
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.
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.
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.
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.
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 .
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.
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 .
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 .
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.
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.
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 .
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.
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 .
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.
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 .
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.
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.
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.
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.
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 .
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.
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.
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 .
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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 .
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.
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.
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.
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.
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.
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.
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.
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.
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 .
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.
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.
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 .
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 .
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.
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.
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 .
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 .
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 GroupRestri.
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 en.
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.
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.
An important point after buying a device Oracle Audio Technologies B31679-01 (or even before the purchase) is to read its user manual. We should do this for several simple reasons:
If you have not bought Oracle Audio Technologies B31679-01 yet, this is a good time to familiarize yourself with the basic data on the product. First of all view first pages of the manual, you can find above. You should find there the most important technical data Oracle Audio Technologies B31679-01 - thus you can check whether the hardware meets your expectations. When delving into next pages of the user manual, Oracle Audio Technologies B31679-01 you will learn all the available features of the product, as well as information on its operation. The information that you get Oracle Audio Technologies B31679-01 will certainly help you make a decision on the purchase.
If you already are a holder of Oracle Audio Technologies B31679-01, but have not read the manual yet, you should do it for the reasons described above. You will learn then if you properly used the available features, and whether you have not made any mistakes, which can shorten the lifetime Oracle Audio Technologies B31679-01.
However, one of the most important roles played by the user manual is to help in solving problems with Oracle Audio Technologies B31679-01. Almost always you will find there Troubleshooting, which are the most frequently occurring failures and malfunctions of the device Oracle Audio Technologies B31679-01 along with tips on how to solve them. Even if you fail to solve the problem, the manual will show you a further procedure – contact to the customer service center or the nearest service center
