Oracle Listener how to handle error message ORA 12541 TNS no listener

[@nitishnagar1]

You did a great job explaining everything calmly and I thank you for that!

[@DataScienceCenter]

Glad it was helpful!

[@harshtejani5749]

it worked for me thanks 🙏 I was so close to get 0 in my assignments as oracle was not starting but you saved me .

[@DataScienceCenter]

Glad it was helpful.

[@niteshirctc]

Hey, I'm new in SQL. I've created DB,Users & Tables in Oracle also I've used 7-8 days and inserted approx 7Lakhs data in my db, suddenly I'm getting error like" ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
" and also TNS Admin environment variable is not defined." Please help me to resolve this error.
NOt able to login also.

[@niteshirctc]

I'm waiting for response.. Please help anyone

[@niyazawa]

I have the same problem. I installed Oracle and used it about 2 weeks, everything was ok, but now I cannot find the solution and even don't know what caused this error :/

[@yo_swarnali]

I'm having the same error now, can you please help me? :(

[@awo618]

you saved my life. Thanks so so much!

[@DataScienceCenter]

welcome always.

[@anmolwankhede9714]

thanks you are angel really helped me a lot waste 2 hours on this problem.

[@DataScienceCenter]

pleasure, dont forgot to subscribe it.

[@jawaharlagisetty953]

Thanks a lot sir I am saved by you . Today ❤

[@DataScienceCenter]

All the best

[@salehbawazir4665]

Thanks man, God bless you❤

[@DataScienceCenter]

Glad it helped

[@marcodosantosh9000]

Thanks You are my Hero :D

[@shirel_2478]

Thank you!! You saved me!!

[@DataScienceCenter]

Glad I could help!

[@thapelomatibidi7440]

It worked........U saved my ass 🙏🙏🙏🙏🙏🙏

[@ashishroutray9486]

Failed to start the listener service , error 3:the system cannot find the path specified .
Please slove why this problem happen

[@sigitprasetya9346]

Namashte..... its working, thank you

[@DataScienceCenter]

You're most welcome

[@walterleon2450]

Thank you!! I forget run cmd as administrator. Resolved!

[@DataScienceCenter]

Great, keep learning.

[@renjishacyril2757]

Solved my problem, Thank you so much

[@DataScienceCenter]

My pleasure

[@radwaelmansy2125]

Thank you so much you helped me a lot

[@DataScienceCenter]

Glad to hear that!

[@hiphopheaven]

I have this error ORA-12514: TNS:listener does not currently know of service requested in connect

[@hemantdeshpande2443]

I also have the same error, how did you resolve this?

[@kathirs3125]

Nice clear the problem. Thank You

[@jimochi1233]

Bro when I'm typing lsrnctl start it's giving unable to open SCManager err 203 and giving protocol adapter error please help bro?

[@user-wc1fp4ph4d]

Make sure to run CMD as administrator

[@RD-Man]

This tool is missing for me.

[@mahimagoel1511]

mine its showing listener using listener name LISTENER has already been started. and same error exits..please solve the problem

[@DataScienceCenter]

restart the services and also reload listner

[@juliotsd]

tome su like buen hombre!

[@ashwinkumar5223]

Getting this listener problem while connecting to Oracle from power bi.

[@pratibhakoli4047]

Still not start Oracle listener

[@maninangcathym.6683]

Mine still not working 😭

[@Bytux953]

Thankyou so much

[@DataScienceCenter]

Tinwa Ninja welcome

[@negrepm.castro6152]

Thanks for the video but in my case is asking me for the sys's password I put my PC password but it say incorrect, which password do I have to use? Once again thanks for your help

[@DataScienceCenter]

Thanks for watching video. for sys user password issue please watch the video:
th-cam.com/video/1mEOYM-y7fw/w-d-xo.html

[@aimenmirza3088]

Solved my problem. Thank you

[@DataScienceCenter]

Always welcome..

[@brv4589]

Thanks a lot!

[@DataScienceCenter]

You're welcome!

[@rationale309]

Awesome

[@DataScienceCenter]

Thank you.

[@josecaira1112]

thank you!!!!!!

[@DataScienceCenter]

You're welcome!

[@akiemak9675]

Thank you bro/sis

[@DataScienceCenter]

My pleasure.

[@satyanarayankumar7272]

Thank You Sir

[@DataScienceCenter]

Most welcome

[@etherealcharms]

Thanks

[@sword013]

Does not work at all.

[@DataScienceCenter]

cab you share the detail of following command using CMD:
lsnrctl status
lsnrctl services

[@mohammedbinzidane4660]

Thank you alots

[@DataScienceCenter]

Always welcome

[@mohammedbinzidane4660]

@@DataScienceCenter the same error back after one day

[@krynglak]

Thank's man i had a problem with super slow working listener but your video helped
I Had to big file:$ORACLE_BASE\diag\tnslsnr\\listener\trace\listener.log
I stopped listener service, delete listener.log and start listener service

[@DataScienceCenter]

Glad i could help!

[@gustavoinay]

Solved my problem. Thank you