Hi there,I have 4 FME workbench files on Win2008 server and execute those workbench files using a batfile.I can run the batfile without getting any errors but USER2 cannot run this bat file.User2 get following error.## Start translation ## FME 2015.1.3.0 (20151105 - Build 15570 - WIN32) FME Desktop Oracle Edition (floating) Permanent License. Machine host name is: WBV-GCS-P0011 Operating System: Microsoft Windows Server 2008 R2 Server 4.0, Enterprise Editio n 64-bit Service Pack 1 (Build 7601) Copyright (c) 1994 - 2015, Safe Software Inc. Safe Software Inc. Error connecting to Oracle database: message was `ORA-12154: TNS:could not resol ve the connect identifier specified'. (serverType=`ORACLE8i', serverName=`vmesde v<at>gisap.world', userName=`', password=`***', dbname=`') Program TerminatingTranslation FAILED. ## End translation Closure_GB_NI ##User2 is Administrator to this sever and can connect to Oracle Database using sqlplus. But User2 cannot connect to Oracle Databse using FMEAny help would be appreciatedThanks

Question

Ora12154 TNS:could not resolve the connect identifier specified

8 years ago
July 20, 2016
1 reply
87 views

pushpa
Contributor
28 replies

Hi there,

I have 4 FME workbench files on Win2008 server and execute those workbench files using a batfile.

I can run the batfile without getting any errors but USER2 cannot run this bat file.

User2 get following error.

## Start translation ##

FME 2015.1.3.0 (20151105 - Build 15570 - WIN32)

FME Desktop Oracle Edition (floating)

Permanent License.

Machine host name is: WBV-GCS-P0011

Operating System: Microsoft Windows Server 2008 R2 Server 4.0, Enterprise Editio

n 64-bit Service Pack 1 (Build 7601)

Safe Software Inc.

Error connecting to Oracle database: message was `ORA-12154: TNS:could not resol

ve the connect identifier specified'. (serverType=`ORACLE8i', serverName=`vmesde

v<at>gisap.world', userName=`', password=`***', dbname=`')

Program Terminating

Translation FAILED.

## End translation Closure_GB_NI ##

User2 is Administrator to this sever and can connect to Oracle Database using sqlplus. But User2 cannot connect to Oracle Databse using FME

Any help would be appreciated

Thanks

Did this help you find an answer to your question?

pushpa
Author
Contributor
28 replies
8 years ago
July 20, 2016

hi there,

Just to let you know that I have managed to sort out this issue.

User2 didn’t have Database connection saved under Database connections on FME options. Once User2 saved the Oracle connection then able to run the bat file without any errors.

thanks

Reply

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

Cookie settings

We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.

Basic
Functional

Normal
Functional + analytics

Complete
Functional + analytics + social media + embedded videos

Ora12154 TNS:could not resolve the connect identifier specified