HomeОбразованиеRelated VideosMore From: INNo MATHs

ORA-12505: TNS:listener does not currently know of SID given in connect descriptor

502 ratings | 82322 views
solution of error: 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
Html code for embedding videos on your blog
Text Comments (164)
omar wasfi (16 days ago)
Thanks <3
Mathieu humery (22 days ago)
thanks <3
Firhan maulana rusli (1 month ago)
thanks bruh
Behruz Nakhchivanski (1 month ago)
Thanks for your help..it worked.
Manoj MUTHURAJA (1 month ago)
Hey ! thank you very much my problem solved at the last step you proposed!!
Jack The ripper (1 month ago)
nathan mwanza (1 month ago)
thanks for the video, but it isn't working for me. After trying the second way.
Quỳnh Phạm Như (2 months ago)
Thanks very much !!!
PRADEEP ARUMUGOM (2 months ago)
Thank you so much it saved my ass :D Keep making videos like this !!!
John Lucas (4 months ago)
Thanks for sharing this video that worked perfectly for me, the SID field in the setup of SQL Developer was set up by default to ' xe ' ensure to change this section with the SID that can be found in the second step as described in the video.
CHETHANI PERERA (5 months ago)
II MaynarD II (5 months ago)
I tried everything and still does not work, i can't find the SID name :(
whatuserid (7 months ago)
i love that hand thanks
whatuserid (7 months ago)
changed SID to orcl as shown in the video. but there was still an error with userID/password being wrong >> changed user id to SYSTEM and password entered during installation. worked!
thank you so much , it's useful
RAHUL SOSHTE (7 months ago)
thank you so much
fathima sheikh (10 months ago)
Thanks alot dear
Naveensada (11 months ago)
thank you so much bro. my error got resolved. i changed the port number and local host along with ora services restart.
INNo MATHs (11 months ago)
Suggest me any error you get in future. :)
faraz mhd (11 months ago)
Thank you
INNo MATHs (11 months ago)
see https://www.youtube.com/watch?v=miEIuISHqrk this is our latest theme to make videos on social themes. Please give a feedback.
Henry Tirla (1 year ago)
it worked for me thanks
Jamal Khan (1 year ago)
Good Evening Please Help Me I did this all step but my problem is not solve
INNo MATHs (1 year ago)
please elaborate the problem little more and tell me the configuration.
Kelvin C.B (1 year ago)
Thank you very much, worked!!!!
yaharin ben ayon (1 year ago)
what do you mean Run Cmd as administrator ? how do i do that?
INNo MATHs (1 year ago)
Right click on command prompt icon and you will see run as administrator option.
Bhanuka Isuru (1 year ago)
lsnrctl not found.. ('lsnrctl' is not recognized as an internal or external command, operable program or batch file.) how to fix this error?
Kavalireddy Kartheek (1 year ago)
Thank you.solved my problem
Thank you so much ..i did solve my problem by your vedio .
Александр К (1 year ago)
Да в основном эти трудности. Повнимательнее)
INNo MATHs (1 year ago)
yes.. you are right
Александр К (1 year ago)
The problems are mostly in the files of the listener.ora and the tnsnames.ora. But do not forget that the client should have identical settings (HOST, port). Otherwise, you can not connect to the database on the network. Only locally.
INNo MATHs (1 year ago)
мы не знаем российский стиль. Прости. :(
alfred Kotey Amon (1 year ago)
tns does not know the SID in the connection pls help
Mir Khan (1 year ago)
i was new in ora u saved my life :D
INNo MATHs (1 year ago)
+Mir Khan :)
ZENAGEBREL Muluneh (1 year ago)
My problem is solved. Thank you!
Quynh-Nhi Thai (1 year ago)
---- 'lsnrctl' is not recognized as an internal or external command, operable program or batch file. ------ please help!
Pramit Sarkar (1 year ago)
very helpful
Brayan Moya (1 year ago)
Gracias me ayudaste muchisimo!!!
Gurupreet Bharani (1 year ago)
Thank you
INNo MATHs (1 year ago)
+Gurupreet Bharani your welcome
tayaf ratry (1 year ago)
INNo MATHs (1 year ago)
+tayaf ratry your welcome
sairam Ch (1 year ago)
when i reconnect with old connection name with same details as previously i done successfully, but again connecting with these i get error like 'Listener refused the connection with the following error :ORA-12505, TNS: Listener does not currently know of SID given' how can i connect successfully
picks time (1 year ago)
super job
Ebisa Neda (1 year ago)
Its great. It works for. My problem was the second one thanks alot
Vendo Ofertas (1 year ago)
Ty, great video
Betel Peña (1 year ago)
I didn't have a good resul without modifying the port 1521 and 1522 :(
devi gayatri (1 year ago)
Thank you so much, it worked :)
gaurav sen (1 year ago)
Thanks.. a lot.. This Video has helped me in resolving the TNS name issue.. There were 2 db_homes, that is the reason why I was getting the error for inputting 1521 as PORT instead of 1522.
Arif Ardiansyah (1 year ago)
really helpful, thanks :)))
Sai (1 year ago)
thank you..:)
Jimmy Lee (1 year ago)
It stated "The system cannot find the path specified." How do I create a new connection with new hostname and port?
Martin Odazhyiski (2 years ago)
What about Linux?
Diego Bolaños Suarez (2 years ago)
Hi Tank-you soooooo muchhhhh Greetings from COlombia!!
INNo MATHs (2 years ago)
Your welcome...
Besheem (2 years ago)
thanx blood, u da best
Abhijit Balse (2 years ago)
Cool video. Thanks a lot !! :)
amit agrahari (2 years ago)
Thanks a lot, Sir, I got the same error fought with it for 2 days, finally got the solution which is the port number.
INNo MATHs (2 years ago)
Your welcome Amit.
Jopsy Media (2 years ago)
Superb yaar............. You are awesome.
Kelvin Melendez Dipre (2 years ago)
Me salvaste la vida!!!!! thanks so much!!
Aaron K (2 years ago)
If the 1st solution from the above video did not work (the 'lsnrctl status' command worked fine, but you still get the same error), then try this alternate solution that worked for me (in Windows): 1) Go to the Start Menu and type 'cmd'. This will bring up a program called 'cmd.exe'. Right-click this program and click on 'Run as administrator'. This will open the Windows Command Prompt. 2) Type this command: lsnrctl stop 3) Type this command: lsnrctl start 4) Step 3 might produce some errors -- ignore it, close the Windows Command Prompt and restart the computer. That's it -- hopefully you should be able to connect to your database without getting the same TNS error as before.
nathan mwanza (1 month ago)
I stiil get the same error.
Aaron K (2 years ago)
As of 2016, at least in Windows, the tnsnames.ora file is actually located here: C:\oraclexe\app\oracle\product\11.2.0\server\network\ADMIN
Hamdamboy Urunov (2 years ago)
Please in my side again the same problem. But address of app is Disk (local D:\app\uwasn\product\11.2.0\dbhome_1\NETWORK\ADMIN) but my system is C:/ foldder....
Ximena Tarque (2 years ago)
Natha Narute (2 years ago)
good help
Moataz Yassin (2 years ago)
could not found that file and the listener is open
Morsalin Hossain Liton (2 years ago)
I did not help, problem still exists.....
Gabe (2 years ago)
Thank you so much
Juan Laureano (2 years ago)
thank you, your video saved my life :D
Armando Lopez cordero (2 years ago)
Good video (Y)
INNo MATHs (2 years ago)
Ketan Dubey (2 years ago)
Belfrid Kakankou (2 years ago)
please i have a error 'Isnrctl' n’est pas reconnu en tant que commande interne ou externe, un programme exécutable ou un fichier de commandes.
Towards The Sunset (2 years ago)
Perfect! Thank you.
If this it doesn´t work, you need to run the sqlplus and run this command: alter system set local_listener = '(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))' scope = both; I made and the listener hear the SID.
Thanks a million. This worked for me
nathan mwanza (1 month ago)
yeah! it works. thanks a million
Zvit Zvat (1 month ago)
now try the connection , it will certainly work
nathan mwanza (1 month ago)
thanks! it works.
nathan mwanza (1 month ago)
i got the message "system altered" so what next?
The Bronze Knight (2 years ago)
So I followed the second solution and it still didn't work for me so I went to Administrative Services and started the OracleServiceXE Open control panel, System and security, Administrative Tools, then Services If any Oracle services (names begin with Oracle or Ora) exist then select each of the services, and click Start.
AMNA MALIK (1 year ago)
thankyou so so so much man
The Bronze Knight (1 year ago)
cabbageapple Glad I could help
R (1 year ago)
You're a hero dude!
Rachael Gardner (1 year ago)
Yes this worked for me as well, thank you
You were right, that good idea, I worked wonderfully, thank you was about to throw in the towel, damn oracle services that are not automatically run, just run these 3 services and fix the problem: -OracleServiceXE -OracleXEClrAgent -OracleXETNSListener
Shelley Parihuamán (2 years ago)
T_T nothing!!
INNo MATHs (2 years ago)
David Jiang (2 years ago)
thank you!
Kevin Ng (2 years ago)
when i open the tnsnames.ora, i have no ORCL = what do i do now?
The Bronze Knight (2 years ago)
The orcl is just their SID name change it wit yours for example mine is xe In the tnsnames.ora file you have to write in the SID info like this change xe to your SID name and the port number with the port number you use. xe = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost (PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE NAME = xe) ) )
INNo MATHs (2 years ago)
https://www.patreon.com/innomaths Please Support us at Patreon.
Honey Darling (2 years ago)
i did not find any name with orcl or xe in that file. how to add those listener to file
The Bronze Knight (2 years ago)
In the tnsnames.ora file you have to write in the SID info like this change xe to your SID name and the port number with the port number you use. xe = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost (PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE NAME = xe) ) )
Minion Skywalker (2 years ago)
I got a same problem )
Glenn Conner (2 years ago)
The specifics in this video didn't work for my, however the problem as to why I couldn’t connect was "incorrect connection information" which the video shows is only one of two reasons for the connection to fail. I have windows 7 and after installing SQL Developer and going to the connection window for the first time the default for the SID is 'xe'. I looked in my environmental variables and didn't see ORACLE_SID = XE. So at least I knew the install didn’t create the variable for me. Perhaps adding this would have worked, however what I did was look into my tnsnames.ora file (../product/11.2.0/dbhome_1/NETWORK/ADMIN/tnsnames.ora) and noticed one connection data had SID =  CLRExtProc, but the database I wanted to connect to had (SERVICE_NAME = orcl)  instead of the SID. In the new connection window I selected 'Service Name' instead of the SID and typed in "orcl" (oh-are-see-el)(without the double-quotes). This worked for me, as I got a connection and could query the database. Other specifics about my connection, my hostname is 'localhost', my port '1521' which coincides with my tnsnames.ora file and I used "system" as my Username. You must use the password that you used in the set up.  Note once you get this working you can add other usernames and passwords for clean connections.
Anh Đạt (2 years ago)
INNo MATHs (2 years ago)
your welcome... :)
brijal doshi (2 years ago)
Thanks a lot for this video....... My error is resolved now....
there is the third possible problem(as in my situation): listener.ora does not exist or was deleted.(sorry for my english) solution: 1) create textFile listener.ora 2)type there --> _____________________________________________________________________________________________________________________ | # listener.ora Network Configuration File: d:\app\Anutosh\product\11.2.0\dbhome_1\network\admin\listener.or | # Generated by Oracle configuration tools. | | SID_LIST_LISTENER = | (SID_LIST = | (SID_DESC = | (SID_NAME = CLRExtProc) | (ORACLE_HOME = d:\app\Anutosh\product\11.2.0\dbhome_1) | (PROGRAM = extproc) | (ENVS = "EXTPROC_DLLS=ONLY:d:\app\Anutosh\product\11.2.0\dbhome_1\bin\oraclr11.dll") | ) | ) | | LISTENER = | (DESCRIPTION_LIST = | (DESCRIPTION = | (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) | (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) | ) | ) | | ADR_BASE_LISTENER = d:\app\Anutosh | ___________________________________________________________________________________________________________________| 3)reboot system
INNo MATHs (2 years ago)
+Еркебулан Исабеков thats a great trick... seriously. There are possible reasons that your .ora file gets deleted. Thanks for sharing this.
Sauron's eye (2 years ago)
Did not help at all :c
I did not help, problem still exists
Subha Mahapatra (2 years ago)
Its really help full... Thank you so much.. it worked
sadman sakib (2 years ago)
Thanks man. This video just saved me
suhagiya vishal (2 years ago)
suhagiya vishal (2 years ago)
+INNo MATHs i already subscibed again thankyou so much
suhagiya vishal (2 years ago)
+INNo MATHs nothing man just share such kind of video it help in the begining world
INNo MATHs (2 years ago)
+suhagiya vishal Please subscribe. We are doing few projects in May. If you have some please suggest.
TheDJGabO (2 years ago)
Mil gracias mi estimado, busqué en todas partes y no encontré ninguna solución, tu vídeo es lo máximo. Saludos desde Perú.
bimlendu kumar (2 years ago)
ohh Man, i am having all things working, but i think i am releasing wrong password...
Ujjawal X (2 years ago)
can there be any other problem because i checked using lsnrctl and also tnsnames.ora file . i am using correct sid , hostname , and port but i still get the same error when i enter the detail in sql developer.
Johnathan10188 (2 years ago)
SID was incorrect, Thanks
Bhanuka Isuru (1 year ago)
me 2..how to fix this
Roxana Eguaras (2 years ago)
Me ayudo!! gracias!! :)
hc mv (2 years ago)
Hello , m ost thanks for the video but despite everything I say , I ora- 12505 the problem persists, that will be ?, thanks for you help.
Abderrahmen ISSA (2 years ago)
The problem I had is that the service OracleServiceXE is not started. You have to start it manually in services console.
Alexei Gladyshev (1 year ago)
Steven K (2 years ago)
+Abderrahmen ISSA Yes thank you! Once I saw this i navigated to Start, menu, all-apps, oracle folder which has database start lol. Windows 10 for anybody else looking. ORA-12505 win10.
INNo MATHs (2 years ago)
+Abderrahmen ISSA yes.. this is one the most specific cause.. Thanks for sharing this information.
Umar Qayyum (2 years ago)
I had made all these things and i am unable to solve my problem and facing another new error as, my error is (IO error: The network adapter could not establish the connection.) My System configuration = selective startup Oracle version= Java version = 8 update 71 Kindly solve my problem
Umar Qayyum (2 years ago)
+Brijesh Patel reinstall it again bro.
Brijesh Patel (2 years ago)
+Umar Qayyum Same weird issue i m also facing, please suggest what to do. Tried all possible way but not able to connect.
Umar Qayyum (2 years ago)
Ok i try to reinstall it . Thank you for your response.
INNo MATHs (2 years ago)
+Umar Qayyum i suggest you to make a reinstall then. You should also reinstall you oracle database. because if you have checked tnsnames.ora and everything is correct then there is some compatibility issue. I hope you have already checked for Port which should be 1521 or1522 as per your oracle.
Umar Qayyum (2 years ago)
+INNo MATHs i match all the details while creating a connection but im still facing that error "network adapter could not establish the connection "
Radwa Sabry (2 years ago)
i made all this things but the error not be solved
INNo MATHs (2 years ago)
+Radwa Sabry what is the error msg? please tell me abt your system configuration and the version of oracle and java you are using.
999abaza (2 years ago)
When I opened the "tnsnames.ora" file I didn't find the lower part of the code starting from "ORCL = (DESCRIPTION = (ADDRESS = ,ETC" What steps did I miss ?! and what shall I do ?? I'm not able to connect the j developer to the database 12c ! :(
999abaza (2 years ago)
+INNo MATHs urw .. I found out that the problem was that database configuration wasn't properly done from the begining ... and thanks for your fast respond :)
INNo MATHs (2 years ago)
+999abaza right now.. i am not sure abt the cause of this problem. I think there is some error (intrinsic) happened during installation. I am monitoring this error. i will surely get to you soon. thanks for leting me know about this problem.
Mladen Skywalker (3 years ago)
First of all, thanks! Second. I did what you write but when I hit test connection it keeps testin and not giving any asnwer whether it's okay or not. I got this error: Scket read timed out. Vendor Code 17002
INNo MATHs (3 years ago)
+Mladen Skywalker This is a problem that can not be explained without having a look in log file. still i think there are two most probable reasons for the problem: 1> you have hosted your database in some other device where listener is not working. (solution: start listener in your host device by using the same commands 'lsnrctl start') 2> may be your OracleService has been stopped for some reasons. (solution: Restart it) steps to restart any service: a> goto start menu, search for services; b> open services and find which service you want to start. if these steps are not rectifying the problem your are facing then plz send me the log file.

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.