1 Reply Latest reply: Sep 13, 2013 8:32 AM by Chrisjenkins-Oracle RSS

    Timesten error

    PACHAURI ABHISHEK

      Hi

       

       

      Facing timesten error while  starting cache agent

       

      ttadmin -cachestart dsn_name

       

      *** [TimesTen][TimesTen 11.2.1.8.0 ODBC Driver][TimesTen]TT0848: Recovery failed on 2 set(s) of data store files; the TimesTen user error log has more information -- file "db.c", lineno 10491, procedure "sbDbConnect"

      *** ODBC Error = 08001, TimesTen Error = 848

       

      Please help

        • 1. Re: Timesten error
          Chrisjenkins-Oracle

          There was a problem recovering the Timesten database. The most common cause for this is that the database checkpoint files or (more commonly) transaction log files have been damaged or corrupted. For example sometimes people manually delete or move transaction log files if they are running low on disk space (which is an extremely bad idea of course).

           

          You need to look in the daemon log files (the field ttmesg.log and tterrors.log located in <tt_install_dir>/info) and see the exact messages produced when you try and startup this TimesTen database (which is happening implicitly when you start the cache agent). Those messages will give you more details on the cause. Depending on what they say it is possible that this database is now unrecoverable.

           

          Chris