timesten升级
ttIsql "DSN=ttwind;UID=cacheuser;PWD=cacheuser;OraclePWD=cacheuser;"
--1.查看当前版本号
Command> version
TimesTen Release 11.2.2.7.0
Command> cachegroups;
Cache Group CACHEUSER.CACHETBLORDERS:
Cache Group Type: Read Only
Autorefresh: Yes
Autorefresh Mode: Incremental
Autorefresh State: On
Autorefresh Interval: 10 Seconds
Autorefresh Status: ok
Aging: No aging defined
Root Table: SCOTT.TBLORDERS
Table Type: Read Only
Command> select count(*) from scott.tblorders;
< 111001 >
--2.断开到TT的全部连接
--3.备份数据库以及配置文件
mkdir /backup
ttBackup -type fileFull -dir /backup -fname ttwindbk -force -connstr "DSN=ttwind"
cp /data/app/timesten/TimesTen/ttwind/info/sys.odbc.ini /backup/
cp /data/app/timesten/TimesTen/ttwind/tnsnames.ora /backup/
--4.删除cachegroup
ttIsql "DSN=ttwind;UID=cacheuser;PWD=cacheuser;OraclePWD=cacheuser;"
call ttcachestop;
DROP Cache Group cachetblorders;
exit;
--5.卸载内存
ttDaemonAdmin -stop
ttadmin -ramunload ttwind --二选一
--6.毁坏数据库
ttDestroy ttwind;
--7.删除旧文件夹 (可选)
rm -rf /etc/TimesTen/
rm -rf /data/app/timesten/
--7.install timesten new version
mkdir /etc/TimesTen
mkdir -p /data/app/timesten
chgrp -R ttadmin /etc/TimesTen
chgrp -R ttadmin /data/app/timesten
chmod 770 /etc/TimesTen/
chmod 770 /data/app/timesten
chmod 660 /etc/TimesTen/*
chown -R ocpyang.ttadmin /soft
ls /soft
unzip tt11.2.2.8.2\ .zip
cd /soft/linux8664/
$ ./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.
#步骤1:输入安装实例名称
Please choose an instance name for this installation? [ tt1122 ] ttwind #输入自己定义的名字
Instance name will be 'ttwind'.
Is this correct? [ yes ] yes
#步骤2:安装组件
Of the three components:
[1] Client/Server and Data Manager
[2] Data Manager Only
[3] Client Only
Which would you like to install?
[ 1 ] 1 #输入1
#步骤3:安装位置
Of the following options :
[1] /home/ocpyang
[2] /soft
[3] Specify a location
[q] Quit the installation
Where would you like to install the ttwind instance of TimesTen? [ 1 ] 3 #输入3 自己定义一个安装文件夹
Please specify a directory to install TimesTen?
[ /home/ocpyang ] /data/app/timesten/ #输入自己定义一个安装文件夹
Where would you like to create the daemon home directory? [ /data/app/timesten/TimesTen/ttwind/info ]
The daemon logs will be located in /data/app/timesten/TimesTen/ttwind/info
Would you like to specify a different location for the daemon logs?
[ no ]
Uncompressing ...
NOTE: If you are configuring TimesTen for use with Oracle Clusterware, the
daemon port number must be the same across all TimesTen installations
managed within the same Oracle Clusterware cluster.
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'.
#步骤4:输入自己定义的主进程port号
The default port number is 53396.
Do you want to use the default port number for the TimesTen daemon?
[ yes ] no #输入no 自己定义端口
Please enter a unique port number for the TimesTen daemon (<CR>=list)? [ ] 53355 #输入自己定义端口
NOTE: For security, we recommend that you restrict access to the
TimesTen installation to members of a single OS group. Only members of
that OS group will be allowed to perform direct mode connections to
TimesTen, and only members of that OS group will be allowed to perform
operations that access TimesTen data stores, TimesTen files and shared
memory. The OS group defaults to the primary group of the instance
administrator. You can default to this group, choose another OS group
or you can make this instance world-accessible. If you choose to make
this instance world-accessible, all database files and shared memory
are readable and writable by all users.
#步骤5:受限会话和PL/SQL功能默认就可以
Restrict access to the the TimesTen installation to the group 'ttadmin'? [ yes ]
NOTE: Enabling PL/SQL will increase the size of some TimesTen libraries.
Would you like to enable PL/SQL for this instance? [ yes ] yes
#步骤6:安装的时候指定TNS_ADMIN环境变量
------------------------------------------------------------------------------
切记:最后的 tnsnames.ora须要放入这个文件夹一份,否则报错
Command> create readonly cache group cachtest
> from scott.t2
> (
> sid int not null primary key,
> sname varchar2(10)
> );
Warning 5923: Cache agent has deferred the create/alter cache group request because it is not connected to Oracle yet
或
Command> load cache group cachtest commit every 10 rows;
5056: The cache operation fails: error_type=<Oracle Error>, error_code=<12541>, error_message: ORA-12541: TNS:no listener
The command failed.
------------------------------------------------------------------------------
In order to use the 'In-Memory Database Cache' feature in any databases
created within this installation, you must set a value for the TNS_ADMIN
environment variable. It can be left blank, and a value can be supplied later
using <install_dir>/bin/ttModInstall.
TNS_ADMIN exists in your environment and is set to :
/u01/app/oracle/product/11.2.0/db_1/network/admin
Would you like to use this TNS_ADMIN setting for the Oracle TimesTen Application-Tier Database Cache?
[ yes ] no
Please enter a value for TNS_ADMIN (s=skip)? [ ] /data/app/timesten/TimesTen/ttwind
#输 /data/app/timesten/TimesTen/ttwind
TNS_ADMIN will be set to /app/timesten/TimesTen
You can change TNS_ADMIN later by running <install_dir>/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
<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.
Installing server components ...
#步骤7:TimesTenserverport号
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? [ /data/app/timesten/TimesTen/ttwind/doc ]
The TimesTen documentation has been installed in /data/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 /data/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 :
'/data/app/timesten/TimesTen/ttwind/startup/tt_ttwind'.
The 11.2.2.8 Release Notes are located here :
'/data/app/timesten/TimesTen/ttwind/README.html'
Starting the daemon ...
TimesTen Daemon startup OK.
End of TimesTen installation.
---拷贝老版本号的配置文件和tnsnames.ora
cp /backup/tnsnames.ora /data/app/timesten/TimesTen/ttwind/
cp /backup/sys.odbc.ini /data/app/timesten/TimesTen/ttwind/info/sys.odbc.ini
mkdir -p /data/app/timesten/TimesTen/ttwind/info/datastore/ttwind
chmod -R 770 /data/app/timesten/TimesTen/ttwind/info/datastore/ttwind
----使用管理员启动
ttIsql ttwind
---确定数据库里相关的用户权限是否存在
Command> select * from SYS.CACHE_GROUP;
< CACHETBLORDERS , CACHEUSER , 3846792, 1798032, 906F1B0000000000, 0000000000000000, #, SCOTT.TBLORDERS#, #, ORCL\000\000\000\000, 0, 1, \000\000\000\000, I, Y, 0, <NULL>, 10000, 0, 05010000, 383632303000000000000000000000000000000000000000000000000000000000000000000000,
88555\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\0003801151501201532021515012015, 10000, 0, <NULL>, <NULL>, <NULL>, <NULL>, <NULL>, 00000000 >
1 row found.
Command> select * from sys.user$;
< 0, SYS , 1, 0, <NULL>, 2015-01-08 11:30:35.496049, <NULL>, <NULL>, 2825416, 0, 0, 0000, 00000000000000000000000000000000 >
< 1, PUBLIC , 0, 0, <NULL>, 2015-01-08 11:30:35.496049, <NULL>, <NULL>, 2825432, 0, 0, 0000, 00000000000000000000000000000000 >
< 2, TTREP , 1, 0, <NULL>, 2015-01-08 11:30:35.496049, <NULL>, <NULL>, 2825448, 0, 0, 0000, 00000000000000000000000000000000 >
< 3, SYSTEM , 1, 0, <NULL>, 2015-01-08 11:30:35.496049, <NULL>, <NULL>, 2825464, 0, 0, 0000, 00000000000000000000000000000000 >
< 4, GRID , 1, 0, <NULL>, 2015-01-08 11:30:35.496049, <NULL>, <NULL>, 2825480, 0, 0, 0000, 00000000000000000000000000000000 >
< 10, OCPYANG , 1, 0, <NULL>, 2015-01-08 11:30:35.496049, <NULL>, <NULL>, 2825496, 1, 0, 0000, 00000000000000000000000000000000 >
< 11, CACHEUSER , 1, 0, $tten1$03e8$Hg2tjjsbKclse9mQNUe1WgVjkA6ztp0nl9lQBFdDR0JcGzhq, 2015-01-08 11:33:10.551269, <NULL>, <NULL>, 2825512, 0, 0, 0000, 00000000000000000000000000000000 >
< 12, SCOTT , 1, 0, $tten1$03e8$nUihKq91gkCULnhgrkcmcTBcPa/HjbBnR3xrcAy96XZovf7n, 2015-01-08 11:33:29.371828, <NULL>, <NULL>, 2825528, 0, 0, 0000, 00000000000000000000000000000000 >
--8.恢复数据
ttDaemonAdmin -start
rm -rf /data/app/timesten/TimesTen/ttwind/info/datastore/ttwind.ds*
rm -rf /data/app/timesten/TimesTen/ttwind/info/datastore/ttwind.log*
rm -rf /data/app/timesten/TimesTen/ttwind/info/datastore/ttwind.res**
ttRestore -dir /backup -fname ttwindbk -noconn -connstr "DSN=ttwind"
ttIsql "DSN=ttwind;UID=cacheuser;PWD=cacheuser;OraclePWD=cacheuser;"
call ttCacheStart;
---9.验证恢复结果
$ ttversion
TimesTen Release 11.2.2.8.2 (64 bit Linux/x86_64) (ttwind:53355) 2015-02-24T18:59:40Z
Instance admin: ocpyang
Instance home directory: /data/app/timesten/TimesTen/ttwind
Group owner: ttadmin
Daemon home directory: /data/app/timesten/TimesTen/ttwind/info
PL/SQL enabled.
Command> version
TimesTen Release 11.2.2.8.2
Command> cachegroups;
Cache Group CACHEUSER.CACHETBLORDERS:
Cache Group Type: Read Only
Autorefresh: Yes
Autorefresh Mode: Incremental
Autorefresh State: On
Autorefresh Interval: 10 Seconds
Autorefresh Status: C
Aging: No aging defined
Root Table: SCOTT.TBLORDERS
Table Type: Read Only
1 cache group found.
Command> select count(*) from scott.tblorders;
< 111001 >
1 row found.