Oracle B31679-01 Installation Manual Download

Page: 1 / 130

Oracle TimesTen

In-Memory Database

Installation Guide

Release 7.0

B31679-01

For last-minute updates, see the TimesTen release notes.

Summary of Contents for B31679-01

Page 1: ...Oracle TimesTen In Memory Database Installation Guide Release 7 0 B31679 01 For last minute updates see the TimesTen release notes ...

Page 2: ...es may be trademarks of their respective owners The Programs which include both the software and documentation contain proprietary information they are provided under a license agreement containing restrictions on use and disclosure and are also protected by copyright patent and other intellectual and industrial property laws Reverse engineering disassembly or decompilation of the Programs except ...

Page 3: ... TimesTen instance administrator 9 TimesTen instance users 10 Before installation 11 TimesTen administrators group 11 Instance registry directory 11 Installation directories files and the daemon port 12 Installation directories 12 Instance home directory 12 Daemon home directory 12 Password file 12 Daemon port 13 Authenticating users and privileges 13 Privileges 13 GroupRestrict 13 Maintaining use...

Page 4: ...tion prerequisites for non root installs 37 Create the TimesTen instance administrators group 37 Create the TimesTen registry 38 Post installation requirements 38 Configure the syslog messages 39 Changing the daemon port number on UNIX 39 UNIX libraries 39 Installing TimesTen on Windows systems 40 Installing TimesTen 40 Installing TimesTen in silent mode 41 Verifying installation 42 Verifying Time...

Page 5: ...ational messages on Windows systems 71 Informational messages on UNIX systems 72 Incremental install and uninstall of Cache Connect 73 ODBC installation 73 Environment modifications 74 PATH environment variable 75 ODBCINI environment variable 75 SYSODBCINI environment variable 76 SYSTTCONNECTINI environment variable 76 CLASSPATH environment variable 77 ORACLE_HOME environment variable 77 Shared li...

Page 6: ...e upgrade 95 Unloading a data store 95 Moving to a new patch release of TimesTen 96 Performing an offline upgrade 97 Moving to a different directory 98 Moving to a different machine 98 Reducing data store size 100 Moving between 32 bit and 64 bit data stores 101 Moving to a different major release of TimesTen 101 Performing an online upgrade with replication 104 Overview 104 Limitations 107 Requir...

Page 7: ...Contents vii Index ...

Page 8: ...viii Oracle TimesTen In Memory Database Installation Guide ...

Page 9: ...e TimesTen In Memory Database Installation Guide Contains information needed to install and configure TimesTen on all supported platforms Oracle TimesTen In Memory Database Introduction Describes all the available features in the Oracle TimesTen In Memory Database Oracle TimesTen In Memory Database Operations Guide Provides information on configuring TimesTen and using the ttIsql utility to manage...

Page 10: ...sages and information on using SNMP Traps with TimesTen Oracle TimesTen In Memory Database TTClasses Guide Describes how to use the TTClasses C API to use the features available in TimesTen to develop and implement applications TimesTen to TimesTen Replication Guide Provides information to help you understand how TimesTen Replication works and step by step instructions and examples that show how t...

Page 11: ...he Unicode Standard Version 5 0 Addison Wesley Professional 2006 The Unicode Consortium Home Page at http www unicode org Conventions used in this guide TimesTen supports multiple platforms Unless otherwise indicated the information in this guide applies to all supported platforms The term Windows refers to Windows 2000 Windows XP and Windows Server 2003 The term UNIX refers to Solaris Linux HP UX...

Page 12: ...e percent sign indicates the UNIX shell prompt The number or pound sign indicates the UNIX root prompt If you see It means install_dir The path that represents the directory where the current release of TimesTen is installed TTinstance The instance name for your specific installation of TimesTen Each installation of TimesTen must be identified at install time with a unique alphanumeric instance na...

Page 13: ... www oracle com support contact html timesten A sample name for the TimesTen instance administrator You can use any legal user name as the TimesTen administrator On Windows the TimesTen instance administrator must be a member of the Administrators group Each TimesTen instance can have a unique instance administrator name DSN The data source name ...

Page 14: ...6 Oracle TimesTen In Memory Database Installation Guide ...

Page 15: ...e Access Control when you install TimesTen You can also choose to enable it after installation by using the ttmodinstall utility See Enabling Access Control after installation on UNIX on page 14 Access Control cannot be disabled after installation of TimesTen You must uninstall and re install TimesTen if you want to disable Access Control The instance administrator owns all files in the installati...

Page 16: ... Access Control enabled the server s Authenticate attribute must be enabled To use Access Control with Client Server applications when the user is identified externally the Client and the Server processes must be on the same machine When Access Control is enabled remote Client Server access is only supported with TimesTen internal users TimesTen ignores the values of UID PWD and PWDCrypt if specif...

Page 17: ... from the daemon and has special access restrictions placed on it Any user can connect to the instance data store to change their own password However users other than the instance administrator have only SELECT privileges on the instance data store TimesTen users TimesTen instance administrator The owner of a TimesTen installation is the TimesTen instance administrator Only a member of the TimesT...

Page 18: ...n passwords Instance users may be internal user names or external user names Internal user A user name that has been defined within the TimesTen instance is referred to as an internal user It has no significance outside of the particular instance of TimesTen in which it was defined Internal users are authenticated by the TimesTen instance See CREATE USER in the Oracle TimesTen In Memory Database S...

