ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
Issue
-
Oracle driver raises exception when attempting to create a connection to the database
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
-
The datasource URL string has the format below1
jdbc:oracle:thin:@(description=(address_list=(load_balance=off)(failover=on)(address=(protocol=tcp)(host=abc2)(port=1536))(address=(protocol=tcp)(host=abc)(port=1536)))(connect_data=(service_name=abc)(failover_mode=(type=select)(method=basic))))
-
The failure raised by the driver may relate to the exact values in the connection string (e.g. the service name or SID) rather than to the format of the URL ↩︎
Environment
- Red Hat JBoss Enterprise Application Platform (EAP)
- 6
- 7
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.