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