Cannot connect to domain to look up service
Cannot connect to domain to look up service [coreservices/DomainConfigurationService]
January 31, 2018
How to set up a new connection in SQL Developer?
April 1, 2018
Show all

Adding a new TNS entry to tnsnames.ora

Steps to add create a new TNS entry or create a new TNS file.

By default, the TNSNames.ora file can be found at {oracle directory}\network\admin.

For example, C:\Oracle_Client\network\admin.

If no TNSNames.ora file is present on your computer, create one using a text editor. Here is the template and the properties in brackets must be replaced by values required.

(CONNECT_DATA= (SERVICE_NAME=[service_name])

For example:

HR =
 (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)
  (SERVICE_NAME= orcl)