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

    ABB 800xA Batch Interface - Oracle Error

    bklimaszewski

      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 9.2.0.8.0. The most applicable Oracle Provider for OLEDB version we were able to find is 9.2.0.7.0. 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

       
      # SQLNET.ORA Network Configuration File: D:\oracle\ora92\network\ADMIN\sqlnet.ora
      # Generated by Oracle configuration tools.
      
      NAMES.DEFAULT_DOMAIN = B81DCS.COM
      
      SQLNET.AUTHENTICATION_SERVICES= (NTS)
      
      NAMES.DIRECTORY_PATH= (TNSNAMES,HOSTNAME)
       

      tnsnames.ora

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

      PATH Environment Variable

       
      D:\oracle\ora92\bin;D:\oracle\jre\1.1.8\bin;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;%SYSTEMROOT%\System32\WindowsPowerShell\v1.0\
      

      TNS_ADMIN Environment Variable

       
      D:\oracle\ora92\network\ADMIN
      

       

       


       

      Screenshots of the applications, errors, and configurations 

       

      Oracle Net Manager
      6443.Oracle-Net-Manager.png

       

      Oracle Net Manager Test Connection
      4113.Oracle-Net-Manager-Connection-Test.png

       

      TNSPING Connection Attempt
      3441.tnsping.png

       

      Error during interactive interface startup 
      1122.Interface-Startup.png

       

      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

          Brian,

           

          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
              vwitzel

              Hi,

               

              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 9.2.0.7.0 is not compatible with Windows Server 2008 R2. Instead, we had to use ODAC 10.2.0.2.21 (which includes Oracle Provider for OLE DB 10.2.0.2.20). 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!

               

              -Vincent