I am running TFS 2013 Update 2 on Windows 2008 R2. I installed the Oracle Instant client 32 and 64. I've tried it with both clients 32/64 and changed the test run mode from x86 to x64.
--Update - I am using Tnsnames.ora and the user\schema and passwords are embedded in the config files. I don't think this is a user or password issue.
--Update - 2 I ran another test. If I delete the oracle folder the Build changes the error to:Oracle client software version 8.1.7 or greater. So the build controller is finding the oracle client. But it's not reading the tns.ora?? It's in the same folder. I followed these instructions to add the tnsnames.ora as a registry key entry How can Instant Client on Windows use registry settings? HKEY_LOCAL_MACHINE\SOFTWARE for a global setting 2. Add ORACLE group key. 3. Add a new string value within the ORACLE key for the different settings you are interested in (NLS_LANG, TNS_ADMIN, etc.) I rebooted and it still does does not run in the build.
I am running some basic CRUD Oracle test to validate the SPs in our applications. On the build server we have Visual Studio and it will run the Unit test without issues. That tells me the Oracle client is working fine.
When I run the TFS build and the Unit test, I get the below error:
System.Data.OracleClient.OracleException: ORA-12154: TNS:could not resolve the connect identifier specified
------Resolved---------- I had to change the permissions on the folder to let the service account have admin access.