DUAS 6: TNS_ADMIN variable not taken into account

book

Article ID: 87253

calendar_today

Updated On:

Products

CA Automic Dollar Universe

Issue/Introduction

Error Message :
N/A

Patch level detected:Dollar Universe 6.0.14
Jobs that need the variable TNS_ADMIN correctly set, in order to connect to an Oracle Database Abort.
Even if you set this configuration on the variables.xml file, the scripts fails:

 
<var id="TNS_ADMIN" is_env="Y">
<display lang="EN">Oracle administration directory</display>
<display lang="FR">Répertoire d'administration Oracle</display>
<nature>STATIC</nature>
<data type="STRING">
<default></default>
</data>
</var>








 

Cause

Cause type:
Configuration
Root Cause: The tns_admin parameter determines the location of the TNS administration files (e.g. tnsnames.ora and listener.ora, etc.)
This variable should be set in your DUAS environment in order to be able to connect to the Oracle Database.

Environment

OS: All

Resolution

In order to set the variable go to:
 
Administration > Nodes > Right click on your node > Node Settings> Node Variables> Right click on Node Variables > Choose Add

Here enter a variable name TNS_ADMIN and a variable value of the path to the TNSNAMES.ORA file that will be used as the default

Example: 

Name: TNS_ADMIN
Value: /apps/oracle


 

Fix Status: No Fix

Fix Version(s):
N/A

Additional Information

Workaround :
N/A