Unable to create JDBC connection from Idash server tab

book

Article ID: 144177

calendar_today

Updated On:

Products

CA Workload Automation iDash

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:@c037srzauta1a.int.thomsonreuters.com:1521:pdbq0115_1
20-01-30 12.43.02 [ INFO] idashdb-import-TA1-thread-3: c037srzauta1a.int.thomsonreuters.com:ping:reachable=true:jdbc:oracle:thin:@c037srzauta1a.int.thomsonreuters.com:1521:pdbq0115_1
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

Cause

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

Environment

Release : 12.1

Component : iDASH

Resolution

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