Ora-12505 windows

Active 3 years ago. Viewed 27k times. When I tried making a connection with the same username and password via SQL developer however I'm getting the ora error Printout of my tnsname. All rights reserved. Improve this question. Rattansingh D. Rattansingh 1, 3 3 gold badges 16 16 silver badges 28 28 bronze badges. Add a comment.

Active Oldest Votes. Improve this answer. Managed Services. Talent Sourcing. Business Solutions Consulting Training.

Resource Center. Privacy Policy Terms of Use. If you prefer to solve this issue on the server side, the potential solution is to make the listener treat the SID as a service name and establish connections for users.

Luckily, Oracle provides a parameter for listener to do this. For cluster databases, we should go for listener. Please note that, such backward compatibility has some restrictions. Which means, you cannot connect it through SCAN listener. Do you mean the Oracle Windows service name? Connect Sys user. Sorry Babu, I'm not sure what you mean by that. What are you asking me to do? Thu, 18 June Any other ideas anyone? BlackSwan wrote on Thu, 18 June Fri, 19 June Hello, Let me complete your issue.