Page 19: ...t that a group named timesten be created specifically for this purpose Create the TimesTen instance administrators group on page 37 The member of the TimesTen administrators group who installs the TimesTen instance becomes the TimesTen instance administrator for that instance Instance registry directory TimesTen maintains a registry of all TimesTen instances installed on a given machine The instan...

Page 20: ...uggests the directory pattern as used in previous releases of TimesTen C TimesTen tt70 The TimesTen documentation refers to the installation directory as install_dir Daemon home directory The home or current working directory of the running the main TimesTen daemon is known as the daemon home directory This directory must be owned by the instance administrator with rwxr xr x permissions on UNIX sy...

Page 21: ...Is XLA operations utilities procedures and SQL operations require user authentication For details on each operation see the specific chapters of the Oracle TimesTen In Memory Database API Reference Guide and the Oracle TimesTen In Memory Database Operations Guide All TimesTen utilities prompt for a password if needed See Chapter 2 Utilities in the Oracle TimesTen In Memory Database API Reference G...

Page 22: ...nvironment within a different instance Enabling Access Control after installation on UNIX On UNIX the ttmodinstall utility allows the instance administrator to enable Access Control if it was not enabled at install time If you have not stopped the TimesTen daemon before using ttmodinstall the utility stops the daemon before changing the port number After the port change the daemon is automatically...

Page 23: ...hanges to the TimesTen instance can only be made by uninstalling and re installing the same or a differently release of TimesTen See Changing the daemon port number on UNIX on page 39 and ORACLE_HOME environment variable on page 77 ...

Page 24: ...16 Oracle TimesTen In Memory Database Installation Guide ...

Page 25: ...ur platform Installing TimesTen on Windows systems Installing TimesTen on Solaris systems Installing TimesTen on HP UX systems Installing TimesTen on HP UX Memory Windows Installing TimesTen on AIX systems Installing TimesTen on Linux systems Installing TimesTen on Tru64 UNIX systems This chapter also contains information to help you configure TimesTen after installation work with the demo applica...

Page 26: ...tallation Guide Building and running the demo applications Viewing the online documentation Finally this chapter contains information that helps you troubleshoot any problems that may arise during the installation process Installation problems ...

Page 27: ...arc CPUs Yes Yes SuSE LINUX Enterprise Server 9 and 10 for Intel IA 32 and EM64T and AMD64 CPUs Yes Yes SuSE LINUX Enterprise Server 10 for Itanium2 CPUs Yes Red Hat Enterprise Linux 3 and 4 for Intel Itanium2 CPUs Yes Red Hat Enterprise Linux 3 and 4 for Intel IA 32 and EM64T and AMD64 CPUs Yes Yes MontaVista Linux Carrier Grade Edition Release 4 0 for Intel IA 32 and EM64T and AMD64 CPUs Yes Yes...

Page 28: ...it and 64 bit Yes 32 bit and 64 bit Yes 32 bit and 64 bit Solaris 8 9 and 10 for UltraSparc CPUs Yes 32 bit and 64 bit Yes 32 bit and 64 bit Yes 64 bit only SuSE LINUX Enterprise Server 9 and 10 for Intel IA 32 and EM64T and AMD64 CPUs Yes 32 bit and 64 bit Yes 32 bit and 64 bit Yes 32 bit and 64 bit SuSE LINUX Enterprise Server 10 for Itanium2 CPUs Yes Yes Red Hat Enterprise Linux 3 and 4 for Int...

Page 29: ...en Client and Server in the Oracle TimesTen In Memory Database Operations Guide Cache Connect to Oracle TimesTen Cache Connect to Oracle allows you to cache Oracle Database data in TimesTen The following Oracle releases are supported with this option Oracle Database 10g Release 2 Oracle 10 2 0 1 0 or above Oracle Database 10g Release 1 Oracle 10 1 0 5 0 or above Oracle Database 9i Release 2 Oracle...

Page 30: ... AMD64 CPUs Yes Yes Solaris 10 for AMD64 CPUs systems Yes Solaris 8 9 and 10 for UltraSparc CPUs Yes Yes SuSE LINUX Enterprise Server 9 and 10 for Intel IA 32 EM64T and AMD64 CPUs Yes Yes SuSE LINUX Enterprise Server 10 for Itanium2 CPUs Yes Red Hat Enterprise Linux 3 and 4 running on Intel Itanium2 processors Yes Red Hat Enterprise Linux 3 and 4 for Intel IA 32 and EM64T and AMD64 CPUs Yes Yes HP...

Page 31: ...es Note On Windows you can only install one instance of any major and minor release of TimesTen The TimesTen installation script does not prompt you to supply an instance name Instance names The instance name is case insensitive and can have up to 255 characters The name must be NON NULL and can include underscores _ or period but no other special characters You can retrieve information about the ...

Page 32: ...wing components TimesTen Data Manager TimesTen Client and or TimesTen Server Components Description TimesTen Client Installs the TimesTen Client only No other TimesTen components are installed on the machine Use this installation to allow the TimesTen Client to access the TimesTen Server on a remote machine TimesTen Data Manager Installs the TimesTen Data Manager only Use this installation to run ...

Page 33: ...ngs for Replication This section outlines some of the changes that may need to be made on any UNIX system It is followed by sections that describe changes required for each specific UNIX platform on which TimesTen is supported Semaphores TimesTen consumes 1 SEMMNI per active data store plus 1 additional SEMMNI per TimesTen instance where Client Server communication is done through shared memory Fo...

Page 34: ...lication For replication TCP send and receive buffers should be increased to a minimum of 512KB You may need to embed the following commands into a script that can be run at system boot time usr sbin no p o tcp_recvspace 524288 usr sbin no p o tcp_sendspace 524288 HP UX Semaphores On HP UX systems to connect to more than 2 data stores simultaneously you must increase the value of the kernel parame...

