9 Replies Latest reply on Aug 15, 2018 6:44 AM by ChrisJenkins-Oracle

    Unable to open the ODBC.INI data sources root

    Dmitrii Dunaev
    Dmitrii Dunaev Aug 13, 2018 2:27 PM

      Hello everyone.

       

      I get "Unable to open the ODBC.INI data sources root " in the log file (srv\info\tterrors.log) every time Oracle tries to start the server.

      Documentation describes this error by saying "Windows platform only. TimesTen Server could not open HKEY_LOCAL_MACHINE\SOFTWARE \ODBC\ODBC.INI\ODBC Data Sources key from registry. Contact customer support for assistance."

      Does anybody know how to fix the issue?

       

      Thank you in advance

        • 1. Re: Unable to open the ODBC.INI data sources root
          ChrisJenkins-Oracle
          ChrisJenkins-Oracle Aug 13, 2018 4:14 PM (in response to Dmitrii Dunaev)

          Hi,

           

          Firstly, can you confirm that you are indeed running TimesTen on Windows (your post suggests that you are but I just want to be sure).

           

          Could this be a permissions issue? Do you have any specific permission set for that registry key path in the registry and if so does the user that the TimesTen service is running as have permission to read that key and all of its subordinates? Did you encounter any issues when you installed TimesTen? Is the user that the TimesTen service is configured to run as a member of the Administrators group?

           

          Thanks,

           

          Chris

          • 2. Re: Unable to open the ODBC.INI data sources root
            Dmitrii Dunaev
            Dmitrii Dunaev Aug 14, 2018 7:14 AM (in response to ChrisJenkins-Oracle)

            Hello Chris.

             

            I run TimesTen 11.2.2 (64 bit) on Windows 7 SP1 64-bit. I do not have any specific permissions set for the registry path. I installed it under my own user, which has administrator priviliges on this machine. The registry path has all permissions set for my user as a user and as an administrator. I did not encounter any issues during the installation process. I did not even know there were any issues until I tried to connect remotely to the timesten. Only then I reliazed that the server process was not running. Then I tried to start it and got message saying that the server is being restarted. And it actually was, that's my log files kept growing, because it could never restart it.

             

            Thank you in advance.

            • 3. Re: Unable to open the ODBC.INI data sources root
              ChrisJenkins-Oracle
              ChrisJenkins-Oracle Aug 14, 2018 1:36 PM (in response to Dmitrii Dunaev)

              Hi Dmitrii,

               

              This is not an issue that I have encountered before so I don't have an immediate solution to suggest.

               

              Can you please provide:

               

              1.    The exact TimesTen version (the output of the ttVersion command would be perfect).

               

              2.   A small section of the TimesTen log file that shows examples of the errors reported when the server tries to start.

               

              Thanks,

               

              Chris

              • 4. Re: Unable to open the ODBC.INI data sources root
                Dmitrii Dunaev
                Dmitrii Dunaev Aug 14, 2018 2:08 PM (in response to ChrisJenkins-Oracle)

                Hello Chris.

                 

                Thank you very much for helping me with this.

                 

                Here is the ouput from ttVersion

                C:\Windows\system32>ttVersion

                TimesTen Release 11.2.2.8.0 (64 bit NT) (tt1122_64:53396) 2015-01-20T23:15:04Z

                  Instance admin: d_dunaev

                  Instance home directory: C:\TimesTen\TT1122~1\

                  Group owner: OFFICE\Domain Users

                  Daemon home directory: C:\TimesTen\TT1122~1\srv\info

                  PL/SQL enabled.

                Here is a snippet from ttmesg.log

                09:59:54.24 Err : SRV:  5936: EventID=7| Unable to open the ODBC.INI data sources root 

                09:59:54.24 Info:    :  2128: maind got #4.4, hello: pid=5512 type=subdaemon payload=%81%c2%00%00 protocolID=TimesTen 11.2.2.8.0.tt1122_64 ident=AB%0f%00

                09:59:54.24 Info:    :  2128: Got hello from pid 5512, type subdaemon

                09:59:54.24 Info:    :  2128: mark process up: index 1000001, port 49793, pid 5512

                09:59:54.24 Info:    :  2128: marking subdaemon #1000001 (pid 5512) idle

                09:59:54.24 Info:    :  2128: maind: done with request #4.4

                09:59:54.25 Info:    :  2128: maind 1: socket closed, calling recovery (last cmd was 1)

                09:59:54.25 Info:    :  2128: Starting daRecovery for 5936

                09:59:54.25 Info:    :  2128: Finished daRecovery for pid 5936.

                09:59:54.25 Info:    :  2128: maind 3: socket closed, calling recovery (last cmd was 3)

                09:59:54.25 Info:    :  2128: Starting daRecovery for 5936

                09:59:54.25 Info:    :  2128: 5936 ------------------: TimesTen Server exited

                09:59:54.25 Info:    :  2128: Mark process (pid 5936, idx 1000004) down

                09:59:54.25 Info:    :  2128: Mark process #1000004 as down (0)

                09:59:54.25 Info:    :  2128: Spawning 'c:\timesten\tt1122~1\bin\ttcserver1122.exe'

                09:59:54.25 Info:    :  5512: subd: connectToDaemon(sub) port 49793 id 1000001

                09:59:54.25 Info:    :  2128: Spawned new process (ttcserver1122.exe), idx 1000005, handle 0x210=528

                09:59:54.25 Info:    :  2128: Finished daRecovery for pid 5936.

                09:59:54.25 Info:    :   216: Process running as user система

                09:59:54.25 Info:    :  5512: subd: watching for main daemon termination

                09:59:54.25 Info:    :  2128: maind got #6.5, hello: pid=216 type=deadman payload=%87%c2%00%00 protocolID=TimesTen 11.2.2.8.0.tt1122_64 ident=BB%0f%00

                09:59:54.25 Info:    :  2128: Got hello from pid 216, type deadman

                09:59:54.25 Info:    :  2128:  216 ------------------: Subprocess deadman registering

                09:59:54.25 Info:    :  2128: maind: done with request #6.5

                09:59:54.25 Info:    :  3932: Process running as user система

                09:59:54.25 Info:    :  2128: maind got #7.6, hello: pid=3932 type=deadman payload=%89%c2%00%00 protocolID=TimesTen 11.2.2.8.0.tt1122_64 ident=CB%0f%00

                09:59:54.25 Info:    :  2128: Got hello from pid 3932, type deadman

                09:59:54.25 Info:    :  2128: 3932 ------------------: Subprocess deadman registering

                09:59:54.25 Info:    :  2128: maind: done with request #7.6

                09:59:54.25 Info:    :  3932: subd: watching for main daemon termination

                09:59:54.25 Info:    :  2128: maind got #8.7, hello: pid=3932 type=subdaemon payload=%89%c2%00%00 protocolID=TimesTen 11.2.2.8.0.tt1122_64 ident=CB%0f%00

                09:59:54.25 Info:    :  2128: Got hello from pid 3932, type subdaemon

                09:59:54.25 Info:    :  2128: mark process up: index 1000003, port 49801, pid 3932

                09:59:54.25 Info:    :  2128: marking subdaemon #1000003 (pid 3932) idle

                09:59:54.26 Info:    :   216: subd: watching for main daemon termination

                09:59:54.26 Info:    :  3932: subd: connectToDaemon(sub) port 49801 id 1000003

                09:59:54.26 Info:    :  2128: maind: done with request #8.7

                09:59:54.26 Info:    :  2128: maind got #9.8, hello: pid=216 type=subdaemon payload=%87%c2%00%00 protocolID=TimesTen 11.2.2.8.0.tt1122_64 ident=BB%0f%00

                09:59:54.26 Info:    :  2128: Got hello from pid 216, type subdaemon

                09:59:54.26 Info:    :  2128: mark process up: index 1000002, port 49799, pid 216

                09:59:54.26 Info:    :  2128: marking subdaemon #1000002 (pid 216) idle

                09:59:54.26 Info:    :  2128: maind: done with request #9.8

                09:59:54.26 Info:    :   216: subd: connectToDaemon(sub) port 49799 id 1000002

                09:59:54.26 Info:    :  2128: maind got #10.9, hello: pid=5364 type=deadman payload=%8d%c2%00%00 serverport=%95%d0%00%00 ident=EB%0f%00 protocolID=TimesTen 11.2.2.8.0.tt1122_64

                09:59:54.26 Info:    :  2128: Got hello from pid 5364, type deadman

                09:59:54.26 Info:    :  2128: 5364 ------------------: Subprocess deadman registering

                09:59:54.26 Info:    :  2128: maind: done with request #10.9

                09:59:54.26 Info:    :  2128: maind got #11.10, hello: pid=5364 type=ttconnect payload=%8d%c2%00%00 serverport=%95%d0%00%00 ident=EB%0f%00 protocolID=TimesTen 11.2.2.8.0.tt1122_64

                09:59:54.26 Info:    :  2128: Got hello from pid 5364, type ttconnect

                09:59:54.26 Info:    :  2128: mark process up: index 1000005, port 49805, pid 5364

                09:59:54.26 Info:    :  2128: maind: done with request #11.10

                09:59:54.26 Err : SRV:  5364: EventID=7| Unable to open the ODBC.INI data sources root 

                Here is a snippet from tterrors.log

                09:59:54.21 Warn:    :  2128: TimesTen Daemon Release 11.2.2.8.0.tt1122_64 started on 2018-08-14.

                09:59:54.24 Err : SRV:  5936: EventID=7| Unable to open the ODBC.INI data sources root 

                09:59:54.26 Err : SRV:  5364: EventID=7| Unable to open the ODBC.INI data sources root 

                09:59:54.26 Err : SRV:  4476: EventID=7| Unable to open the ODBC.INI data sources root 

                09:59:54.27 Err : SRV:  6140: EventID=7| Unable to open the ODBC.INI data sources root 

                09:59:54.30 Err : SRV:  4852: EventID=7| Unable to open the ODBC.INI data sources root 

                09:59:54.31 Err : SRV:  1040: EventID=7| Unable to open the ODBC.INI data sources root 

                09:59:54.32 Err : SRV:  2464: EventID=7| Unable to open the ODBC.INI data sources root 

                09:59:54.33 Err : SRV:  2412: EventID=7| Unable to open the ODBC.INI data sources root 

                09:59:54.34 Err : SRV:  5256: EventID=7| Unable to open the ODBC.INI data sources root 

                09:59:54.35 Err : SRV:  2140: EventID=7| Unable to open the ODBC.INI data sources root 

                • 5. Re: Unable to open the ODBC.INI data sources root
                  ChrisJenkins-Oracle
                  ChrisJenkins-Oracle Aug 14, 2018 5:36 PM (in response to Dmitrii Dunaev)

                  This may be a silly question, but can you confirm that the registry contains the key HKLM/Software/ODBC/ODBC.INI

                   

                  Thanks,

                   

                  Chris

                   

                  • 6. Re: Unable to open the ODBC.INI data sources root
                    ChrisJenkins-Oracle
                    ChrisJenkins-Oracle Aug 14, 2018 5:45 PM (in response to ChrisJenkins-Oracle)

                    Also, can you please confirm what user the TimesTen Data Manager and Server services are configured to run as?

                     

                    Thanks,  Chris

                    • 7. Re: Unable to open the ODBC.INI data sources root
                      ChrisJenkins-Oracle
                      ChrisJenkins-Oracle Aug 14, 2018 6:04 PM (in response to ChrisJenkins-Oracle)

                      I'd also like to get the output file produced by the ttCapture utility run from a command prompt with the TimesTen environment set. This output will be too large to easily post here; are you willing to provide an email address so that I can contact you directly?

                       

                      Thanks,   Chris

                      • 8. Re: Unable to open the ODBC.INI data sources root
                        Dmitrii Dunaev
                        Dmitrii Dunaev Aug 15, 2018 5:08 AM (in response to ChrisJenkins-Oracle)

                        Hi Chris.

                         

                        Sure, please send me an e-mail to "It's my last name (DUNAEV) followed by my initials DN followed by @gmail.com". I will repply back with the files attached.

                         

                        Thank you in advance.

                        • 9. Re: Unable to open the ODBC.INI data sources root
                          ChrisJenkins-Oracle
                          ChrisJenkins-Oracle Aug 15, 2018 6:44 AM (in response to Dmitrii Dunaev)

                          Thanks. I just sent you an e-mail.

                           

                          Chris