After read Oracle TimesTen Release 188.8.131.52.0 announce,
I'd like to know How I install/setup it, it differ from old versions, doesn't it?
$ ls timesten112120.linux8664.tar.gztimesten112120.linux8664.tar.gz$ tar zxvf timesten112120.linux8664.tar.gzlinux8664/linux8664/doc/linux8664/doc/doc.ziplinux8664/3rdparty/linux8664/3rdparty/jms-1_1-fr-apidocs.tar.bz2linux8664/3rdparty/ant-1.6.2-bin.tar.bz2linux8664/behaviorchanges.txtlinux8664/setup.shlinux8664/uninst.shlinux8664/LINUX8664/linux8664/LINUX8664/timesten.tar.bz2linux8664/LINUX8664/unziplinux8664/LINUX8664/ttpatchinstlinux8664/LINUX8664/ttserver.tar.bz2linux8664/LINUX8664/manifestlinux8664/LINUX8664/perllinux8664/LINUX8664/common.tar.bz2linux8664/LINUX8664/bzip2linux8664/LINUX8664/ttclient.tar.bz2linux8664/README.htmllinux8664/install.pl$ cd linux8664$ ./setup.shERROR: The /etc/TimesTen directory needs to be created for the instance registryand its ownership and permissions set appropriately.Please refer to the installation guide for assistance.
Oop! I used oracle user, so...
$ su - root# mkdir /etc/TimesTen# chown -R oracle:oinstall /etc/TimesTen
$ ./setup.shNOTE: Each TimesTen installation is identified by a unique instance name.The instance name must be a non-null alphanumeric string, not longerthan 255 characters.Please choose an instance name for this installation? [ tt1121 ] ttmbInstance name will be 'ttmb'.Is this correct? [ yes ]Of the three components: Client/Server and Data Manager Data Manager Only Client OnlyWhich would you like to install? [ 1 ]Where would you like to install the ttmb instance of TimesTen? [ /home/oracle ] /u02/TimesTenWhere would you like to create the daemon home directory? [ /u02/TimesTen/ttmb/info ]Installing into /u02/TimesTen/ttmb ...Uncompressing ...NOTE: If you are configuring TimesTen for use with Oracle Clusterware, thedaemon port number must be the same across all TimesTen installationsmanaged by Oracle Clusterware.NOTE: All installations that replicate to each other must use the same daemonport number that is set at installation time. The daemon port number canbe verified by running 'ttVersion'.The default port number is 53388.Do you want to use the default port number for the TimesTen daemon? [ yes ]The daemon will run on the default port number (53388).NOTE: For security, we recommend that you restrict access to theTimesTen installation to members of a single OS group. Only members ofthat OS group will be allowed to perform direct mode connections toTimesTen, and only members of that OS group will be allowed to performoperations that access TimesTen data stores, TimesTen files and sharedmemory. The OS group defaults to the primary group of the instanceadministrator. You can default to this group, choose another OS groupor you can make this instance world-accessible. If you choose to makethis instance world-accessible, all database files and shared memoryare readable and writable by all users.Restrict access to the the TimesTen installation to the group 'oinstall'? [ yes ]NOTE: Enabling PL/SQL will increase the size of some TimesTen libraries.Would you like to enable PL/SQL for this instance? [ yes ]The daemon logs will be located in /u02/TimesTen/ttmb/infoWould you like to specify a different location for the daemon logs? [ no ] yesWhere would you like the daemon logs to be written? [ /u02/TimesTen/ttmb/info ] /u02/TimesTen/ttmb/logThe directory /u02/TimesTen/ttmb/log does not exist.Do you want to create it? [ yes ]Are you sure you want the daemon logs to be written to /u02/TimesTen/ttmb/log? [ yes ]TNS_ADMIN was not set in your environment but there is a tnsnames.orafile in /u01/oracle/product/11.1.0/db/network/admin.Would you like to use this TNS_ADMIN setting for the In-Memory Database Cache? [ yes ]TNS_ADMIN will be set to /u01/oracle/product/11.1.0/db/network/adminYou can change TNS_ADMIN later by running
/bin/ttmodinstall....Installing server components ...What is the TCP/IP port number that you want the TimesTen Server to listen on? [ 53389 ]Do you want to install QuickStart and the TimesTen Documentation? [ no ] yesWhere would you like to install the quickstart and doc directories (s=skip)? [ /u02/TimesTen/ttmb ]The TimesTen Quickstart applications can take up to 64 Mbytes of disk space.Depending on how your system is configured, you may not want to create theQuickStart DemoDataStore directory in the default location,/u02/TimesTen/ttmb/info/DemoDataStoreWhere would you like to create the DemoDataStore directory? [ /u02/TimesTen/ttmb/info ]Creating /u02/TimesTen/ttmb/info/DemoDataStore ...Installing client components ...Would you like to use TimesTen Replication with Oracle Clusterware? [ no ] yesPlease provide the path to the Oracle Clusterware installation on this machine (s=skip)? [ /u01/oracle/product/crs ]Please enter a port number for the TimesTen Clusterware agent? [ 53394 ]Executing '/u01/oracle/product/crs/bin/crsctl check cluster' ...Oracle Clusterware is currently configured on the following nodes :...NOTE: The TimesTen daemon startup/shutdown scripts have not been installed.Run the 'setuproot' script :cd /u02/TimesTen/ttmb/bin./setuproot -installThis will move the TimesTen startup script into its appropriate location.The startup script is currently located here :'/u02/TimesTen/ttmb/startup/tt_ttmb'.The Quickstart home page can be accessed here :'/u02/TimesTen/ttmb/quickstart/index.html'Starting the daemon ...TimesTen Daemon startup OK.End of TimesTen installation.
and Test PL/SQL (sample):
when installed, it's time to test with it:
setup data store:
$ vi /u02/TimesTen/ttmb/info/sys.odbc.ini[ODBC Data Sources]mb_db01=TimesTen 11.2.1 Driver[mb_db01]Driver=/u02/TimesTen/ttmb/lib/libtten.soDataStore=/u02/TimesTen/ttmb/info/TT/mb_db01PermSize=100TempSize=100PLSQL=1DatabaseCharacterSet=US7ASCII
start data store and test create user:
$ cd /u02/TimesTen/ttmb/bin$ mkdir /u02/TimesTen/ttmb/info/TT$ ./ttisqlCopyright (c) 1996-2009, Oracle. All rights reserved.Type ? or "help" for help, type "exit" to quit ttIsql.Command> connect "dsn=mb_db01";Connection successful: DSN=mb_db01;UID=oracle;DataStore=/u02/TimesTen/ttmb/info/TT/mb_db01;DatabaseCharacterSet=US7ASCII;ConnectionCharacterSet=US7ASCII;DRIVER=/u02/TimesTen/ttmb/lib/libtten.so;PermSize=100;TempSize=100;TypeMode=0;(Default setting AutoCommit=1)Command> create user tt01 identified by password;User created.Command> GRANT CREATE TABLE TO tt01;Command>Command> connect "DSN=mb_db01;uid=tt01";Enter password for 'tt01':15107: User lacks CREATE SESSION privilege; logon deniedThe command failed.none: Command> connect "DSN=mb_db01" ;Connection successful: DSN=mb_db01;UID=oracle;DataStore=/u02/TimesTen/ttmb/info/TT/mb_db01;DatabaseCharacterSet=US7ASCII;ConnectionCharacterSet=US7ASCII;DRIVER=/u02/TimesTen/ttmb/lib/libtten.so;PermSize=100;TempSize=100;TypeMode=0;(Default setting AutoCommit=1)con1: Command>con1: Command>con1: Command> grant create session to tt01;con1: Command> grant create procedure to tt01;con1: Command> connect "DSN=mb_db01;uid=tt01";Enter password for 'tt01':Connection successful: DSN=mb_db01;UID=tt01;DataStore=/u02/TimesTen/ttmb/info/TT/mb_db01;DatabaseCharacterSet=US7ASCII;ConnectionCharacterSet=US7ASCII;DRIVER=/u02/TimesTen/ttmb/lib/libtten.so;PermSize=100;TempSize=100;TypeMode=0;(Default setting AutoCommit=1)
con1: Command>set serveroutput oncon1: Command> create or replace procedure hello_world asbegindbms_output.put_line('Hello World!');end;/con1: Command> begin