Error ORA-12505 oracle sql developer
When try to connect to the local database , you found this message : Status : Failure -Test failed: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor I consider this as error ORA-1250. In my case ,to solve this problem you need to change the SID " xe " to " e161306 " then the problem solved! Then the question come when you try, you may be fail because the SID for mine may differ from yours! If you have dint change the Connection name , then you will see that there will be some word behind the dash '-', you should key in the word behind into the SID. Like mine is 'e161306'. How to know your SID? I think it was quite easy! All you need is open your msconfig if you are using Microsoft windows Operating System. Start --> run-->type in "msconfig"/ Start --> type in msconfig--> click msconfig.exe After you open the msconfig, yo...