TimesTen cache to oracle的问题

it2022-05-05  150

按照官方文档安装好timesten后,并按T《imesTenCache 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 failedThe command failed.Done.

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

1. setting up cgDSN without user authentication.(UserID,OracleID,and OraclePassword is null )2. connect cgDSN and create user3. disconnect4. 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

相关资源:timesten系列五:如何定义cache,和后台oracle数据库同步数据

最新回复(0)