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.
  1. Start --> run-->type in "msconfig"/ Start --> type in msconfig--> click msconfig.exe
  2. After you open the msconfig, you click the services tab.
  3. Tick hide all microsoft services at the leftbottom.
  4. Then find the service name OracleServicesXXXX (XXXX is your sid)


















The words that I circled with red color is the SID ! Make sure you have tick the services to run during start up! For my case , I have 2 SID which is e161306 and orcl.

If you already change your name then I don't know how to help you! Anyone solve please try to leave a comment below! Thank you

Comments

  1. vikFebruary 5, 2014 at 8:31 PM

    You are great sir!!! I wasted a week reading vast internet posts and taking advice from geeks! nothing worked!!
    I just accidently bumped into your post, it worked!! woohoo!! gonna help my friends tomorrow.You are Great!!

    ReplyDelete

Post a Comment

Popular posts from this blog

Reading and Writing Operation of SRAM

Image
The diagram below is illustrate Static Random Access Memory (SRAM)Cell for the explanation. SRAM cell is make up of 2 inverters are cross-connected to form a latch .The latch is connected to 2 bit line by transistor T1 and T2 . T1 and T2 can switch opened or closed under control of word line.When word line is ground level, the transistors are turned off and the latch retrains its state. During the Read Operation ,Word line is activated to close switches T1 and T2 . If the cell is in state 1; the signal on b line is high and the signal on b’ line is low.The opposite is true if the cell is in state 0.Thus, b and b’ are always complements of each other’s. The sense /write circuit at the end of the two bit line monitors their state and sets the corresponding output accordingly. While in Write Operation ,the Sense/Write circuit drives bit lines b and b’, instead of sensing their state.It places the appropriate value on bit line b and its complement on b’ and activate the word
Read more

Reading & Writing Operation of DRAM

Image
In Dynamic Random Access Memory CELL , transistor acts as a switch to Close (allowing current to flow) when voltage applied in address line or Open (no current flow) when no voltage applied in address line.Address Line also known as word line .Which use to signal the transistor to close or open. During the Write operation ,a voltage is applied on the bit line and a signal applied to the address line to close the transistor.Then the voltage applied on the bit line will transfer to capacitor and store in the capacitor However the capacitor has tendency to discharge and has to refresh to maintain the bit. While in Reading Operation ,the instruction find the bit store using the address line to read the data or bit. When the address line is selected ,the transistor turns on and the charge stored on the capacitor is fled out onto a bit line and to sense amplifier. Sense amplifiers compare the capacitor voltage to reference value to determine the logic 1 or logic 0.The read out from
Read more

Method to Convert from Stream to Json C#

Recently I was using the C# HttpClient to make REST request but I found that is was quite troublesome so I have changed to using HttpWebRequest instead. So want the HttpWebRequest result is return it was in Stream form. I not able to convert it into Json. this is the method i convert the stream to JSON. HttpWebResponse response = ( HttpWebResponse ) requirejs . GetResponse (); Stream stream = response . GetResponseStream (); StreamReader sr = new StreamReader ( stream ); var serializer = new System . Web . Script . Serialization . JavaScriptSerializer (); var jsonObject = serializer . DeserializeObject ( sr . ReadToEnd ()); As you can see that jsonObject is an object. Now you can parse it into the Json(JsonObject); If you have any question can leave a comment below.
Read more