Тёмный

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

Подписаться
Просмотров 74 тыс.
% 327

Step to handle the error message ORA-12541: TNS:no listener
Right Click on Command Prompt, and click on Run as Administrator, then write following command:
lsnrctl start
lsnrctl services
lsnrctl status
lsnrctl start
lsnrctl services
lsnrctl status

Опубликовано:

 

12 ноя 2017

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 66   
@niteshirctc
@niteshirctc 4 года назад
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
@niteshirctc 4 года назад
I'm waiting for response.. Please help anyone
@niyazawa
@niyazawa 4 года назад
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
@yo_swarnali 2 года назад
I'm having the same error now, can you please help me? :(
@nitishnagar1
@nitishnagar1 2 года назад
You did a great job explaining everything calmly and I thank you for that!
@DataScienceCenter
@DataScienceCenter 2 года назад
Glad it was helpful!
@harshtejani5749
@harshtejani5749 2 года назад
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
@DataScienceCenter 2 года назад
Glad it was helpful.
@ashishroutray9486
@ashishroutray9486 4 года назад
Failed to start the listener service , error 3:the system cannot find the path specified . Please slove why this problem happen
@anmolwankhede9714
@anmolwankhede9714 3 года назад
thanks you are angel really helped me a lot waste 2 hours on this problem.
@DataScienceCenter
@DataScienceCenter 3 года назад
pleasure, dont forgot to subscribe it.
@jawaharlagisetty953
@jawaharlagisetty953 11 месяцев назад
Thanks a lot sir I am saved by you . Today ❤
@DataScienceCenter
@DataScienceCenter 11 месяцев назад
All the best
@walterleon2450
@walterleon2450 Год назад
Thank you!! I forget run cmd as administrator. Resolved!
@DataScienceCenter
@DataScienceCenter Год назад
Great, keep learning.
@salehbawazir4665
@salehbawazir4665 2 года назад
Thanks man, God bless you❤
@DataScienceCenter
@DataScienceCenter 2 года назад
Glad it helped
@radwaelmansy2125
@radwaelmansy2125 Год назад
Thank you so much you helped me a lot
@DataScienceCenter
@DataScienceCenter Год назад
Glad to hear that!
@thapelomatibidi7440
@thapelomatibidi7440 2 года назад
It worked........U saved my ass 🙏🙏🙏🙏🙏🙏
@jimochi1233
@jimochi1233 2 года назад
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
@user-wc1fp4ph4d 11 месяцев назад
Make sure to run CMD as administrator
@marcodosantosh9000
@marcodosantosh9000 3 года назад
Thanks You are my Hero :D
@awo618
@awo618 5 лет назад
you saved my life. Thanks so so much!
@DataScienceCenter
@DataScienceCenter 5 лет назад
welcome always.
@mahimagoel1511
@mahimagoel1511 5 лет назад
mine its showing listener using listener name LISTENER has already been started. and same error exits..please solve the problem
@DataScienceCenter
@DataScienceCenter 5 лет назад
restart the services and also reload listner
@sigitprasetya9346
@sigitprasetya9346 3 года назад
Namashte..... its working, thank you
@DataScienceCenter
@DataScienceCenter 3 года назад
You're most welcome
@hiphopheaven
@hiphopheaven 6 лет назад
I have this error ORA-12514: TNS:listener does not currently know of service requested in connect
@hemantdeshpande2443
@hemantdeshpande2443 5 лет назад
I also have the same error, how did you resolve this?
@renjishacyril2757
@renjishacyril2757 4 года назад
Solved my problem, Thank you so much
@DataScienceCenter
@DataScienceCenter 4 года назад
My pleasure
@negrepm.castro6152
@negrepm.castro6152 2 года назад
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
@DataScienceCenter 2 года назад
Thanks for watching video. for sys user password issue please watch the video: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-1mEOYM-y7fw.html
@gustavoinay
@gustavoinay 5 лет назад
Solved my problem. Thank you
@shirel_2478
@shirel_2478 4 года назад
Thank you!! You saved me!!
@DataScienceCenter
@DataScienceCenter 4 года назад
Glad I could help!
@RD-Man
@RD-Man Год назад
This tool is missing for me.
@kathirs3125
@kathirs3125 6 лет назад
Nice clear the problem. Thank You
@ashwinkumar5223
@ashwinkumar5223 10 месяцев назад
Getting this listener problem while connecting to Oracle from power bi.
@juliotsd
@juliotsd 3 года назад
tome su like buen hombre!
@pratibhakoli4047
@pratibhakoli4047 Год назад
Still not start Oracle listener
@rationale309
@rationale309 2 года назад
Awesome
@DataScienceCenter
@DataScienceCenter 2 года назад
Thank you.
@akiemak9675
@akiemak9675 3 года назад
Thank you bro/sis
@DataScienceCenter
@DataScienceCenter 3 года назад
My pleasure.
@maninangcathym.6683
@maninangcathym.6683 3 года назад
Mine still not working 😭
@brv4589
@brv4589 3 года назад
Thanks a lot!
@DataScienceCenter
@DataScienceCenter 3 года назад
You're welcome!
@Bytux953
@Bytux953 6 лет назад
Thankyou so much
@DataScienceCenter
@DataScienceCenter 6 лет назад
Tinwa Ninja welcome
@satyanarayankumar7272
@satyanarayankumar7272 2 года назад
Thank You Sir
@DataScienceCenter
@DataScienceCenter 2 года назад
Most welcome
@josecaira1112
@josecaira1112 4 года назад
thank you!!!!!!
@DataScienceCenter
@DataScienceCenter 4 года назад
You're welcome!
@etherealcharms
@etherealcharms 5 лет назад
Thanks
@mohammedbinzidane4660
@mohammedbinzidane4660 2 года назад
Thank you alots
@DataScienceCenter
@DataScienceCenter 2 года назад
Always welcome
@mohammedbinzidane4660
@mohammedbinzidane4660 2 года назад
@@DataScienceCenter the same error back after one day
@sword013
@sword013 3 года назад
Does not work at all.
@DataScienceCenter
@DataScienceCenter 3 года назад
cab you share the detail of following command using CMD: lsnrctl status lsnrctl services
@krynglak
@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
@DataScienceCenter Год назад
Glad i could help!
@aimenmirza3088
@aimenmirza3088 5 лет назад
Solved my problem. Thank you
@DataScienceCenter
@DataScienceCenter 5 лет назад
Always welcome..