实战:oracletimesten11.2.2.7.0oncentos6.5(四)
ADMIN later by running /bin/ttmodinstall.
NOTE: It appears that you are running version 4 or higher of the g++
compiler. TimesTen ships with multiple sets of client libraries and server
binaries : one built for compatibility 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
/lib directory and to the 4.1.0 server binary in the
/bin directory. If you want to use a different compiler,
please modify the links to point to the desired library and server binary.
Installing server components ...
#步骤7:TimesTen服务器端口号
Installing server components ...
What is the TCP/IP port number that you want the TimesTen Server to listen on? [ 53356 ] 53356 #主进程端口号加1
Do you want to install the Quick Start Sample Programs and the TimesTen Documentation? [ no ]
Would you like to install the documentation (without the Quick Start Sample Programs)? [ yes ]
Where would you like to create the doc directory? [ /app/timesten/TimesTen/ttwind/doc ]
The TimesTen documentation has been installed in /app/timesten/TimesTen/ttwind/doc.
Installing client components ...
Would you like to use TimesTen Replication with Oracle Clusterware? [ no ]
NOTE: The TimesTen daemon startup/shutdown scripts have not been installed.
Run the 'setuproot' script :
cd /app/timesten/TimesTen/ttwind/bin
./setuproot -install
This will move the TimesTen startup script into its appropriate location.
The startup script is currently located here :
'/app/timesten/TimesTen/ttwind/startup/tt_ttwind'.
The 11.2.2.7 Release Notes are located here :
'/app/timesten/TimesTen/ttwind/README.html'
Starting the daemon ...
TimesTen Daemon startup OK.
End of TimesTen installation.
---3.3设置用户变量
vi ~/.bash_profile
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1
export TNS_ADMIN=$ORACLE_HOME/network/admin
export TT_HOME=/app/timesten/TimesTen/ttwind/
export PATH=$PATH:$TT_HOME/bin:$ORACLE_HOME/bin
LD_LIBRARY_PATH=/app/timesten/TimesTen/ttwind/lib
export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib:$ORACLE_HOME/lib
source ~/.bash_profile
---3.4 拷贝tnsnames文件
cp /u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora /app/timesten/TimesTen/ttwind/
************************************************************************
4.新建缓存实例
************************************************************************
---------4.1 Oracle
数据库创建相关用户和权限
--步骤1：新建表空间存储timesten的数据字典表
CREATE TABLESPACE ttspace DATAFILE
'/u01/app/oracle/oradata/orcl/ttspace01.dbf'
SIZE 10M autoextend on next 10m maxsize 30g;
@ $TT_HOME/oraclescripts/initCacheGlobalSchema.sql "TTSPACE"
alter user timesten identified by timesten;
--步骤2：新建数据库同步用户
create user cacheuser identified by cacheuser
DEFAULT TABLESPACE TTSPACE
QUOTA UNLIMITED ON TTSPACE;
grant connect,resource to cacheuser;
@ $TT_HOME/oraclescripts/grantCacheAdminPrivileges "cacheuser"
--步骤3：授权表给cacheuser用户
conn scott/tiger
create table t1
(
sid int not null primary key,
sname varchar2(10)
);
insert into t1 values(101,'wind');
insert into t1 values(102,'snow');
grant select,insert,update,delete on scott.t1 to cacheuser;
grant all on scott.t1 to cacheuser;
-