Hello i recently installed Oracle and Oracle SQL Developer together with JDM, as i try to create a connection i get the following error.
An error was encountered performing the requested operation:
Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
Vendor code 12505
What i tried to do was:
1) go to Services and see if there something is not working. But everything seems to be ON.
2) Then I went and checked the listener.ora and tnsnames.ora I tried a few different tutorials online but none of them worked.
3) Then in those files changed the host to localhost, my machine's name, dns from a tutorial and none worked. Also tried restarting the services but also didn't work.
4) I tried to re-install the program but that also didn't help.
some pictures of my settings : https://i.stack.imgur.com/TamFv.png https://i.stack.imgur.com/iZNXM.png https://i.stack.imgur.com/jKwxQ.png https://i.stack.imgur.com/qTssn.png
I have more than one services of the listener which the people from stackoverflow pointed out. I hope i will find some help here.
Thanks in advance!