DUAS 6: TNS_ADMIN variable not taken into account
Document ID : KB000087253
Last Modified Date : 14/04/2018
 Show Technical Document Details
Issue:
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