Unable to create JDBC connection from Idash server tab

Products

• iDash Workload Automation

Issue/Introduction

While creating JDBC  connection to Autosys tab from the iDash Admin tool it is saying not successful.

See the following DB Error:

20-01-30 12.43.02 [ WARN] idashdb-import-TA1-thread-2: Primary connection failed: java.sql.SQLException:Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor. Using secondary.
20-01-30 12.43.02 [ INFO] idashdb-import-TA1-thread-2: Closing connection: jdbc:oracle:thin:@hostname.com:1521

20-01-30 12.43.02 [ INFO] idashdb-import-TA1-thread-3: c037srzauta1a.int.thomsonreuters.com:ping:reachable=true:jdbc:oracle:thin:@hostname.com:1521
20-01-30 12.43.02 [ERROR] idashdb-import-TA1-thread-3: java.sql.SQLException:Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
 
java.sql.SQLException: java.sql.SQLException:Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

Environment

Release : 12.1

Component : iDASH

Cause

Someone had created tablespaces(not tables) with the same name in both containers. 

Resolution

So the DBA needs to dropped duplicate schema & tablespaces from one of the instances and then retry the JDBC connection.