When I choose to connect with TNS, the drop-down does not display any choices. I was wondering where my tnsnames.ora file needs to be so Backup Reporter can find it.
Quest Backup Reporter uses SQL*Net.
The tnsnames.ora file should be in the Oracle client’s Admin folder.
Quest Backup Reporter looks for the tnsnames.ora file in the following locations:
1) Check for TNS_ADMIN environment variable, if set use that
2) Check for ORACLE_HOME environment variable, if set use that
3) If neither set, search the registry and load all the Oracle info from there.