1 Reply Latest reply: Sep 3, 2013 11:59 AM by fuerstd RSS

    TNS_ADMIN troubles in Managed ODP.Net (xCopy)

    fuerstd

      After some time with the configuration of Oracle Data Provider for .NET (Managed Driver Version : 4.121.1.0, xcopy) I did it but according to TNS_ADMIN an Issuse:

       

      The TNS_ADMIN setting in my app.config did not work at all:

           My app.config sets TNS_ADMIN to "C:\oracle\odp.net\network\admin\"

       

          <oracle.manageddataaccess.client>

              <version number="*">

                  <settings>

                      <setting name="TNS_ADMIN"

                               value="C:\oracle\odp.net\network\admin\" />

                </settings>    

              </version>

          </oracle.manageddataaccess.client>

       

      Trace says:

      2013-09-03 17:54:36.855685 TID:4   (CFG) (ENV)      Machine Name : TWI53APPDS

      2013-09-03 17:54:36.871310 TID:4   (CFG) (ENV)      User Name : ServiceAdm01DsTest

      2013-09-03 17:54:36.871310 TID:4   (CFG) (ENV)      OS Version : Microsoft Windows NT 6.1.7600.0

      2013-09-03 17:54:36.871310 TID:4   (CFG) (ENV)      64-bit OS : True

      2013-09-03 17:54:36.871310 TID:4   (CFG) (ENV)      64-bit Process : True

      2013-09-03 17:54:36.871310 TID:4   (CFG) (ENV)      .NET Runtime Version : 4.0.30319.1

      2013-09-03 17:54:36.871310 TID:4   (CFG) (VER)      Oracle Data Provider for .NET, Managed Driver Version : 4.121.1.0

      2013-09-03 17:54:36.871310 TID:4   (CFG) (.NET)     TraceLevel : 7

      2013-09-03 17:54:36.871310 TID:4   (CFG) (.NET)     TNS_ADMIN : c:\oracle\odp.net\managed\x64\..\..\..\network\admin

      2013-09-03 17:54:36.871310 TID:4   (CFG) (.NET)     TraceOption : 0

      2013-09-03 17:54:36.871310 TID:4   (CFG) (.NET)     PerformanceCounters : 0


      Pulling *.ora Files to c:\oracle\network\admin helped, but I'm sure the configuration worked with the Beta-Version or is there an syntax error in my configuration?


      Regards


      Dominik Fürst

        • 1. Re: TNS_ADMIN troubles in Managed ODP.Net (xCopy)
          fuerstd

          Found a setting for version="4.121.1.0" in my machine.config:

            <oracle.manageddataaccess.client>

              <version number="4.121.1.0">

                <settings>

                  <setting name="tns_admin" value="c:\oracle\odp.net\managed\x64\..\..\..\network\admin" />

                </settings>

              </version>

            </oracle.manageddataaccess.client>

           

           

          Adding Version-Number to my app.config stetting like this solved my problem:

          <oracle.manageddataaccess.client>

                  <version number="4.121.1.0">

                      <settings>

                          <setting name="TNS_ADMIN"

                                   value="C:\oracle\odp.net\network\admin" />

                  </version>

              </oracle.manageddataaccess.client>