play install TimesTen 11.2.1.2.0

After read Oracle TimesTen Release 11.2.1.2.0 announce,

I'd like to know How I install/setup it, it differ from old versions, doesn't it?

I downloaded and started Install ("oracle" user):

$ ls timesten112120.linux8664.tar.gz

timesten112120.linux8664.tar.gz

$ tar zxvf timesten112120.linux8664.tar.gz

linux8664/

linux8664/doc/

linux8664/doc/doc.zip

linux8664/3rdparty/

linux8664/3rdparty/jms-1_1-fr-apidocs.tar.bz2

linux8664/3rdparty/ant-1.6.2-bin.tar.bz2

linux8664/behaviorchanges.txt

linux8664/setup.sh

linux8664/uninst.sh

linux8664/LINUX8664/

linux8664/LINUX8664/timesten.tar.bz2

linux8664/LINUX8664/unzip

linux8664/LINUX8664/ttpatchinst

linux8664/LINUX8664/ttserver.tar.bz2

linux8664/LINUX8664/manifest

linux8664/LINUX8664/perl

linux8664/LINUX8664/common.tar.bz2

linux8664/LINUX8664/bzip2

linux8664/LINUX8664/ttclient.tar.bz2

linux8664/README.html

linux8664/install.pl

$ cd linux8664

$ ./setup.sh

ERROR: The /etc/TimesTen directory needs to be created for the instance registry

and 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

Try Again:

$ ./setup.sh

NOTE: Each TimesTen installation is identified by a unique instance name.

The instance name must be a non-null alphanumeric string, not longer

than 255 characters.

Please choose an instance name for this installation? [ tt1121 ] ttmb

Instance name will be 'ttmb'.

Is this correct? [ yes ]

Of the three components:

[1] Client/Server and Data Manager

[2] Data Manager Only

[3] Client Only

Which would you like to install? [ 1 ]

Where would you like to install the ttmb instance of TimesTen? [ /home/oracle ] /u02/TimesTen

Where 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, the

daemon port number must be the same across all TimesTen installations

managed by Oracle Clusterware.

NOTE: All installations that replicate to each other must use the same daemon

port number that is set at installation time. The daemon port number can

be 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 the

TimesTen installation to members of a single OS group. Only members of

that OS group will be allowed to perform direct mode connections to

TimesTen, and only members of that OS group will be allowed to perform

operations that access TimesTen data stores, TimesTen files and shared

memory. The OS group defaults to the primary group of the instance

administrator. You can default to this group, choose another OS group

or you can make this instance world-accessible. If you choose to make

this instance world-accessible, all database files and shared memory

are 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/info

Would you like to specify a different location for the daemon logs? [ no ] yes

Where would you like the daemon logs to be written? [ /u02/TimesTen/ttmb/info ] /u02/TimesTen/ttmb/log

The 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.ora

file 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/admin

You 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 ] yes

Where 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 the

QuickStart DemoDataStore directory in the default location,

/u02/TimesTen/ttmb/info/DemoDataStore

Where 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 ] yes

Please 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 -install

This 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.

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.so

DataStore=/u02/TimesTen/ttmb/info/TT/mb_db01

PermSize=100

TempSize=100

PLSQL=1

DatabaseCharacterSet=US7ASCII

start data store and test create user:

$ cd /u02/TimesTen/ttmb/bin

$ mkdir /u02/TimesTen/ttmb/info/TT

$ ./ttisql

Copyright (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 denied

The 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)

and Test PL/SQL (sample):

con1: Command>set serveroutput on

con1: Command> create or replace procedure hello_world as

begin

dbms_output.put_line('Hello World!');

end;

/

con1: Command> begin
> hello_world;
> end;
> /
Hello World!

That 's just simple to install , read more at doc, best practices