TimesTen错误总结

环境：

TimetsTen 11

oracle redhat 5.6 32bit

因为在sys.odbc文件内设置了auth验证，在通过ttbackup备份的时候提示：

[timesten@rac2 bin]$ ./ttbackup -dir /tmp -fname tt_workshops.bak dsn=tt_workshops
Backup started ...
Backup failed:
Error 7001: User authentication failed

[timesten@rac2 bin]$ ./ttbackup -dir /tmp -fname tt_workshops.bak "dsn=tt_workshops;uid=cacheuser;pwd=timesten;oraclepwd=cacheuser"
Backup started ...
Backup failed:
Error 15100: User CACHEUSER lacks privilege ADMIN

解决方式：

[timesten@rac2 bin]$ ./ttbackup -dir ./backup/ -fname tt_workshops.bak "dsn=tt_workshops;uid=;pwd=;oraclepwd=cacheuser"
Backup started ...
Backup complete
[timesten@rac2 bin]$

设置UIDPWD分别为空则可以，很弱智。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10130206/viewspace-1049414/，如需转载，请注明出处，否则将追究法律责任。