bklimaszewski

ABB 800xA Batch Interface - Oracle Error

Discussion created by bklimaszewski on May 15, 2013
Latest reply on May 30, 2013 by vwitzel

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! :)

Outcomes