Oracle – Linux – Network

1. setup env & create DSN
[root@test ~]# cd /opt/TimesTen/tt70/demo/
[root@test demo]# sh ttdemoenv.sh
LD_LIBRARY_PATH set to /opt/TimesTen/tt70/lib:/u01/app/oracle/product/11.1.0/db_1/lib:/lib:/usr/lib
ANT_HOME set to /opt/TimesTen/tt70/3rdparty/ant
PATH set to /opt/TimesTen/tt70/bin:/opt/TimesTen/tt70/demo/performance:/opt/TimesTen/tt70/demo/ttclasses:/opt/TimesTen/tt70/demo/xla:/opt/TimesTen/tt70/demo/xla/xlaPersistent:/opt/TimesTen/tt70/demo/tutorial/java:/opt/TimesTen/tt70/3rdparty/ant/bin:/u01/app/oracle/product/11.1.0/db_1/bin:/usr/sbin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/oracle/bin
CLASSPATH set to /opt/TimesTen/tt70/lib/classes14.jar:/opt/TimesTen/tt70/lib/timestenjmsxla.jar:/opt/TimesTen/tt70/3rdparty/jms1.1/lib/jms.jar:/opt/TimesTen/tt70/demo:/opt/TimesTen/tt70/demo/tutorial/java:.:/u01/app/oracle/product/11.1.0/db_1/JRE:/u01/app/oracle/product/11.1.0/db_1/jlib:/u01/app/oracle/product/11.1.0/db_1/rdbms/jlib
NOTE: The demos use system DSNs defined in
/var/TimesTen/sys.odbc.ini
To use your own DSNs, they must be defined in ~/.odbc.ini, or
you may set the environment variable ODBCINI to point to
the correct file.

2. install tools tptbm
[root@test ~]# cd /opt/TimesTen/tt70/demo/performance/
[root@test performance]# make -f Makefile tptbm
gcc -Os -finline-functions -I/opt/TimesTen/tt70/include -I/opt/TimesTen/tt70/demo/common -I/opt/TimesTen/tt70/include/ttclasses -o tptbm.o -c tptbm.c
gcc -Os -finline-functions -I/opt/TimesTen/tt70/include -I/opt/TimesTen/tt70/demo/common -I/opt/TimesTen/tt70/include/ttclasses -o utils.o -c /opt/TimesTen/tt70/demo/common/utils.c
gcc -Os -finline-functions -I/opt/TimesTen/tt70/include -I/opt/TimesTen/tt70/demo/common -I/opt/TimesTen/tt70/include/ttclasses -o ttgetopt.o -c /opt/TimesTen/tt70/demo/common/ttgetopt.c
gcc -o tptbm tptbm.o utils.o ttgetopt.o -L/opt/TimesTen/tt70/lib -Wl,-rpath,/opt/TimesTen/tt70/lib -ltten -lm

3. test timesten performance
a. test 1
[root@test performance]# ./tptbm -proc 4 -read 85 -insert 10 tptbmdata_tt70
Connecting to the data source
Populating benchmark data store
Waiting for 4 processes to initialize
Beginning execution with 4 processes: 85% read, 5% update, 10% insert, 0% delete

Elapsed time: 1.3 seconds
Transaction rate: 31570.6 transactions/second

b. test 2
[root@test performance]# ./tptbm -proc 4 -read 85 -insert 10 tptbmdata_tt70
Connecting to the data source
Populating benchmark data store
Waiting for 4 processes to initialize
Beginning execution with 4 processes: 85% read, 5% update, 10% insert, 0% delete

Elapsed time: 312.0 msec
Transaction rate: 128205.1 transactions/second

c. test 3
[root@test performance]# ./tptbm -proc 4 -read 85 -insert 10 tptbmdata_tt70
Connecting to the data source
Populating benchmark data store
Waiting for 4 processes to initialize
Beginning execution with 4 processes: 85% read, 5% update, 10% insert, 0% delete

Elapsed time: 1.2 seconds
Transaction rate: 33726.8 transactions/second

1. extract timesten
[oracle@test ~]$ tar xvf timesten70500.linux86.tar.gz
[oracle@test ~]$ cd linux86/
[oracle@test linux86]$ ls
3rdparty doc LINUX86 setup.sh
behaviorchanges.txt install.pl README.html uninst.sh

2. setup timesten
[oracle@test linux86]$ ./setup.sh
ERROR: You do not have permissions to create the directory
/etc/TimesTen. 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.

