SQL Command/ SQL Query Error (174 Views)
Occasional Advisor
Posts: 11
Registered: ‎09-30-2013
Message 1 of 2 (174 Views)

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

Please use plain text.
Trusted Contributor
Posts: 208
Registered: ‎07-29-2010
Message 2 of 2 (144 Views)

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.

Please use plain text.
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation