TImesTen суулгах


#1

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>