3 Replies Latest reply on Nov 17, 2011 2:27 PM by 900637

    TT14010: TimesTen daemon spawn failed: Error starting TimesTen Server

    900637
      I've just installed TimesTen on a Win 32 bit server that also runs my EBS R12 and it appears to not start the TimesTen server..
      I am able to connect using ttIsql on the machine and see some system table etc....
      Trying to connect from a client with the odbc "Test Oracle TimesTen Server Connection" All tests succeeded until last Check Oracle TimesTen Server is started: Failed

      So I took a look at the status on the server

      ttstatus shows:

      C:\Documents and Settings\oracle>ttdaemonadmin -startserver
      Error 400 from TimesTen daemon: 'Error starting TimesTen Server.'

      C:\Documents and Settings\oracle>ttstatus
      TimesTen status report as of Wed Nov 16 15:40:57 2011

      Daemon pid 7868 port 53384 instance tt1121_32
      No TimesTen server running
      ------------------------------------------------------------------------
      Data store c:\my_ttdb\myttdb
      There are 10 connections to the data store
      Shared Memory KEY Global\myttdb.c||my_ttdb.SHM.6 HANDLE 0x2b0
      PL/SQL Memory KEY Global\myttdb.c||my_ttdb.SHM.7 HANDLE 0x2b8 Address 0x5B8C0000

      Type PID Context Connection Name ConnID
      Subdaemon 7888 0x00e2c398 Manager 2032
      Subdaemon 7888 0x00e7cf28 Rollback 2033
      Subdaemon 7888 0x018838c0 Flusher 2037
      Subdaemon 7888 0x01894410 Monitor 2034
      Subdaemon 7888 0x018a4f60 Deadlock Detector 2036
      Subdaemon 7888 0x01955b50 Checkpoint 2035
      Subdaemon 7888 0x0198f008 Aging 2039
      Subdaemon 7888 0x0c580048 AsyncMV 2041
      Subdaemon 7888 0x0c590b98 Log Marker 2038
      Subdaemon 7888 0x0c601008 HistGC 2040
      RAM residence policy: Always
      Replication policy : Manual
      Cache Agent policy : Manual
      PL/SQL enabled.
      ------------------------------------------------------------------------
      Data store c:\docume~1\oracle\applic~1\timesten\demoda~1\cachedb1_1121
      There are 10 connections to the data store
      Shared Memory KEY Global\cachedb1_1121.c||docume~1|oracle|applic~1|timesten|demo
      da~1.SHM.18 HANDLE 0x290
      PL/SQL Memory KEY Global\cachedb1_1121.c||docume~1|oracle|applic~1|timesten|demo
      da~1.SHM.19 HANDLE 0x294 Address 0x5B8C0000
      Type PID Context Connection Name ConnID
      Subdaemon 7864 0x00e2c398 Manager 2032
      Subdaemon 7864 0x00e7cf28 Rollback 2033
      Subdaemon 7864 0x01870e80 Flusher 2034
      Subdaemon 7864 0x018819d0 Monitor 2038
      Subdaemon 7864 0x018d2560 Deadlock Detector 2035
      Subdaemon 7864 0x018e30b0 Checkpoint 2037
      Subdaemon 7864 0x018f3c00 Aging 2039
      Subdaemon 7864 0x01984ab8 Log Marker 2036
      Subdaemon 7864 0x0c8a0068 AsyncMV 2041
      Subdaemon 7864 0x0c8e0be8 HistGC 2040
      RAM residence policy: Always
      Replication policy : Manual
      Cache Agent policy : Manual
      PL/SQL enabled.
      ------------------------------------------------------------------------
      Accessible by group BUILTIN\Administrators
      End of report


      Then I looked in the logs as I think this process is supposed to start automatically.
      Logs:
      14:27:35.06 Err : : 4200: Failed to forcefully kill process -1
      14:27:38.19 Warn: : 4904: subd not sending crs notification, no valid socket
      14:27:39.59 Warn: : 4200: 4904 ------------------: subdaemon process exited
      14:27:39.59 Warn: : 4200: 4904 exited while connected to data store 'c:\docume~1\oracle\applic~1\timesten\demoda~1\cachedb1_1121' shm 'Global\cachedb1_1121.c||docume~1|oracle|applic~1|timesten|demoda~1.SHM.14' count=10
      14:27:39.65 Warn: : 4884: subd not sending crs notification, no valid socket
      14:27:39.67 Warn: : 4892: subd not sending crs notification, no valid socket
      14:27:39.70 Warn: : 4912: subd not sending crs notification, no valid socket
      14:27:39.70 Err : : 4200: Failed to forcefully kill process -1
      14:27:44.73 Warn: : 7868: TimesTen Daemon Release 11.2.1.8.0.tt1121_32 started.
      14:27:54.99 Warn: : 7868: 7864/00E2C398: Recovery started
      14:41:55.88 Warn: : 7888: subd not sending crs notification, no valid socket
      15:02:21.51 Err : : 7868: TT14010: TimesTen daemon spawn failed: Process #1000005 never connected
      15:02:21.51 Err : : 7868: TT14010: TimesTen daemon spawn failed: Error starting TimesTen Server.


      15:06:19.79 Info: : 7868: maind got #20.204, hello: pid=6968 type=utility payload=%00%00%00%00 protocolID=TimesTen 11.2.1.8.0.tt1121_32 ident=%00%00%00%00
      15:06:19.79 Info: : 7868: 6968 ------------------: Utility program registering
      15:06:19.79 Info: : 7868: maind: done with request #20.204
      15:06:19.79 Info: : 7868: maind got #20.205 from 6968, start server:
      15:06:19.79 Info: : 7868: Spawning 'c:\timesten\tt1121~1\bin\ttcserver1121.exe'
      15:06:19.79 Info: : 7868: Spawned new process (ttcserver1121.exe), idx 1000006, handle 0x2bc=700
      15:07:25.44 Info: : 7868: waitForConnect - waited too long
      15:07:25.44 Info: : 7868: waitForConnect failed for process #1000006
      15:07:25.44 Err : : 7868: TT14010: TimesTen daemon spawn failed: Process #1000006 never connected
      15:07:25.44 Info: : 7868: Mark process #1000006 as down (0)
      15:07:25.44 Err : : 7868: TT14010: TimesTen daemon spawn failed: Error starting TimesTen Server.
      15:07:25.44 Info: : 7868: maind: done with request #20.205
      15:07:25.55 Info: : 7868: maind 20: socket closed, calling recovery (last cmd was 205)
      15:07:25.55 Info: : 7868: Starting daRecovery for 6968
      15:07:25.55 Info: : 7868: Finished daRecovery for pid 6968.

      Win Server name is : ebs1211app
      TimesTen Release 11.2.1


      Any ideas on how I can get the TimesTen server running
      Thanks in advance!
        • 1. Re: TT14010: TimesTen daemon spawn failed: Error starting TimesTen Server
          Jspalmer-Oracle
          I know Chris has seen this type of problem before, where the server fails to start on TT11g on Win 32b. In this case it led to Chris logging this (unpublished) bug

          Bug 11727788: NEED TO PACKAGE AND INSTALL REQUIRED MS VC++ RUNTIME FILES WITH TIMESTEN

          This bug is fixed in 11.2.1.8.3. I can't see which exact version you're using..?

          The bug explains what the problem is:

          I have logged this against 32-bit Windows but it is may well also be relevant
          for 64 bit Windows (needs investigation).

          Programs built with Microsoft Visual Studio C++ generally have dependencies
          on one or more of the Visual C++ run-time libraries. These are DLLs such as
          MSVCRxx.DLL, MSVCPxx.DLL and so forth where XX represents the version ofthe
          compiler they were built with. TimesTen 11.2.1.8.0 has dependencies on MSVCR71.DLL and
          MSVP71.DLL.

          In general, a Windows installation will not have these DLLs present unless
          (a) the corresponding Visual C++ compiler package has been installed or (b)
          the relevant (free) Visual C++ runtime package has been installed. Thus, in
          general, [rpgrams built using Visual C++ cannot be guaramntee to work on an
          arbitrary Windows installation. For this reason, Microsoft allows, and indeed
          recommends, that certain runtime files (including but not limited to
          MSVCRxx.DLL and MSVCPxx.DLL) can be redistributed, free of charge, with
          applications.

          Currently, the TimesTen distribution does not include these files which can
          lead to it failing to work after installation on systems that do not have
          these files.

          We should determine what runtime files are required and package those, in the
          Microsoft recommended manner, as part of the TimesTen installation in order
          to avoid these problems.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       
          • 2. Re: TT14010: TimesTen daemon spawn failed: Error starting TimesTen Server
            900637
            How does one go about getting 11.2.1.8.3 I only see 11.2.1.8.0 on the TimesTen download page

            It may make sense too as the client DNS would not work saying there was a missing dll on the server "MSVCP71.dll" was not found... I just skipped by, put the client on a development machine and it test ok until checking the Timesten server.

            I did install the Visual Studio Team System 2008 Development edition on this server when i initially setup Oracle EBS, and i see msvcr71.dll and msvcp50, msvcp60 but not msvcp71.dll

            I'll try to find what would install msvcp71.dll and see if the server starts up...

            Thanks
            • 3. Re: TT14010: TimesTen daemon spawn failed: Error starting TimesTen Server
              900637
              That did the trick, just downloaded the one dll and restarted the server and it's all running!! No I need to figure out how to load some tables into it..

              Thanks for your quick answers!