TimesTen cache to oracle的问题

按照官方文档安装好timesten后，并按T《imesTen
Cache Connect to Oracle Guide》建一个数据源cgDSN，可ttIsql cgDSN时报错

 

>ttisql cgdsn

Copyright (c) 1996-2006, Oracle. All rights reserved.
Type ? or "help" for help, type "exit" to quit ttIsql.
All commands must end with a semicolon character.

connect "DSN=cgdsn";
Enter password for 'test':
7001: User authentication failed
The command failed.
Done.

终于在一个BBS上找到解决办法

1. setting up cgDSN without user authentication.
(UserID,OracleID,and OraclePassword is null )
2. connect cgDSN and create user
3. disconnect
4. setting up cgDSN with user authentication
(set UserID,OracleID and OraclePassword)
5. connect

原来是那个文档说不够详细，应该是先在timesten建立相应用户，再连接到oracle

转载于:https://www.cnblogs.com/seawwh/archive/2011/11/04/2235875.html