Page 35: ...lt HP UX supports files that are no greater than 2GB in size To enable large files create the filesystems using newfs with the o largefiles option Use the command usr sbin fsadm F hfs o largefiles device_name For example usr sbin fsadm F hfs o largefiles dev vg02 rlvol1 Replication For replication TCP send and receive buffers should be increased to a minimum of 512KB You may need to embed the foll...

Page 36: ...t proc meminfo The following output from this command would indicate that you have 16 large pages each of the size 256MB for a total of 4GB HugePages_Total 16 HugePages_Free 16 Hugepagesize 262144 kB Note Since large pages must be allocated on a contiguous memory space the actual large page size allocated may be smaller than requested Also the large page size itself is not configurable The value o...

Page 37: ...red memory size without rebooting use sbin sysctl w kernel shmmax 2147483648 If you have your kernel configured with the proc file system and it is mounted then the current maximum shared memory segment size in bytes can be viewed by the following command cat proc sys kernel shmmax You can also change this value by the following command echo 2147483648 proc sys kernel shmmax This command has the s...

Page 38: ...04 sbin sysctl w net ipv4 tcp_window_scaling 1 Cache Connect For Cache Connect TCP send and receive buffers should be increased to even greater values You may need to embed the following commands into a script that can be run at system boot time sbin sysctl w net ipv4 tcp_rmem 4096 4194304 4194304 sbin sysctl w net ipv4 tcp_wmem 98304 4194304 4194304 sbin sysctl w net ipv4 tcp_mem 98304 4194304 41...

Page 39: ...semsys seminfo_semmni 20 set semsys seminfo_semmsl 512 set semsys seminfo_semmns 2000 set semsys seminfo_semmnu 2000 Note The values in this step are the minimum number of required semaphores You can increase these numbers as needed You can use the following formula as a guide although in practice SEMMNS and SEMMNU can be much less than SEMMNI SEMMSL because not every program in the system needs s...

Page 40: ... size Set this value high enough to support the largest shared memory segment needed Large data stores If you keep data stores on a Solaris UFS file system and are using transaction consistent checkpoints you may need to change the settings of some kernel parameters to get the best performance for your checkpoints The Solaris UFS Throttle algorithm causes processes that write a single large file t...

Page 41: ...n above the default We recommend that you increase the number of semaphores 1 Log in as user root 2 To view the current limits use sysconfig q ipc This command displays all the parameters of the IPC subsystem 3 If the broadcast_wakeup semaphore parameter exists on your system it must be set to one sem_broadcast_wakeup 1 4 Run the Tru64 UNIX dxkerneltuner dxkerneltuner 5 Double click IPC 6 Scroll d...

Page 42: ...connections On Tru64 UNIX to have more than 6 ShmIpc enabled Client DSN connections per process you must make changes to the SHMSEG kernel parameter Kernel parameters can be changed with either the dxkerneltuner interface or the sysconfigdb command Replication For replication TCP send and receive buffers should be increased to a minimum of 512KB You may need to embed the following commands into a ...

Page 43: ...ption of TimesTen you must have at least a client installation of Oracle Database 9i or 10g on the machine where you are installing TimesTen Oracle client shared libraries are required in order to cache Oracle data in TimesTen by Cache Connect to Oracle You must have Oracle Database 9i client or Oracle Database 10g installed You also must have the ORACLE_HOME environment variable defined before ru...

Page 44: ...stallation Guide segments are ownership and permissions restricted to that of a particular operating system group This mode only works if TimesTen is installed and running as root See the Oracle TimesTen In Memory Database API Reference Guide ...

Page 45: ... by a non root user whether they use Access Control or not These procedures are also required for all installations that will enable Access Control at install time Create the TimesTen instance administrators group Before installing TimesTen you must create the instance administrators group 1 Log in as root 2 Create an operating system group for the TimesTen administrators group Only members of thi...

Page 46: ... administrators group named timesten use chmod 775 etc TimesTen chgrp timesten etc TimesTen If you are upgrading from a TimesTen 5 1 you must change the existing group ownership and permissions of the existing etc TimesTen directory on each machine that you wish to install TimesTen 7 0 In that case the instance_info file must be assigned write permissions for members of the TimesTen administrators...

Page 47: ...before changing the port number After the port change the daemon is automatically restarted This feature is useful if you install TimesTen and later find that the port is already in use The utility is run from the command line and takes the port option with the new port number as an argument For example ttmodinstall port 12345 The ttmodinstall utility can also enable Access Control and modify the ...

Page 48: ... the CD ROM drive Note Each time SETUP EXE is executed the install program checks for previous installations If a previous version of TimesTen exists the setup program starts in Maintenance Mode which allows you to uninstall or repair the existing TimesTen product In order to do a install a new version of TimesTen where the first and second version number e g 6 1 2 and 6 1 5 match you must first u...

Page 49: ... TimesTen allows you to save installation options to a batch file that you can later use to install TimesTen without having to answer each option in a dialog box To set up silent mode From a command line run C setup exe r With this option TimesTen walks you through a normal setup operation with all the dialog boxes TimesTen saves your responses to the file C WINDOWS setup iss You can now use this ...

Page 50: ...Ten Data Manager 7 0 service has the word Started in the Status field At this time you can also set Recovery options to attempt to restart the service after a failure These steps verify that the system has been installed properly Verifying TimesTen Client and Server installation To verify that the Client and Server have been properly installed 1 On the Windows Desktop choose Start Settings Control...

