Using a TNS connection
Published 24 February 2022
A TNS connection lets you connect to a database using an alias specified in your tnsnames.ora configuration file.
By default, tnsnames.ora is located in:
ORACLE_HOME/network/admin
To connect using a TNS connection:
- Under Source or Target, select Database.
- Select the TNS Connection tab, if it is not already selected.
- In the Oracle home box, type or select the name of the Oracle home.An Oracle home is the location of an Oracle Database installation.
Under Database, in the Network Alias box, type or select the alias (network service name) of the database and then enter the User name and Password.
If you want Data Compare for Oracle to remember your password, select the Save check box.
