Add Service Name to tnsnames.ora

You must also add the service name used to create connection pool to tnsnames.ora on the application server.

The tnsnames.ora file is located in the application instance; for example: middleware_home\application_server_instance\config.

Note:

Oracle recommends maintaining a master tnsnames.ora file and copying it to each location—database and application servers— whenever you add a database.