2 Replies Latest reply on May 30, 2013 8:11 PM by vwitzel

    ABB 800xA Batch Interface - Oracle Error


      Hi all,


      We are trying to establish a connection to an ABB 800xA DCS using the ABB 800xA Batch Interface. As a pre-req, this interface requires the installation of the Oracle Provider for OLEDB, the version of which is to match that of the Oracle database you are connecting to. In our case, the Oracle DB is version 9i R2 The most applicable Oracle Provider for OLEDB version we were able to find is After installing it on our Windows Server 2008 R2 interface node, we tested a connection from the Oracle Net Manager to the Oracle DB, which was successful (see screenshot below). When starting the interface however, we encounter an error stating: 

      ORA-12154: TNS:could not resolve service name

      Googling this error reveals that it is a quite common one, usually related to some issue with the tnsnames.ora file. Unfortunately, none of the suggested solutions solved our problem.


      Our configuration is as follows:



      # SQLNET.ORA Network Configuration File: D:\oracle\ora92\network\ADMIN\sqlnet.ora
      # Generated by Oracle configuration tools.


      # TNSNAMES.ORA Network Configuration File: D:\oracle\ora92\network\admin\tnsnames.ora
      # Generated by Oracle configuration tools.
      b81im1 =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.xxx.xxx.xxx)(PORT = 1521))

      PATH Environment Variable


      TNS_ADMIN Environment Variable





      Screenshots of the applications, errors, and configurations 


      Oracle Net Manager


      Oracle Net Manager Test Connection


      TNSPING Connection Attempt


      Error during interactive interface startup 


      Our PIABB800xA.ini file contains:

      source[1].service     = B81IM1
      source[1].database    = ops$ocshis
      source[1].user        = history
      source[1].pswd        = history

      Appreciate any insights you could share on what the issue might be!


      Thanks! :)

        • Re: ABB 800xA Batch Interface - Oracle Error
          Ahmad Fattahi



          Hopefully someone in the vCampus community has some experience to share here. If that does not happen I would suggest you contact our Tech Support who has the best resources to tackle these kinds of questions on interfaces and configuration for you.

            • Re: ABB 800xA Batch Interface - Oracle Error



              I am a colleague of Brian's and with the help of tech support and OSI's ABB 800xA Batch Interface developer, we were able to resolve the issue. In short, the issues were as follows:


              i) The interface installation cannot reside in the Program Files (x86) directory, due to issues with parentheses in the directory name. It can reside in any directory that does not have a parenthesis (or potentially any other special characters) in the directory name.


              ii) Oracle Provider for OLEDB is not compatible with Windows Server 2008 R2. Instead, we had to use ODAC (which includes Oracle Provider for OLE DB According to Oracle's installation instructions, one needs to perform a special procedure to install this version on Windows Server 2008 as well, but we simply installed it using Windows Server 2003 SP1 compatibility mode and that did the trick :).


              If anybody runs into any issues with using the interface, don't hesitate to ask!