Group management user password operation standard processLog in to the master node and modify the Cache Group Admin user password:Master node:$ ttisql $DSNcommand> alter user cgadmin identified by "CGPASSWD";User altered.The command succeeded.8, after the master node has been successfully modified, the login standby node authentication password:$ttisql "dsn= $DSN; uid=cgadmin;pwd=szng!123"Copyright (c) 1996-2011, Oracle. All rights reserved.Type? or
TT end Cache Group management user password operation standard processLog in to the master node and change the cache group management user password:Master node:$ ttisql $DSNcommand> alter user cgadmin identified by "CGPASSWD";User altered.The command succeeded.8, after the master node changes successfully. Login Standby node Authentication password:$ttisql "dsn= $DSN; uid=cgadmin;pwd=szng!123"Copyright (c) 1996-2011, Oracle. All rights reserved.Type?
A very handy data import tool Tttableschemafromoraqueryget and Ttloadfromoracle are added to the TimesTen 11.2.2 release.
You can simply load the table structure and data quickly into the memory library without using the cache group. However, this method can not achieve automatic data refresh, in order to maintain the consistency of data, you must manually to execute the Refresh command.
Introduction to Usage:
1, configure the Tnsnames.ora file, add a
Practice: oracle timesten 11.2.2.7.0 on centos 6.5, timestencentos
Entry level, but the steps are more detailed, there is no theory, can be used as an entry manual.
**************************************** * ******************************** 1. create a user ************************************** *********************************** ----- 1. create OS user and group groupadd ttadmingroupadd
location [Q] Quit the installationwhere would your like to install the TTWI nd instance of TimesTen? [1] 3 #输入3 Customizing an installation directory specify a directory to install TimesTen? [/home/ocpyang]/app/timesten #输入自定义一个安装目录Where would to create the daemon home directory? [/app/timesten/
I think timesten is a bit more powerful. You can directly load the entire table to the timesten cache database through ttisql. The following is an example.
1. Create a table "test" in oracle ".
CREATE TABLE "LION"."TEST" ("ID" number PRIMARY KEY NOT NULL,"NAME" varchar2(20 byte),"NOTE" varchar2(20 byte),"MARK" varchar2(20 byte) );
2. Insert 500000 data entries in
Setting up connectivity to an Oracle database is simple, but it is also a very important task. After all, the integration of TimesTen with Oracle, compared to the standalone TimesTen, is a more extensive scenario.Whether you follow up the cache Group or simply load data from Oracle
I think timesten is a bit more powerful. You can directly load the entire table to the timesten cache database through ttisql. The following is an example. 1. Create a table "test" in oracle ".
I think timesten is a bit more powerful. You can directly load the entire table to the t
The ORACLE tutorial is: Oracle acquires TimesTen to improve database software performance. Oracle announced in June 9 that it had agreed to acquire TimesTen, a private software company whose products can improve the performance of database applications that require rapid res
How to map a table to timesten In oracle
---- 1. Run the createandloadfromoraquery command and enable six threads.
Command> createandloadfromoraquery scott. t1 6 select * from scott. t1;
---- 2. Use built-in commands to import data
Command> call ttTableSchemaFromOraQueryGet ('Scott ', 't1', 'select * FROM scott. t1 ');
Command> create table "SCOTT". "T1 "("SID" number (38,0) not null,"SNAME" varchar
Oracleing table to timesten In oracle, oracletimesten
---- 1. Run the createandloadfromoraquery command and enable six threads.
Command> createandloadfromoraquery scott. t1 6 select * from scott. t1;
---- 2. Use built-in commands to import data
Command> call ttTableSchemaFromOraQueryGet ('Scott ', 't1', 'select * FROM scott. t1 ');
Command> create table "SCOTT". "T1 "("SID" number (38,0) not null,"SN
The Oracle tutorial being looked at is: Oracle acquisition TimesTen improve database software performance. Oracle announced June 9 that it agreed to buy TimesTen, a private software company that enhances the performance of database applications that require fast response tim
installation
Where wocould you like to install the ttwind instance of TimesTen? [1] 3 # input 3 to customize an installation directoryPlease specify a directory to install TimesTen? [/Home/ocpyang]/data/app/timesten/# enter a custom installation directoryWhere wocould you like to create the daemon home directory? [/Data/app/
Label:----1.createandloadfromoraquery command and open 6 threadsCommand>createandloadfromoraquery scott.t1 6 SELECT * from SCOTT.T1;----2. Complete data import with built-in commandsCommand>call tttableschemafromoraqueryget (' Scott ', ' T1 ', ' SELECT * from Scott.t1 ');Command>create TABLE "SCOTT". " T1 "("SID" number (38,0) is not NULL,"SNAME" varchar2 (ten bytes)) ;Command>call ttloadfromoracle (' Scott ', ' t1 ', ' select * from Scott.t1 ');Command>select * from Scott.t1;Methods for mapping
ConceptThe concept of logical server name (logical server name) in TimesTen is rarely used, but it is necessary to understand it.First, logical server is defined on the client, pointing to the server side.Second, you must use logical server name when using a non-TCP/IP communication protocol or TimesTen server not listening on the default port.
A logical server name is a definition for a server sys
standby is not yet established, then active can concurrently assume responsibility for receiving business read-write and synchronizing data with Oracle.When standby becomes new active, TimesTen overrides the configuration cache group, allowing the new standby to assume the task of synchronizing with Oracle.Take a look at the copy on the right from standby to read-only subscriber, where the copy target on the read-only subscriber is not the table in t
Given the speed of recovery and disk loading to memory, the data that a single TimesTen database can cache is typically no more than 100G, and if you need to cache large data, you can generally use multiple timesten to achieve data partitioning or sharding (sharding).Although the TimesTen has the concept of the cache grid, which is the global cache group, it is g
TimesTen reconstruction of the backup machine standard operation [TimesTen O M]
During TimesTen's O M process, rebuilding the slave is the most frequently performed operation in daily O M. Here we record the operation steps for rebuilding the slave, Which is easy for beginners to refer.1. comment out the scheduled task script$ Crontab-e: % S/^/#/g2. Check master-slave SynchronizationTtisql-connstrCommand
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.