实战:oracletimesten11.2.2.7.0oncentos6.5(二)
rect? [ 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 ] /app/timesten #输入自定义一个安装目录
Where would you like to create the daemon home directory? [ /app/timesten/TimesTen/ttwind/info ]
The daemon logs will be located in /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 (=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=, 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 /bin/ttModInstall.
Please enter a value for TNS_ADMIN (s=skip)? [ ]/app/timesten/TimesTen/ttwind/ #输入/app/timesten/TimesTen/ttwind/n
TNS_ADMIN will be set to /app/timesten/TimesTen
You can change TNS_