Page 51: ...ave chosen is defined on the server The TimesTen Client can connect to the data source Working with the Data Manager Service and the Server The TimesTen Data Manager Service starts automatically when you install the TimesTen Data Manager In addition if you installed the TimesTen Server it is automatically started whenever the TimesTen Data Manager service is started You can change the startup mode...

Page 52: ...e Start Settings Control Panel Add Remove Programs Alternatively you can use the Modify option to the TimesTen Installation script to uninstall just the Cache Connect to Oracle option from TimesTen To verify that removal was successful check that The TimesTen 7 0 Start menu shortcut has been removed from the Start Programs menu The TimesTen Data Manager 7 0 has been removed from the Services list ...

Page 53: ...sh where mount_dir is the directory where the CD is mounted e g cdrom You can run the setup script with the option install or uninstall default is install When you use the uninstall option the script stops the daemon if it is running and removes all files it had installed To add the Cache Connect to Oracle option to an existing TimesTen installation use the installCache option with the setup scrip...

Page 54: ... respond to prompts If filename is specified the installation reads all installation prompts from the file The batch file filename is optional However TimesTen recommends that you create the batch file and specifically indicate the instance name of the installation If no batch file is provided or if the batch file does not contain an instance name TimesTen installs a default instance using tt70 fo...

Page 55: ...nager Data Manager only Client only Prompts you for the location of your TimesTen installation and specific files if installing as a non root user Prompts you to specify the daemon port number If no instances of TimesTen are installed on the machine or if no instances use the default port number 17000 for 32 bit installations and 17001 for 64 bit applications prompts you to use the default port nu...

Page 56: ...This file contains the daemon s process ID When the script to stop the daemon is run this ID is used to determine the process to terminate When the process terminates the timestend pid file is removed Working with the daemon and Server The TimesTen main daemon timestend starts automatically when the operating system is booted if the instance startup scripts have been installed in etc init d and op...

Page 57: ...u can execute ps to verify that all TimesTen processes have terminated To verify that TimesTen has been successfully uninstalled verified that the install_dir no longer exists To uninstall just the Cache Connect to Oracle option from an existing TimesTen installation use the install_dir bin setup sh removeCache Installing TimesTen on HP UX systems This section discusses installation and some relat...

Page 58: ... setup script with the option install or uninstall default is install When you use the uninstall option the script stops the daemon and Server if they are running and removes all files it had installed To add the Cache Connect to Oracle option to an existing TimesTen installation use the installCache option with the setup script To uninstall just the Cache Connect to Oracle option from an existing...

Page 59: ... having to respond to prompts If filename is specified the installation reads all installation prompts from the file The batch file filename is optional However TimesTen recommends that you create the batch file and specifically indicate the instance name of the installation If no batch file is provided or if the batch file does not contain an instance name TimesTen installs a default instance usi...

Page 60: ...rver and Data Manager Data Manager only Client only Prompts you for the location of your TimesTen installation and specific files if installing as a non root user Prompts you to specify the daemon port number If no instances of TimesTen are installed on the machine or if no instances use the default port number 17000 for 32 bit installations and 17001 for 64 bit applications prompts you to use the...

Page 61: ... stop the daemon is run this ID is used to determine which process to terminate Once the process is terminated the timestend pid file is removed Note When doing any compiling use an ANSI C compiler Working with the TimesTen daemon and Server The TimesTen main daemon starts automatically when the operating system is booted and operates continually in the background Application developers do not int...

Page 62: ...ves all TimesTen libraries and executables and also stops and uninstalls the daemon and Server You can execute ps to verify that all TimesTen processes have terminated To verify that TimesTen has been successfully uninstalled verify that the install_dir no longer exists To uninstall just the Cache Connect to Oracle option from an existing TimesTen installation use the install_dir bin setup sh remo...

Page 63: ...he shared memory IPC mechanism for client server The daemon and utility programs programs provided by TimesTen are linked with EXEC_MAGIC using the N option to ld 1 You may change the TimesTen programs to be marked SHMEM_MAGIC enabling 2GB of shared memory within the window Any single data store is still limited to 1GB For example to use SHMEM_MAGIC log in as root and use chatr M tt_instance bin t...

Page 64: ...m shared memory segment size usr sbin kmtune q shmmax How many windows are you using cat etc services window Do you have the correct instance in your path ttVersion ttStatus getmemwindow tt_instance Can you connect with a utility provided by TimesTen ttIsql connStr dsn my_dsn Can you successfully run a demo program The TimesTen demos are located under install_dir demo What other segments are in us...

Page 65: ... programs SHMEM_MAGIC Did you also mark your application SHMEM_MAGIC No space left on device ENOSPC errno 28 may indicate that the system is not configured for enough shared memory segments or identifiers or that the system may have insufficient swap space to allocate the shared segment Check the values of shmseg shmmni maxswapchunks and run the swapinfo 1M command Installing TimesTen on AIX syste...

Page 66: ...dition setup sh also accepts these options batch filename Installs or uninstalls TimesTen without having to respond to prompts If filename is specified the installation reads all installation prompts from the file The batch file filename is optional However TimesTen recommends that you create the batch file and specifically indicate the instance name of the installation If no batch file is provide...

Page 67: ...ion of the installation process On 64 bit systems prompts you to install one of the following releases 32 bit default 64 bit Prompts you to Install a new instance Upgrade an existing instance This option allows you to incrementally install the Cache Connect option The major and minor version numbers of the TimesTen release must match exactly Display information about an existing instance or Quit t...

