ora 12505 || ora-12505: TNS:listener does not currently know of SID [solved] ✅ || 12505

In this oracle database software tutorial will guide to fix the error ora 12505, ORA-12505: TNS:listener does not currently know of SID in oracle database
-
#12505 #ora12505 #oracle 12505 #oracledatabasesolutions
-
Following Search made for above Error.
listener does not currently know of sid given in connect descriptor jdbc.
tns listener does not currently know of sid sql developer.
listener could not resolve sid given in connect descriptor.
listener does not currently know of sid given.
vendor code 12505 sql developer
ora 12505 in sql developer
ora 12505 listener does not currently know of sid
12505 oracle
vendor code 12505
oracle 12505
listener does not currently know of sid
tns listener does not currently know of sid
listener does not currently know of service requested in connect descriptor
listener does not currently know of sid given in connect descriptor
tns:listener does not currently know of sid sql developer
oracle sql developer tns listener does not currently know of sid given in connect descriptor
how do you fix ora-12505, tns:listener does not currently know of sid given in connect descriptor
ora-12514, tns:listener does not currently know of service requested in connect descriptor
tns:listener does not currently know of sid given in connect descriptor (dbd error: ociserverattach)
use_sid_as_service_listener=on
ora-12521: tns:listener does not currently know of instance requested in connect descriptor
ora-12505 jdbc

[@sayprang]

thank you, that solved! 👍

[@dhivyashreeramachandran3404]

After services to cmd where did you come?
please show that what have you entered in cmd prompt right from beginning sir!

[@VikT0_0]

привет из России))спасибо за видос,долго не мог понять в чем дело,иногда запускается,но чаще нет)теперь знаю как руками это запускать)

[@user-ct6my2cd5q]

Thanks alot..

[@jayeshpawar3375]

Thank you saved me from hours of struggle ❤

[@kaavyashreep294]

In my computer , SID is also correct and my Listener is also working ... But i could not able to connect .. still i get ORA-12505 error... Please help me 😭

[@ashishshelke474]

You just saved my day, fabulous debugging and issue solving

[@amrendersingh3157]

Yes it's helpful to find and resolve the issue of sid

[@bilahhakim]

thanks a lot !so the problem was my oracle service didnt start lmao

[@geniusfreetraining]

1) services.mse check TNSListener services is up, otherwise start it manually
2) connect SQLPLUS as SYS as SYSDBA
3) shutdown immediate
4) startup

[@phaiyeenyin2850]

thank you so much

[@shivanaveen3754]

From services to cmd who did u came plz show that what have u entered in cmd from beginning

[@oracledatabasesolutions]

cmd open from windows run prompt .

[@oracledatabasesolutions]

do you have oracle express edition or database installed on windows ? then use that database sid.

[@oracledatabasesolutions]

also reach us on [phone] if still unable to fix it.

[@shivanaveen3754]

@@oracledatabasesolutions I have installed Oracle 11g enterprise edition on windows 10

[@lavanyareddy2172]

8.26 at that time page where we get ... I am not finding that page..

[@1012rizzu]

thank alot bro

[@kotinarisetti322]

Thank you bro

[@vaibhavc1110]

Thank you..

[@reddy5710]

Hi sir,me also facing the same issue how it resolved in windows

[@parameshkempili5345]

Thanks bro

[@championsleague-2997]

how entry to to this black screen on 2:07 pls help

[@shivanaveen3754]

I tried but not connected to db

[@oracledatabasesolutions]

from windows run , use services.msc then find oracleservice and oraclelistener to start. or go to control panel then tools - open services.

[@ashrafshaik9673]

@@oracledatabasesolutions hey when i started the oracleservice the problem got rsolved