I can't seem to find any information on setting up a working oracle connection using a tnsnames file. I am also unclear on what the TNSADMIN is used for, but did find a reference online where someone pointed to sqldeveloper, seemed odd.
I just need:
1. Where does DG look for the tnsnames.ora file
2. Do I need to provide a value for the TNSADMIN field and if so, what?
The TNSADMIN field should probably be renamed TNSNAMES... If you put the path to your tnsnames.ora file here, all works perfectly.