TimesTen錯誤總結

環境：

TimetsTen 11

oracle redhat 5.6 32bit

[@more@]

因為在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分別為空則可以，很弱智。