1. Using the Oracle Autonomous Transaction Processing Adapter with Oracle Integration Generation 2
  2. Troubleshoot the Oracle Autonomous Transaction Processing Adapter
  3. Service Name Specified on the Connections Page is Too Long

Service Name Specified on the Connections Page is Too Long

The service name that you specify in the Service Name field on the Connections page is provided in the tnsnames.ora file included in the wallet ZIP file downloaded from the Oracle Autonomous Transaction Processing database. If the service name is too long, you receive the following error when testing the connection: 

Unable to test connection "MYATP". [Cause: CLOUD-0005]
CLOUD-0005 : Unable to establish connection. Please check connection parameters
Network Adapter could not establish the connection. Please check the wallet credentials
and ensure database is reachable.

Perform the following steps to resolve this error.

  1. Ensure that the correct service name is provided.
  2. Pick the name from the name-value pair. The tnsnames.ora file includes a list of service names.
  3. Ensure that the database is reachable. Try connecting from any other SQL client to confirm.
  4. Ensure that the correct wallet credentials are provided.