Page 68: ...ing installed into the install directory default usr lpp TimesTen tt70 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 TimesTen demo applications will reside By default they reside in var TimesTen TTinstance DemoDataStore Starts the daemon If t...

Page 69: ... the TimesTen daemon is stopped Note You must have root privileges or be the TimesTen instance administrator to interact with the TimesTen daemon To stop the daemon manually use the utility command ttDaemonAdmin stop To start the daemon manually use the utility command ttDaemonAdmin start To determine the status of the daemon at any time use the ttStatus utility Uninstalling TimesTen To uninstall ...

Page 70: ... installing as non root or log in as user root 2 Load the CD ROM into the CD drive as follows mount mnt cdrom 3 Run the setup script by typing the following cd mnt cdrom setup sh To add the Cache Connect to Oracle option to an existing TimesTen installation use the installCache option with the startup script To uninstall just the Cache Connect to Oracle option from an existing TimesTen installatio...

Page 71: ...nstall a new instance Upgrade an existing instance This option allows you to incrementally install the Cache Connect option The major and batch filename Installs or uninstalls TimesTen without having to respond to prompts If filename is specified the installation reads all installation prompts from the file The batch file filename is optional However TimesTen recommends that you create the batch f...

Page 72: ...se the default port number 17000 for 32 bit installations and 17001 for 64 bit applications prompts you to use the default port number Prompts you to determine if Access Control should be enabled except for Client only installs Default answer is No In that case no other changes are needed to your installation or your use of TimesTen For more details on Access Control see Chapter 1 Access Control i...

Page 73: ... 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 developers do not in general have to be concerned with it Application programs that use TimesTen data stores communicate with the daemon transparently by using TimesTen internal routines There are situations...

Page 74: ...ems This section discusses installation and some related topics for Tru64 UNIX systems Note Before beginning installation be sure that the prerequisites defined in Installation prerequisites on page 25 have been met Installing TimesTen To install TimesTen on your Tru64 UNIX system follow these steps 1 Log in as the TimesTen instance administrator if installing as non root or log in as user root 2 ...

Page 75: ...Batch files from releases older than TimesTen Release7 0 should not be used to install this release All new prompts in the installation script for this batch filename Installs or uninstalls TimesTen without having to respond to prompts If filename is specified the installation reads all installation prompts from the file The batch file filename is optional However TimesTen recommends that you crea...

Page 76: ...Oracle Prompts you to install one of the following components Client Server and Data Manager Data Manager only Client only Prompts you for the location of your TimesTen installation and specific files if installing as a non root user Prompts you to specify the daemon port number If no instances of TimesTen are installed on the machine or if no instances use the default port number 17000 for 32 bit...

Page 77: ...the daemon is run this ID is used to determine the process to terminate When the process terminates the timestend pid file is removed Working with the TimesTen daemon and Server The TimesTen main daemon timestend starts automatically when the operating system is booted and operates continually in the background Application developers do not interact with the daemon directly no application code run...

Page 78: ... Cache Connect to Oracle option from an existing TimesTen installation use the install_dir bin setup sh removeCache Using the Cache Administrator The Cache Administrator is a web based tool used to set cache definitions This feature is available on systems where the Cache Connect to Oracle option has been installed See Cache Connect to Oracle on page 21 To start the Cache Administrator use the URL...

Page 79: ...es error warning informational and debug messages These messages may be useful for TimesTen system administration and for debugging applications To view the messages follow these steps 1 On Windows XP choose Start Programs Administrative Tools Event Viewer On Windows2000 choose Start Settings Control Panel Administrative Tools Event Viewer The Event Viewer window appears 2 From the Log menu choose...

Page 80: ...values are auth cron daemon local0 local7 lpr mail news user or uucp The syslog facility allows messages to be routed in a variety of ways including recording them to a file The disposition of messages is under the control of the configuration file etc syslog conf Entries in the syslog conf file contain two columns The first column contains a list of the types of messages to log to a particular fi...

Page 81: ...of Cache Connect TimesTen allows you to incrementally install the Cache Connect to Oracle option after having completed an installation Likewise you can uninstall just the Cache Connect option of TimesTen To incrementally install the Cache Connect option use the installCache option when install ODBC installation On Windows systems TimesTen makes use of the Microsoft ODBC 3 5 SDK The ODBC SDK s red...

Page 82: ...D_LIBRARY_PATH or SHLIB_PATH On UNIX systems include the lib directory under the TimesTen installation directory Shared library path environment variable on page 77 ODBCINI The location where the odbc ini file used by TimesTen data stores is to be found ODBCINI environment variable on page 75 ORACLE_HOME If using the Cache Connect to Oracle option set to the location of the Oracle installation Req...

Page 83: ...efault on UNIX platforms TimesTen first looks for the odbc ini file in the home directory of the user running the TimesTen application To override the name and location of this file at run time set the ODBCINI environment variable to the pathname of a odbc ini file before launching the TimesTen SYSODBCINI Set to the location where the sys odbc ini file used by TimesTen system data stores is to be ...

Page 84: ... set the SYSODBCINI environment variable to the pathname of a sys odbc ini file before launching the TimesTen application If TimesTen cannot locate a user DSN file the system DSN file located in var TimesTen sys odbc ini will be used For non root installations TimesTen also looks for the sys odbc ini file under install_dir info Also see Defining data sources for the demo applications on page 83 fo...

