Problem Restoring A Database From Timesten With larger PERM And TEMP Size to a new system with smaller perm/temp size

(Doc ID 1628487.1)

Last updated on FEBRUARY 27, 2016

Applies to:

Oracle TimesTen In-Memory Database - Version 11.2.1 and later
Information in this document applies to any platform.


Cannot restore db to different machine with different size.

The machine where the db is backup from has larger memory footprint.  The machine where the restoring of the backup file has much smaller memory.  This is the error encountered:

$ ttrestore -fname bk.bac -dir /tmp/ttbackup/  dsn1
Restore started ...
ttRestore: SQL Error: Failed to connect to data store

*** [TimesTen][TimesTen ODBC Driver][TimesTen]TT0703: Subdaemon connect to data store failed with error TT802 -- file "db.c", lineno 9759, procedure "sbDbConnect"
*** ODBC Error = 08001, TimesTen Error = 703

ttRestore: Failed connecting to data store after restore


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms