mjgermany Absent Member.
Absent Member.
977 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

Labels (1)
Tags (1)
0 Likes
1 Reply
Absent Member.. DBR Absent Member..
Absent Member..

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
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.