Page 85: ...ing the port number After the change the daemon is automatically restarted This feature is useful if you install TimesTen and later find that the Oracle installation has been moved The utility is run from the command line and takes the changeOracle Settings option which will prompt you to supply the new path name See Changing the daemon port number on UNIX on page 39 and Enabling Access Control af...

Page 86: ...LIBRARY_PATH environment variable If you are using the Cache Connect to Oracle option SHLIB_PATH must also contain ORACLE_HOME lib and must not contain ORACLE_HOME lib32 See ORACLE_HOME environment variable on page 77 On Tru64 UNIX systems add install_dir lib directory to the LD_LIBRARY_PATH environment variable ...

Page 87: ...er 3 Starting the TimesTen daemon For more details see the chapter Chapter 3 Working with the Oracle TimesTen Data Manager Daemon in the Oracle TimesTen In Memory Database Operations Guide Various options for the web server are stored in the webserver config file also in the daemon startup directory The TimesTen installation scripts initially set these options The options should only be changed at...

Page 88: ...t use spaces around the colon though leading and trailing spaces and comments are allowed Passwords are not encrypted in the password file and are sent only base64 encoded from the browser to the server MIME Some MIME types are also specified here They are all of the form MIMETYPE extension mime type You should not remove the definitions for text html Migrating data stores to TimesTen 7 0 TimesTen...

Page 89: ...he Oracle TimesTen In Memory Database API Reference Guide To migrate a data store from different versions 1 Use ttMigrate to save the tables in the older version data store to a disk file If for example A TimesTen 6 0 data store is called Sales600 The data file you wish to use is called sales dat and TimesTen 6 0 is installed in opt TimesTen60 on UNIX platforms or C TimesTen TimesTen60 on Windows ...

Page 90: ...and use ttIsql and ttBulkCp Release 7 0 to copy the disk files into the tables of the new data store To import data from a data store created with TimesTen6 0 1 Find all the tables you want to copy into the new release of TimesTen 2 Use the TimesTen utility ttBulkCp to copy the data in each table to a disk file 3 Define a data source name for the new data store 4 Use the CREATE TABLE and CREATE IN...

Page 91: ...rectory install_dir demo tutorial and install_dir demo quickstart contains files used in demos that provide examples for the TimesTen documentation For a description of these demos see the README txt file at the top of these directories Note By default the TimesTen demo applications save data store files to var TimesTen TTinstance demo DemoDataStore on UNIX for root installs and install_dir info D...

Page 92: ...nning the C demo programs on UNIX On UNIX when running the demo programs check the following Are one or more TimesTen drivers installed Check the lib subdirectory of the installation directory for libraries beginning with libtten The default installation directory for a root installation is opt TimesTen TTinstance on Solaris HP UX and Linux usr lpp TimesTen TTinstance on AIX Is the TimesTen main d...

Page 93: ...ash zsh or a similar shell type install_dir demo ttdemoenv sh If using csh tcsh or similar shell type source install_dir demo ttdemoenv csh Create the data source name DSN that the application relies on For details see Defining data sources for the demo applications on page 83 You can use one of the demo data sources already provided by TimesTen See the README file in the install_dir demo director...

Page 94: ...e and the release notes check that You are running a supported version of the OS You have sufficient disk space On UNIX you are installing as root or the TimesTen instance administrator For Windows you are installing as user Administrator who is a member of the local Administrators group You have installed all required operating system patches You have made all required kernel configuration change...

Page 95: ...number indicated the patch release of a major release of TimesTen For example TimesTen version number 5 1 35 indicates the 35th patch release of TimesTen version 5 1 TimesTen data stores are not compatible between major releases but they are always compatible between patch releases For example a data store created with TimesTen version 5 1 35 is not compatible with a TimesTen version 7 0 0 0 0 app...

Page 96: ...r to 7 0 If you wish to perform an upgrade that requires replication with a version of TimesTen from before 7 0 you must upgrade the original data types as TimesTen data types See Upgrading data types as TimesTen data types on page 90 for more information Data store character set Beginning with TimesTen 7 0 TimesTen requires a data store to be configured to support a specific character set when it...

Page 97: ...on prior to TimesTen 7 0 you must specify a DatabaseCharacterSet of TIMESTEN8 in your TimesTen 7 0 DSN in order to ensure compatibility See Performing a Client Server online upgrade from a TimesTen version prior to 6 0 on page 113 or Performing a Client Server online upgrade from TimesTen version 6 0 and above on page 116 Note The TIMESTEN8 data store character set is intended for use only when tr...

Page 98: ...y differently you should thoroughly test any applications written for versions of TimesTen prior to 7 0 with the new Oracle data types before deploying them with TimesTen 7 0 Upgrading data types as TimesTen data types Note If you intend to perform an online upgrade using replication you must upgrade your data types as TimesTen data types See Online upgrades with replication on page 94 for more in...

Page 99: ... to use for your region See Converting from the TIMESTEN8 character set on page 91 You need to change your data store s character set from the one that you originally specified to a new one that fits your requirements more closely See Converting from a character set other than TIMESTEN8 on page 92 Converting from the TIMESTEN8 character set You may use ttMigrate to convert a data store from TIMEST...

Page 100: ...racter set by completing the following steps 1 Save the data store to a file using ttMigrate For example to save the data store SalesData to the file salesdata mig use the command ttMigrate c DSN SalesData salesdata mig 2 Destroy the data store ttDestroy SalesData 3 Change the value of the DSN attribute DatabaseCharacterSet for your data store to the value specifying the new character set For exam...

Page 101: ...TimesTen s backup and migration utilities Offline upgrades During the time required to perform an offline upgrade the data store is not available to applications Offline upgrades usually require enough disk space for an extra copy of the upgraded data store Offline upgrades are used to move to a new major or patch release of TimesTen move to a different directory or machine reduce data store size ...

