Commands to Start TimesTen Service:

./ttdaemonadmin -start
./ttdaemonadmin -startserver

Commands to Stop TimesTen Service:

./ttdaemonadmin -stopserver
./ttdaemonadmin -stop

Command to get status of TimesTen DB:

./ttstatus

Note: Important to notice is whether the Data is loaded into RAM or not

Command to load the data into RAM:

./ttAdmin -connstr “dsn=DATA_SOURCE_NAME” -ramLoad

Command to unload data from RAM:

./ttAdmin -connstr “dsn=DATA_SOURCE_NAME” -ramUnload

Command to run quick query on the TimesTen DB:

./ttIsql -connstr “dsn=DATA_SOURCE_NAME” -e “SQL_STATEMENT_1; SQL_STATEMENT_2;”

Location of Log Files for Troubleshooting:

TimesTen/t1122/info, the two most important files are tterrors.log and ttmesg.log

If you would like to know more about Oracle TimesTen Database:

Overview: http://www.oracle.com/us/products/database/timesten/overview/index.html

Product Documentation: http://docs.oracle.com/cd/E13085_01/doc/index.htm