Manuals / Oracle Audio Technologies / Cell Phone / Carrying Case

Oracle Audio Technologies B31679-01 manual Online upgrade example

Models: B31679-01

1 130

Download 130 pages 38.83 Kb

Page 116

Online upgrade example

This section describes how to do an online upgrade of two bi- directionally replicated TimesTen data stores, using a concrete example.

We’ll refer to the two TimesTen systems being upgraded as the upgrade system, on which TimesTen will be upgraded along with the data store, and the active system, 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.

The upgrade system in the example consists of the data store upgrade on the server upgradehost. The active system consists of the data store active on the server activehost.

108 Oracle TimesTen In-Memory Database Installation Guide

Image 116

Oracle Audio Technologies B31679-01 manual Online upgrade example, Oracle TimesTen In-Memory Database Installation Guide

Contents

Oracle TimesTen In-Memory Database Installation Guide Release B31679-01Copyright 1996, 2007, Oracle. All rights reserved February Printed in the United States of AmericaContents 1 Access Control2 TimesTen Installation About this Guideiv Oracle TimesTen In-Memory Database Installation Guide Contents 3 Data Store Upgrades vi Oracle TimesTen In-Memory Database Installation GuideIndex Contentsviii Oracle TimesTen In-Memory Database Installation Guide About this Guide TimesTen documentationBook Titles DescriptionBackground reading It means Conventions used in this guideIf you see 4 Oracle TimesTen In-Memory Database Installation Guide Technical Support 6 Oracle TimesTen In-Memory Database Installation Guide Access Control Limitations of Access Control and non-root installsAccess Control IntroductionInstance access Cache ConnectReplication Client/ServerInstance data store TimesTen instance administratorTimesTen users External user TimesTen instance usersInternal user Instance registry directory Before installationTimesTen administrators group Installation directories, files and the daemon port Installation directoriesPassword file Instance home directoryAuthenticating users and privileges Daemon portPrivileges GroupRestrictListing of defined users and privileges Enabling Access Control after installation on UNIXMaintaining users and privileges 39 and “ORACLEHOME environment variable” on page 16 Oracle TimesTen In-Memory Database Installation Guide TimesTen Installation Platforms and configurations Installation instancesInstallation prerequisites Operating system security considerations Prerequisites for non-root installations on UNIX systemsInstallation problems Building and running the demo applicationsViewing the online documentation 18 Oracle TimesTen In-Memory Database Installation GuidePlatforms and configurations Platform supportJDK support 20 Oracle TimesTen In-Memory Database Installation GuideClient/Server configurations Cache Connect to OracleReplication configurations 22 Oracle TimesTen In-Memory Database Installation GuideInstance port numbers Installation instancesInstance names Components available on UNIX Choosing the appropriate TimesTen componentsComponents available on Windows Installation prerequisites UNIX requirementsOther Client Server Settings Replication HP-UXSemaphores SharedLinux Large data storesTo see the number and size of the allocated large pages use Administrator Semaphores Shared memory IPC Client/ Server Client/Server and Cache30 Oracle TimesTen In-Memory Database Installation Guide Cache ConnectSolaris OperatingIncrease number of semaphores Shared memory IPC client connectionsOther changes Large data stores # /sbin/sysconfig -q ipc sysconfig -q ipcTru64 UNIX Shared memoryDefault installation directories Shared memory IPC client connections ReplicationOperating system security considerations Cache Connect36 Oracle TimesTen In-Memory Database Installation Guide Create the TimesTen instance administrators group Prerequisites for non-root installations on UNIX systemsInstallation prerequisites for non-root installs Post-installation requirements Create the TimesTen registryUNIX libraries Configure the syslog messagesChanging the daemon port number on UNIX See “Components available on Windows” on page Installing TimesTen on Windows systemsInstalling TimesTen Installing TimesTen in silent mode 2. Click System DSN Verifying installationVerifying TimesTen Client and Server installation Working with the Data Manager Service and the Server 2. Select TimesTen Data Manager2. Select TimesTen Data Manager Installing TimesTen on Solaris systemsUninstalling TimesTen Installing TimesTen To install TimesTen on your Solaris system, follow these stepsIn addition, setup.sh also accepts these options 32-bit default 64-bit Prompts you to Install a new instance Working with the daemon and Server Installing TimesTen on HP-UX systems To stop the daemon manually, use the utility commandTo start the daemon manually, use the utility command Uninstalling TimesTen50 Oracle TimesTen In-Memory Database Installation Guide # cd mountdir # ./setup.sh# mkdir /cdrom # /etc/mount /cdromInstalls or uninstalls TimesTen and records responses 52 Oracle TimesTen In-Memory Database Installation Guide Working with the TimesTen daemon and Server Installing TimesTen on HP-UX Memory Windows Use a separate instance for each memory windowUninstalling TimesTen To stop the daemon manually, use the utility commandUsing TimesTen in a memory window Address Space ConsiderationsTroubleshooting # crfs -v cdrfs -p ro -d cd0 -m /usr/cdrom/ TimesTen7.0 Installing TimesTen on AIX systemsInstalling TimesTen # mount /usr/cdrom/TimesTen7.0 58 Oracle TimesTen In-Memory Database Installation GuideInstalls documentation 60 Oracle TimesTen In-Memory Database Installation Guide Working with the TimesTen daemon and server Uninstalling TimesTenTo stop the daemon manually, use the utility command To start the daemon manually, use the utility command62 Oracle TimesTen In-Memory Database Installation Guide Installing TimesTen on Linux systemsInstalling TimesTen Installs or uninstalls TimesTen and records responses 64 Oracle TimesTen In-Memory Database Installation Guide Uninstalling TimesTen To stop the daemon manually, use the utility commandTo start the daemon manually, use the utility command Working with the TimesTen daemon and Server66 Oracle TimesTen In-Memory Database Installation Guide Installing TimesTen on Tru64 UNIX systemsInstalling TimesTen In addition, setup.sh also accepts these options 68 Oracle TimesTen In-Memory Database Installation Guide To stop the daemon manually, use the utility command Working with the TimesTen daemon and ServerUsing the Cache Administrator Uninstalling TimesTenTo start the daemon manually, use the utility command 70 Oracle TimesTen In-Memory Database Installation GuideInformational messages on Windows systems Informational messages on UNIX systems Incremental install and uninstall of Cache Connect ODBC installationEnvironment modifications “Shared library path environment variable” on page“ODBCINI environment variable” on page“Default installation PATH environment variableODBCINI environment variable “SYSODBCINI environment76 Oracle TimesTen In-Memory Database Installation Guide SYSODBCINI environment variableSYSTTCONNECTINI environment variable Shared library path environment variable CLASSPATH environment variableORACLEHOME environment variable On HP-UX 64-bit systems, add installdir/lib to the 78 Oracle TimesTen In-Memory Database Installation GuideWeb server configuration Using the ttMigrate utility Migrating data stores to TimesTenC\ ”C\TimesTen\tt60\bin\ttMigrate” -c DSN=Sales600 sales.dat opt/tt60/32/bin/ttMigrate -c DSN=Sales600 sales.datC\ ”C\TimesTen\tt70\bin\ttMigrate” -r DSN=Salestt70 sales.dat Using the ttBulkCp utility Building and running the demo applications Defining data sources for the demo applicationsProblems running the demo programs Building the demo applicationsProblems running the C demo programs on UNIX Problems running the C demo programs on WindowsViewing the online documentation Building and running the JDBC demo applicationsInstallation problems Data Store Upgrades Data store compatibilityData type compatibility IntroductionData store character set 88 Oracle TimesTen In-Memory Database Installation GuideData type conversion Data Store Upgrades90 Oracle TimesTen In-Memory Database Installation Guide Converting data types to Oracle data typesUpgrading data types as TimesTen data types Data store character set conversion Converting from the TIMESTEN8 character setConverting from a character set other than TIMESTEN8 92 Oracle TimesTen In-Memory Database Installation GuideOffline upgrades Upgrade modesIn-place upgrades 94 Oracle TimesTen In-Memory Database Installation Guide Online upgrades with replicationOnline upgrades with Client/Server Performing an in-place data store upgrade Unloading a data storeMoving to a new patch release of TimesTen Performing an offline upgrade Moving to a different directory Moving to a different machineOn the source system On the destination systemReducing data store size Moving between 32-bit and 64-bit data stores Moving to a different major release of TimesTenc DSN=salesdata32 -noRepUpgrade /tmp/salesbackup 1. /opt/TimesTen/giraffe32/bin/ttMigrate102 Oracle TimesTen In-Memory Database Installation Guide ttAdmin -repStop master1ttMigrate -c DSN=master1 master1.bak ttDestroy /datastorepath/master1The data stores are now upgraded and replicating to each other Performing an online upgrade with replication OverviewStep Upgrade System Active SystemConnect all applications to the active Limitations RequirementsOnline upgrade example 108 Oracle TimesTen In-Memory Database Installation GuidettRepAdmin -connStr DSN=active -receiver -name upgrade -state pause ttAdmin ttAdmin110 Oracle TimesTen In-Memory Database Installation Guide ttAdmin -repStop upgradeTo destroy a permanent data store Temporary=0, use ttDestroy If the data store is temporary Temporary=1, first use ttAdmin Overview being replicated correctly, you canFor this example, the hostname for the server machine is myserver Client/Server online upgrade exampleLimitations The TTCONNECTINI file at the TimesTen 5.1.x client machine contains Client/Server online upgrade 116 Oracle TimesTen In-Memory Database Installation GuideRecord of Upgrades Client/Server online upgrade with continuous access to the data store118 Oracle TimesTen In-Memory Database Installation Guide Index Numerics120 Oracle TimesTen In-Memory Database Installation Guide Solaris 19, 20 122 Oracle TimesTen In-Memory Database Installation Guide