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 22.214.171.124.0. The most applicable Oracle Provider for OLEDB version we were able to find is 126.96.36.199.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 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 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
TNS_ADMIN Environment Variable
Screenshots of the applications, errors, and configurations
Our PIABB800xA.ini file contains:
source.service = B81IM1 source.database = ops$ocshis source.user = history source.pswd = history
Appreciate any insights you could share on what the issue might be!