Re: SQL Command/ SQL Query Error (182 Views)
Reply
Occasional Advisor
mjgermany
Posts: 11
Registered: ‎09-30-2013
Message 1 of 2 (212 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
DBR
Posts: 211
Registered: ‎07-29-2010
Message 2 of 2 (182 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.