Oracle Db Connection Issue
I have to connect to oracle sql developer through parasoft soatest tool using service name instead of sid value after port number.
I am getting SQL Exception - java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
Please find the sample URL - jdbc:oracle:thin:@ocomp48t-scan.qintra.com:1521:gendb01p_failover
Can anyone please help me to connect through service name ?
Thanks in advance.