Page 102: ...ue index on non nullable columns Also because two copies of the data store to be upgraded are required you must have twice the memory and disk space that the data store usually requires available if performing the upgrade on a single system Note Replication is not supported between 32 bit and 64 bit data stores Also tables migrated using the ttMigrate inline command should not be replicated with t...

Page 103: ... the new version listening on the same port The only interruption in availability using this method will be the very brief period during which the old server is stopped and the new server is started On Windows more than one version of TimesTen cannot be installed at the same time Therefore it is not possible to perform online upgrades with Client Server on Windows if you are upgrading from a versi...

Page 104: ...If the RAM policy is inUse and a grace period is set set the grace period to 0 or wait for the grace period to elapse 5 Use the ttStatus utility to verify that the data store has been unloaded from memory See ttStatus in Oracle TimesTen In Memory Database API Reference Guide Moving to a new patch release of TimesTen All applications concurrently connected to a data store must be directly linked to...

Page 105: ...re you can use either the ttMigrate or ttBackup utility The ttMigrate utility exports the data store in a release neutral format that is more flexible while the ttBackup utility exports an image copy of the data store and is faster The ttBackup utility may be used if you wish to move the data store to a different machine or directory The ttMigrate utility must be used if you wish to move to a new ...

Page 106: ...e by using ttDestroy to remove the old data store For example to move a data store from old SalesData sales with a data store name SalesData DSN SalesData to new SalesData sales with data store name NewSalesData DSN NewSalesData using the tmp dump directory for temporary storage use the commands 1 mkdir tmp dump 2 ttBackup dir tmp dump fname salesdata DSN SalesData 3 Create a DSN definition for th...

Page 107: ...using ttRestore For example to move a data store from ds Sales Data with data store name salesdata on the source system to data Sales View with data store name salesview on the destination system use the following commands This example uses the o flag of ttBackup to use standard output for the backup Using the o flag the backup is stored in a single file which is easily copied over the network to ...

Page 108: ...value can be determined by querying the perm_in_use_size column of the table sys monitor Perform these steps to reduce the permanent partition size of a data store 1 Back up the old data store with ttMigrate c noRepUpgrade 2 Create a new DSN definition for the new copy of the data store with a smaller PermSize value 3 Restore the backup with ttMigrate r noRepUpgrade Note If you wish to use the ori...

Page 109: ...tion For example suppose that the 32 bit data store DSN is salesdata32 while the 64 bit data store DSN is salesdata64 If a 32 bit instance of TimesTen is installed in opt TimesTen giraffe32 and a 64 bit instance is installed in opt TimesTen giraffe64 the required steps are 1 opt TimesTen giraffe32 bin ttMigrate c DSN salesdata32 noRepUpgrade tmp salesbackup 2 opt TimesTen giraffe64 bin ttMigrate r...

Page 110: ...chine masterhost use the 5 1 release s ttAdmin utility to stop the replication daemon on the data store ttAdmin repStop master1 3 Next use the 5 1 release s ttMigrate utility with the c option to back up data store master1 to a binary file ttMigrate c DSN master1 master1 bak 4 Use the 5 1 release s ttDestroy utility to destroy data store master1 where the data store s files are located in the dire...

Page 111: ...ata store subscriber1 where the data store s files are located in the directory data_store_path ttDestroy data_store_path subscriber1 3 Use the 7 0 release s ttRepAdmin utility with the duplicate option to duplicate data store subscriber1 from data store master1 via replication ttRepAdmin duplicate from master1 host masterhost subscriber1 4 Use the 7 0 release s ttAdmin utility to start the replic...

Page 112: ... Replication functions across releases only if the data store of the more recent version of TimesTen was upgraded from a data store of the older version of TimesTen A data store created in the more recent version of TimesTen is not guaranteed to replicate correctly with the older version For example replication between a data store created in the 5 1 version of TimesTen and a data store created in...

Page 113: ...TATE set to OFF no matter how it was set on the data store prior to the upgrade Reset AUTOREFRESH STATE to ON by using the ALTER CACHE GROUP statement To maintain continuous availability applications will continue to run on one copy of the data store while the upgrade is performed on the disconnected copy of the data store TimesTen replication retains updates made to the active copy of the data st...

Page 114: ...e of TimesTen 9 Install the new release of TimesTen 10 Create a Data Source Name for the upgraded data store on the new TimesTen release using the ODBC Data Source Administrator on Windows or the odbc ini file on UNIX 11 Restore the data store from the backup with ttMigrate r 12 Clear the replication bookmark and logs using ttRepAdmin receiver reset and by setting replication to the active system ...

Page 115: ...stem where a bidirectional replication configuration does not already exist you must make sure that enough memory and disk space is available to support two copies of the data store being upgraded Both the original data store and its copy will be active for the duration of the upgrade To maintain the performance of your production applications you may wish to create the copy of the data store on a...

Page 116: ...tem which will remain operational and connected to the application for the duration of the upgrade After this procedure has been completed the same steps can followed to upgrade the active system with the previously upgraded system now instead acting as the active and connected to the application However you may prefer to delay conversion of the active system in order to test the upgraded release ...

Page 117: ...R STORE upgrade ON upgradehost SET PORT 40000 ALTER STORE active ON activehost SET PORT 40001 Command call ttRepStart 2 Disconnect all production applications connected to the data store Any workload being run on the upgrade system must start running on the active system instead Use the ttRepAdmin utility to pause replication from the data store active to the data store upgrade ttRepAdmin connStr ...

