Oracle TimesTen Database нь мэдээллийг санах ойд байршуулж хурдтай ажиллах боломжийг олгоно.
[root@node219 linux8664tt70]# cd TT_INSTALL_DIRECTORY
[root@node219 linux8664tt70]# ./setup.sh
Of the following two choices :
[1] 32-bit Linux for x86
[2] 64-bit Linux for AMD64 and Intel EM64T processors
Which platform are you currently running? [ 2 ]
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? [ tt70 ] i2
Instance name will be 'i2'.
Is this correct? [ yes ] yes
Please select a product :
[1] Oracle TimesTen In-Memory Database
[2] Oracle In-Memory Database Cache
Which product would you like to install? [ 1 ]
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 i2 instance of TimesTen? [ /opt ]
Installing into /opt/TimesTen/i2 ...
Creating /opt/TimesTen/i2 ...
Uncompressing ...
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/i2/DemoDataStore
Where would you like to create the DemoDataStore directory? [ /var/TimesTen/i2 ]
Creating /var/TimesTen/i2/DemoDataStore ...
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 17001.
Do you want to use the default port number for the TimesTen daemon? [ yes ]
The daemon will run on the default port number (17001).
Processing /opt/TimesTen/i2/PERL/perl.tar ...
Would you like to enable datastore access control? [ no ] yes
The daemon logs will be located in /var/TimesTen/i2
Would you like to specify a different location for the daemon logs? [ no ]
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? [ 17003 ]
Starting TimesTen Daemon : [ OK ]
Installing client components ...
What is the name of the host running the TimesTen server? [ node219.oracle.me ]
What is the TCP/IP port number that the TimesTen server is listening on? [ 17003 ]
What is the name of the instance running the TimesTen server? [ i2 ]
Creating new /var/TimesTen/sys.ttconnect.ini
Extracting 3rd party tools ...
Would you like to install the documentation? [ yes ]
Where would you like to create the doc directory (s=skip)? [ /opt/TimesTen/i2/doc ]
The directory /opt/TimesTen/i2/doc does not exist.
Do you want to create it? [ yes ]
End of TimesTen installation.
[root@node219 linux8664tt70]#
Системийн орчныг тохируулахын тулд дараах коммандаар тохируулна.
source /opt/TimesTen/i2/demo/ttdemoenv.sh
Шалгах:
ttdaemonadmin -start
Холболт хийх тохиргоо (заавал байх шаардлагатай 3 утгыг оруулав):
[my_dsn]
DataStore=/timesten/data/active
PermSize=64
DatabaseCharacterSet=WE8MSWIN1252
Холболт хийх:
[root@node219 demo]# ttisql dsn=my_dsn
Copyright (c) 1996-2008, Oracle. All rights reserved.
Type ? or "help" for help, type "exit" to quit ttIsql.
All commands must end with a semicolon character.
connect "dsn=my_dsn";
830: Cannot create data store file. OS-detected error: No such file or directory
The command failed.
Done.
[root@node219 demo]#
DataStore үүсээгүй байгаа тул дээрхи алдаа гарч байна. Тиймээс анх холбогдохдоо AutoCreate=1 утгыг ашиглаж DataStore үүсгэнэ.
[root@node219 demo]# ttisql "dsn=my_dsn;AutoCreate=1"
Copyright (c) 1996-2008, Oracle. All rights reserved.
Type ? or "help" for help, type "exit" to quit ttIsql.
All commands must end with a semicolon character.
connect "dsn=active;AutoCreate=1";
Connection successful: DSN=active;UID=root;DataStore=/tt/data/active;DatabaseCharacterSet=WE8MSWIN1252;ConnectionCharacterSet=US7ASCII;PermSize=64;TypeMode=0;
(Default setting AutoCommit=1)
Command>
Системийн хүснэгтүүд харах:
Command>
Command> tables;
SYS.CACHE_GROUP
SYS.COLUMNS
SYS.COLUMN_HISTORY
SYS.COL_STATS
SYS.DUAL
SYS.INDEXES
SYS.MONITOR
SYS.OBJ_ACC_RIGHT
SYS.PLAN
SYS.SEQUENCES
SYS.SYNONYMS
SYS.SYS_ACC_RIGHT
SYS.TABLES
SYS.TABLE_HISTORY
SYS.TBL_STATS
SYS.TCOL_STATS
SYS.TINDEXES
SYS.TRANSACTION_LOG_API
SYS.TTABLES
SYS.TTBL_STATS
SYS.USERS
SYS.VIEWS
SYS.XLASUBSCRIPTIONS
TTREP.REPELEMENTS
TTREP.REPLICATIONS
TTREP.REPNETWORK
TTREP.REPPEERS
TTREP.REPSTORES
TTREP.REPSUBSCRIPTIONS
TTREP.REPTABLES
TTREP.TTSTORES
31 tables found.
Command>