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 130

TimesTen daemon on AIX 61

TimesTen instance 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.pid file 48, 53, 60, 65,

69

TMP environment variable 35 TMPDIR environment variable 35 troubleshooting

installation problems 86 Tru64 19, 21, 22 ttBackup 93, 97, 98 ttDaemonLog

on NT 72 ttDestroy 100 ttIsql 107

ttMigrate 80, 82, 93, 97, 107

TTREP_SCHEMA_VERSION 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-lineupgrade 93, 97 on-lineupgrade 94

users

Access Control 13 using the Oracle Connect

Administrator 70 utilities

ttVersion 23

V

verifying installation

on Windows NT 42

W

Web Server options 79

Web server configuration 79

WEBROOT Web Server option 79 Windows

informational messages 71 Windows NT

supported environment 19 uninstalling 44

working with the daemon on AIX 61

on HP-UX 53 on Linux 65

on Solaris 48, 69

working with the Data Manager Ser- vice

on Windows 43

working with the TimesTen Server on AIX 61

on HP-UX 53 on Linux 65

on Solaris 48, 69 on Windows 43

122Oracle TimesTen In-Memory Database Installation Guide

Image 130

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 America2 TimesTen Installation Contents1 Access Control 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 Book Titles About this GuideTimesTen documentation DescriptionBackground reading If you see Conventions used in this guideIt means 4 Oracle TimesTen In-Memory Database Installation Guide Technical Support 6 Oracle TimesTen In-Memory Database Installation Guide Access Control Access ControlLimitations of Access Control and non-root installs IntroductionReplication Instance accessCache Connect Client/ServerTimesTen users TimesTen instance administratorInstance data store Internal user TimesTen instance usersExternal user TimesTen administrators group Before installationInstance registry directory Password file Installation directories, files and the daemon portInstallation directories Instance home directoryPrivileges Authenticating users and privilegesDaemon port GroupRestrictMaintaining users and privileges Enabling Access Control after installation on UNIXListing of defined users and privileges 39 and “ORACLEHOME environment variable” on page 16 Oracle TimesTen In-Memory Database Installation Guide Installation prerequisites Operating system security considerations TimesTen InstallationPlatforms and configurations Installation instances Prerequisites for non-root installations on UNIX systemsViewing the online documentation Installation problemsBuilding and running the demo applications 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 names Installation instancesInstance port numbers Components available on Windows Choosing the appropriate TimesTen componentsComponents available on UNIX Installation prerequisites UNIX requirementsSemaphores Other Client Server Settings ReplicationHP-UX 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 CacheSolaris 30 Oracle TimesTen In-Memory Database Installation GuideCache Connect OperatingIncrease number of semaphores Shared memory IPC client connectionsOther changes Large data stores Tru64 UNIX # /sbin/sysconfig -q ipcsysconfig -q ipc Shared memoryDefault installation directories Shared memory IPC client connections ReplicationOperating system security considerations Cache Connect36 Oracle TimesTen In-Memory Database Installation Guide Installation prerequisites for non-root installs Prerequisites for non-root installations on UNIX systemsCreate the TimesTen instance administrators group Post-installation requirements Create the TimesTen registryChanging the daemon port number on UNIX Configure the syslog messagesUNIX libraries Installing TimesTen Installing TimesTen on Windows systemsSee “Components available on Windows” on page Installing TimesTen in silent mode Verifying TimesTen Client and Server installation Verifying installation2. Click System DSN Working with the Data Manager Service and the Server 2. Select TimesTen Data ManagerUninstalling TimesTen Installing TimesTen on Solaris systems2. 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 To start the daemon manually, use the utility command Installing TimesTen on HP-UX systemsTo stop the daemon manually, use the utility command Uninstalling TimesTen# mkdir /cdrom 50 Oracle TimesTen In-Memory Database Installation Guide# cd mountdir # ./setup.sh # /etc/mount /cdromInstalls or uninstalls TimesTen and records responses 52 Oracle TimesTen In-Memory Database Installation Guide Working with the TimesTen daemon and Server Uninstalling TimesTen Installing TimesTen on HP-UX Memory WindowsUse a separate instance for each memory window To stop the daemon manually, use the utility commandUsing TimesTen in a memory window Address Space ConsiderationsTroubleshooting Installing TimesTen Installing TimesTen on AIX systems# 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 To stop the daemon manually, use the utility command Working with the TimesTen daemon and serverUninstalling TimesTen To start the daemon manually, use the utility commandInstalling TimesTen Installing TimesTen on Linux systems62 Oracle TimesTen In-Memory Database Installation Guide Installs or uninstalls TimesTen and records responses 64 Oracle TimesTen In-Memory Database Installation Guide To start the daemon manually, use the utility command Uninstalling TimesTenTo stop the daemon manually, use the utility command Working with the TimesTen daemon and ServerInstalling TimesTen Installing TimesTen on Tru64 UNIX systems66 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 ServerTo start the daemon manually, use the utility command Using the Cache AdministratorUninstalling TimesTen 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 installation“ODBCINI environment Environment modifications“Shared library path environment variable” on page variable” on pageODBCINI environment variable “Default installationPATH environment variable “SYSODBCINI environmentSYSTTCONNECTINI environment variable SYSODBCINI environment variable76 Oracle TimesTen In-Memory Database Installation Guide ORACLEHOME environment variable CLASSPATH 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 TimesTenC\ ”C\TimesTen\tt70\bin\ttMigrate” -r DSN=Salestt70 sales.dat opt/tt60/32/bin/ttMigrate -c DSN=Sales600 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 C demo programs on UNIX Problems running the demo programsBuilding the demo applications Problems running the C demo programs on WindowsViewing the online documentation Building and running the JDBC demo applicationsInstallation problems Data type compatibility Data Store UpgradesData store compatibility IntroductionData store character set 88 Oracle TimesTen In-Memory Database Installation GuideData type conversion Data Store UpgradesUpgrading data types as TimesTen data types Converting data types to Oracle 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 GuideIn-place upgrades Upgrade modesOffline upgrades Online upgrades with Client/Server Online upgrades with replication94 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 c DSN=salesdata32 -noRepUpgrade /tmp/salesbackup Moving between 32-bit and 64-bit data storesMoving to a different major release of TimesTen 1. /opt/TimesTen/giraffe32/bin/ttMigratettMigrate -c DSN=master1 master1.bak 102 Oracle TimesTen In-Memory Database Installation GuidettAdmin -repStop master1 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 110 Oracle TimesTen In-Memory Database Installation Guide ttAdminttAdmin 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 canLimitations Client/Server online upgrade exampleFor 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