[oracle@test linux86]$ pwd
/home/oracle/linux86
[oracle@test linux86]$ su – root
Password:
[root@test ~]# cd /home/oracle/linux86/
[root@test linux86]# ./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.

a. instance name : tt70
Please choose an instance name for this installation? [ tt70 ]
Instance name will be ‘tt70′.
Is this correct? [ yes ]

b. select product : 1 Oracle TimesTen In-Memory Database
Please select a product :
[1] Oracle TimesTen In-Memory Database
[2] Oracle In-Memory Database Cache
Which product would you like to install? [ 1 ]

c. components : 1 Client/Server and Data Manager
Of the three components:
[1] Client/Server and Data Manager
[2] Data Manager Only
[3] Client Only

Which would you like to install? [ 1 ]

d. folder : /opt
Where would you like to install the tt70 instance of TimesTen? [ /opt ]
Installing into /opt/TimesTen/tt70 …
Creating /opt/TimesTen/tt70 …
Uncompressing …

e. DemoDataStore directory : /var/TimesTen/tt70/DemoDataStore
The TimesTen Demo applications can take up to 64 Mbytes of disk space.
Depending on how your system is configured, you may not want to create the
DemoDataStore directory in the default location,
/var/TimesTen/tt70/DemoDataStore

Where would you like to create the DemoDataStore directory? [ /var/TimesTen/tt70 ]
Creating /var/TimesTen/tt70/DemoDataStore …

f. port number : 17000
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 17000.

Do you want to use the default port number for the TimesTen daemon? [ yes ]
The daemon will run on the default port number (17000).
Processing /opt/TimesTen/tt70/PERL/perl.tar …

g. enable datastore access control : yes
Would you like to enable datastore access control? [ no ] yes
The daemon logs will be located in /var/TimesTen/tt70
Would you like to specify a different location for the daemon logs? [ no ]

NOTE: It appears that you are running version 4.1 of the g++
compiler. TimesTen ships with multiple sets of client libraries and server
binaries : one built with g++ 3.2.3, one with g++ 3.4.6, and one with
g++ 4.1.0. The installer has created links to the 4.1.0 library in the
<install_dir>/lib directory and to the 4.1.0 server binary in the
<install_dir>/bin directory. If you want to use a different compiler,
please modify the links to point to the desired library and server binary.

h. log all server Connects/Disconnects : yes
Installing server components …
Would you like to log all server Connects/Disconnects? [ yes ]
What is the TCP/IP port number that you want the TimesTen Server to listen on? [ 17002 ]
Starting TimesTen Daemon : [ OK ]

i. Installing client components, name of the host, TCP/IP port number, name of the instance
Installing client components …
What is the name of the host running the TimesTen server? [ test.localdomain ]
What is the TCP/IP port number that the TimesTen server is listening on? [ 17002 ]
What is the name of the instance running the TimesTen server? [ tt70 ]
Creating new /var/TimesTen/sys.ttconnect.ini
Extracting 3rd party tools …

j. install documentation
Would you like to install the documentation? [ yes ]
Where would you like to create the doc directory (s=skip)? [ /opt/TimesTen/tt70/doc ]
The directory /opt/TimesTen/tt70/doc does not exist.
Do you want to create it? [ yes ]
End of TimesTen installation.

3. Status TimesTen
[root@test ~]# /opt/TimesTen/tt70/bin/ttstatus
TimesTen status report as of Tue Dec 16 00:59:13 2008
Daemon pid 3370 port 17000 instance tt70
TimesTen server pid 3388 started on port 17002
No TimesTen webserver running
————————————————————————
Access control enabled.
End of report

4. Start / Stop TimesTen
[root@test ~]# /opt/TimesTen/tt70/bin/ttdaemonadmin -stop
TimesTen Daemon stopped.

[root@test ~]# /opt/TimesTen/tt70/bin/ttstatus
ttStatus: Could not connect to the TimesTen daemon.
If the TimesTen daemon is not running, please start it
by running “ttDaemonAdmin -start”.

[root@test ~]# /opt/TimesTen/tt70/bin/ttdaemonadmin -start
TimesTen Daemon startup OK.
[root@test ~]# /opt/TimesTen/tt70/bin/ttstatus
TimesTen status report as of Tue Dec 16 00:59:13 2008
Daemon pid 3370 port 17000 instance tt70
TimesTen server pid 3388 started on port 17002
No TimesTen webserver running
————————————————————————
Access control enabled.
End of report