Re: SQL Command/ SQL Query Error (305 Views)
Reply
Occasional Advisor
Posts: 11
Registered: ‎09-30-2013
Message 1 of 2 (335 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

Trusted Contributor
Posts: 216
Registered: ‎07-29-2010
Message 2 of 2 (305 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.

Don
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.