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

Transmission Control Protocol (TCP)

Image
Transmission Control Protocol (TCP) also known as Transport Protocol. TCP is one of the two original components of the suite, complementing the Internet Protocol (IP), and therefore the entire suite is commonly referred to as TCP/IP.Transmission Control Protocol is built on top of IP. Protocol mean the rules in order two devices or more to communicate with each others.In others meaning, Devices with TCP can only communicate with devices equip with TCP. For example like human communication in same using English as Global language then TCP is similar with english! Function of Transmission Contol Protocol: It will assume that IP might lose some data ,so it will keep a copy of data and send data to receiver until get an acknowledgement from the receiver. If the data sent is unresposive for too long , the TCP will send it again. The responsibility of the transport layer is to present a reliable end to-end pipe to the application.The data either arrives in the proper order or the
Read more

File transfer from android to linux

Android File transfer basically got two method or format which are Media device (MTP) and also for camera (PTP). However , the MTP is only suitable for windows or Mac computer, it was not compatible with the Linux. The PTP only allow you to transfer photos only but not others files. However you can let your ubuntu to support mtp by using the "mtpfs" or "jmtpfs". Below I will show step by step how to configure the MTP service in Ubuntu 14.04 LTS. First of all you need to install the mtp tools in linux, you can install by using the commands below. Open the terminal and type in the following 2 line. (ps:without the quote, and it may required you to key in your password) "sudo apt-get install libmtp-common mtp-tools libmtp-dev lilbmtp-runtime libmtp9" "sudo apt-get dist-upgrade" 2nd Step you have to edit the fuse.conf file. Fuse provide a secure method for non privileged users to create and mount their own file system implementation. =| You
Read more