Page 118: ...int on no updates will be sent to the data store active Stop the replication agent with ttAdmin ttAdmin repStop active From this point on no updates will be sent to the data store upgrade For details on starting and stopping replication agents see Starting and stopping the replication agents in Chapter of the TimesTen to TimesTen Replication Guide 5 Use ttRepAdmin to stop replication from the data...

Page 119: ...y a temporary data store Temporary 1 use ttAdmin ttAdmin ramUnload upgrade Note You can delay destroying the old data store upgrade until the migration into the new TimesTen version is successful However the replication agent on both data stores must remain stopped and active to upgrade replication on the data store active must be remain in the pause state Restart the replication agent on the data...

Page 120: ...Migrate utility supplied with the new release of TimesTen to which you are upgrading 10 Use ttRepAdmin to set replication to the data store upgrade to the stop state and then the start state ttRepAdmin connStr DSN upgrade receiver name active state stop sleep 10 ttRepAdmin connStr DSN upgrade receiver name active state start sleep 10 Note The sleep command is to ensure that each state takes effect...

Page 121: ...ate appears in upgrade you know that replication is operational If the applications are still running on the data store active let them continue until the data store upgrade has been successfully migrated and you have verified that the updates are being replicated correctly from the active to upgrade 13 Once you are sure that updates are being replicated correctly you can disconnect all of the app...

Page 122: ... to a 5 1 or later Server DSN the source of the log messages in the syslog or in the specified file pertaining to that connection will still be 5 0 because the 5 0 Server binary performs the logging Client Server online upgrade example To connect an older client application to a newer TimesTen Server DSN use the procedure described in the following example For this example the hostname for the ser...

Page 123: ...er_dsn51 client_dsn_70 Description Access to my_server_dsn70 on host server TTC_SERVER my_server_50 TTC_SERVER_DSN my_server_dsn70 DRIVER install_dir_70 lib libtten so Note The full path to the 7 0 driver must be specified Otherwise the server loads the default driver Step Client Machine Server Machine 1 Start the TimesTen daemon for both the 5 1 and 7 0 installations at my_server using the regula...

Page 124: ...orming an online upgrade with replication on page 104 to keep a second copy of the data store available during the migration of the first copy Note For security reasons client server communication is not normally allowed between TimesTen 7 0 and previous versions In order to perform an online upgrade with client server you must start the main TimesTen 7 0 daemon with the insecure backwards compat ...

Page 125: ...grade with replication using the following steps 1 Install the new version of TimesTen making sure to configure TimesTen Server to listen on the same port as the old version You will be asked whether you would like to start the new server and must answer no 2 Follow the steps in Performing an online upgrade with replication on page 104 to upgrade one copy of the data store The client applications ...

Page 126: ...es which look like this TTREP_SCHEMA_VERSION_004 REPELEMENTS TTREP_SCHEMA_VERSION_004 REPLICATIONS TTREP_SCHEMA_VERSION_004 REPPEERS TTREP_SCHEMA_VERSION_004 REPSTORES TTREP_SCHEMA_VERSION_004 REPSUBSCRIPTIONS TTREP_SCHEMA_VERSION_004 REPTABLES TTREP_SCHEMA_VERSION_004 TTSTORES TTREP_SCHEMA_VERSION_005 REPELEMENTS TTREP_SCHEMA_VERSION_005 REPLICATIONS TTREP_SCHEMA_VERSION_005 REPPEERS TTREP_SCHEMA...

Page 127: ...t variable 77 Client installation 24 compiling demo applications 84 85 concurrent connections maximum for Server 26 D daemon on AIX 61 on HP UX 53 on Linux 65 on Solaris 48 69 timestend 48 65 69 daemon home directory 12 daemon port Access Control 13 daemon port number changing on UNIX 39 daemon startup script 48 53 61 65 69 Data Manager installation 24 Data Manager library choosing 39 Data Manager...

Page 128: ...is 32 bit 47 52 59 Solaris 64 bit 47 52 59 instance administrators group creating 37 instance data store 9 instance home directory 12 instance registry directory 11 instance startup and shutdown 8 instances installation 23 naming 23 port numbers 23 K kernel enabling large files 27 required changes 26 31 semmns parameter 26 shmmax parameter 26 shmseg parameter 26 L LD_LIBRARY_PATH 77 78 LIB environ...

Page 129: ...lems installation problems 86 problems running demo programs 84 R reducing data store size 100 replication across releases 104 requirements on line upgrade 107 semaphores 31 S security Access Control 7 semaphores 31 33 semmns 26 Server installation 24 setup script on Linux 62 Solaris 45 67 setuproot sh 38 Shared library path environment variable 77 shared memory objects enabling on HP UX and Solar...

Page 130: ...table 117 ttRestore 98 ttVersion utility 23 U uninstalling on AIX 61 on HP UX 54 on Linux 65 on Solaris 49 70 on Windows NT 44 UNIX 72 unloading a data store 95 upgrade modes described 93 in place upgrade 93 95 off line upgrade 93 97 on line upgrade 94 users Access Control 13 using the Oracle Connect Administrator 70 utilities ttVersion 23 V verifying installation on Windows NT 42 W Web Server opt...

Search results

Summary of Contents for B31679-01

Reviews:

Related manuals for B31679-01

Brands by name

Popular brands

Oracle B31679-01, Installation Manual

Search results

Summary of Contents for B31679-01

Reviews:

Related manuals for B31679-01

Brands by name

Popular brands