timesten升級，timesten

timesten升級，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：輸入自訂的主進程連接埠號碼

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: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? [ /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.