SOAP UI: ORA-12505 or ORA-12514 errors during connection etablishing with JDBC

If you see such kind errors as:

ORA-12514, TNS:listener does not currently know of service requested in connect descriptor


ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

when you’re trying to establish a connection to the external Oracle DB server, which has a hostname structure like //IP adress:Port/Service name , then you can write Connection String in the next way:

jdbc:oracle:thin:ORAUSER/ORAPASSWORD@//IP adress:Port/Service name

Also, in case of another structure you can try the second way:

jdbc:oracle:thin:ORAUSER/ORAPASSWORD@IP adress:Port:SID