Operations Orchestration Practitioners Forum
Showing results for 
Search instead for 
Do you mean 

SQL Command/ SQL Query Error

Occasional Advisor

SQL Command/ SQL Query Error

Hi all,


I'm receiving this Error message while running a sql command. 
Im using servicename instead of SID.Any idea what to do and how to solve it?


{returnCode=-1;returnResult=Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor


Thanks in advance

Trusted Contributor

Re: SQL Command/ SQL Query Error

I don't think you can use the service name I had to use the "SQL Query All Rows" opertaion to get it to work. You don't need the SN or SID if you use this operation.