DUAS 6: TNS_ADMIN variable not taken into account

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>

 

Environment

OS: All

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.

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