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

SQL Command/ SQL Query Error

Highlighted
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

1 REPLY
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.

Don