Manuals / Oracle Audio Technologies / Cell Phone / Carrying Case

Oracle Audio Technologies B31679-01 manual Oracle TimesTen In-Memory Database Installation Guide

Models: B31679-01

1 130

Download 130 pages 38.83 Kb

Page 24

16Oracle TimesTen In-Memory Database Installation Guide

Image 24

Oracle Audio Technologies B31679-01 manual 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 Conventions used in this guide If you seeIt means 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/ServerTimesTen instance administrator TimesTen usersInstance data store TimesTen instance users Internal userExternal user Before installation TimesTen administrators groupInstance registry directory Installation directories, files and the daemon port Installation directoriesPassword file Instance home directoryAuthenticating users and privileges Daemon portPrivileges GroupRestrictEnabling Access Control after installation on UNIX Maintaining users and privilegesListing of defined 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 GuideInstallation instances Instance namesInstance port numbers Choosing the appropriate TimesTen components Components available on WindowsComponents available on UNIX 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 Prerequisites for non-root installations on UNIX systems Installation prerequisites for non-root installsCreate the TimesTen instance administrators group Post-installation requirements Create the TimesTen registryConfigure the syslog messages Changing the daemon port number on UNIXUNIX libraries Installing TimesTen on Windows systems Installing TimesTenSee “Components available on Windows” on page Installing TimesTen in silent mode Verifying installation Verifying TimesTen Client and Server installation2. Click System DSN Working with the Data Manager Service and the Server 2. Select TimesTen Data ManagerInstalling TimesTen on Solaris systems Uninstalling TimesTen2. Select TimesTen Data Manager 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 Installing TimesTen on AIX systems Installing TimesTen# crfs -v cdrfs -p ro -d cd0 -m /usr/cdrom/ TimesTen7.0 # 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 commandInstalling TimesTen on Linux systems Installing TimesTen62 Oracle TimesTen In-Memory Database Installation Guide 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 ServerInstalling TimesTen on Tru64 UNIX systems Installing TimesTen66 Oracle TimesTen In-Memory Database Installation Guide 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 environmentSYSODBCINI environment variable SYSTTCONNECTINI environment variable76 Oracle TimesTen In-Memory Database Installation Guide CLASSPATH environment variable ORACLEHOME environment variableShared library path 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 TimesTenopt/tt60/32/bin/ttMigrate -c DSN=Sales600 sales.dat C\ ”C\TimesTen\tt70\bin\ttMigrate” -r DSN=Salestt70 sales.datC\ ”C\TimesTen\tt60\bin\ttMigrate” -c DSN=Sales600 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 UpgradesConverting data types to Oracle data types Upgrading data types as TimesTen data types90 Oracle TimesTen In-Memory Database Installation Guide 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 GuideUpgrade modes In-place upgradesOffline upgrades Online upgrades with replication Online upgrades with Client/Server94 Oracle TimesTen In-Memory Database Installation Guide 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 canClient/Server online upgrade example LimitationsFor this example, the hostname for the server machine is myserver 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