I need to store the tnsnames.ora file in other location and let DS use the same from there.
When my Job executes I am not able to see this parameter in the Environment Variables list in DS Director logs.
I added this $TNS_ADMIN in dsenv with the new path where I want this file to be but after i execute ./dsenv and then echo $TNS_ADMIN, it still shows the old path and also I cannot see it still in the job log in director.
My job is aborting giving the error
Kindly request you to provide some pointers to add this ENv variable in the job.The connector could not establish a connection to the default Oracle server. Method: OCIServerAttach, Error code: 12,162, Error message ORA-12162: TNS:net service name is incorrectly specified.
Thank You !!!