HomeЛюди и блогиRelated VideosMore From: DBA Pro

How to resolve the ora 12154 error

63 ratings | 101777 views
In this tutorial you will learn how to resolve the ora 12145 error.
Html code for embedding videos on your blog
Text Comments (32)
Allan Kataku (1 month ago)
J'ai utilisé cette méthode et cela résolu mon problème. Merci beaucoup pour ce tuto simple et clair
Don Proshetsky (3 months ago)
The service name was the same as the parameter value yet still getting the error
Gonzalo Diaz (3 months ago)
what about if your are not the administrator... and you connect to mutiple db. Every connection give that shitty messagge every fucking time. I have replaced tnsnames.ora file with one provided for the administrator but still can not loggin
Ismail Ghedamsi (6 months ago)
I have this error ORA-12514: TNS:listener does not currently know of service requested in connect
Muhammad Ayaz (6 months ago)
I chang the name but not replace show me Acces is denie how to solve
SAM (9 months ago)
I have this error issue. ERRO: ORA-12543: TNS:host de destino inatingível
Rashid Kaim Khani (1 year ago)
nice work ...... Thank you
Asadul Islam (1 year ago)
Service name is db name...!!!! right ? ..so how you change that one ..if possible pls show us .......
Rajesh Chukka (1 year ago)
ora-12154 tns could not resolve the connect identifier if you are still facing this error please go through this !!!! same error we will get if we don't follow the oracle password policies check the below link for password setup rules for oracle https://docs.oracle.com/cd/B28359_01/network.111/b28531/guidelines.htm#CHDEGEIF I also had this issue, and the root cause was, my password has '@' character. I just enclosed the password in double quotes and it worked. e.g. connect system/"[email protected]
Starr Ship (2 years ago)
Getting the same error, but only when trying to create an ODBC connection in Windows; SQL Developer and other tools are able to successfully connect using the exact same TNS entry that fails for the ODBC connection. The Service name in the TNS did need updated, but the other tools were able to connect with the both the old and new Service name while ODBC connections to this DB still fail. There is a VPN involved, and we haven't completely ruled out a setting there, but it is unlikely to be the culprit and we were connected at the time the error was generated. The only Oracle docs I've found so far for this particular error only talk about the accuracy of the TNS entry, but given that we are using that exact TNS definition to connect through other tools I don't believe that it is the issue. Anyone have any thoughts?
Lem Bulangis (2 years ago)
I also had this issue, and the root cause was, my password has '@' character. I just enclosed the password in double quotes and it worked. e.g. connect system/"[email protected]"
Muskan Sahu (6 days ago)
Lem Bulangis Thank you😄
hc mv (2 years ago)
Hello, with i resolve the error ORA-12505,Please?
DBA Pro (2 years ago)
+hc can lookup error, no solution now. good luck search fix.
theluffy99 (2 years ago)
Thank you so much! This video helped me a lot!
DBA Pro (2 years ago)
+theluffy99 Thank you watch video.
Atul Tambe (2 years ago)
Although my service name was same But I was not able to login. But this was learning for sure. Thanks Pal.
DBA Pro (2 years ago)
+Atul Tambe Thank you video watch.
Poke A Brain (2 years ago)
You made me realize I had a bad tnsnames.ora file.. thanks !just a quick comment: (if you're going to type, maybe have a few notepad files already typed with what you're going to say, that way you don't make people wait while you type :) (and fix stuff)...
DBA Pro (2 years ago)
+Poke A Brain review good. Thanks!
Daniel Saldinata (2 years ago)
u helped me connecting to the sample schema by understanding this video which is, is the same problem of ora 12154 error. i m new to oracle and this video help me a lot. BIG THANKS!!
DBA Pro (2 years ago)
+Daniel Saldinata that's awesome mate.
Sameer Hamid (2 years ago)
Thanks
Duane Janes (3 years ago)
I like how most of this video is a microphone recording of him typing...
Duane Janes (3 years ago)
+Duane Janes - And change your smoke detector battery.
Suneel Kalapala (3 years ago)
Hi Please tell me where we can find tnsnames.ora file ? I coudn't find  Mokhethea Lenyalo mentioned path: Mokhethea Lenyalo 4 months ago  D:\app\"user"\product\12.1.0\client_1\Network\Admin  Reply  ·
DBA Pro (3 years ago)
+Suneel Kalapala i cannot help. good luck.
Sharl Websurfer (3 years ago)
Good explanation! I had this error in the past and I solved it through http://www.oracle-error.com/11g/ORA-12154.html
Anass Nouli (3 years ago)
i have the erreur message when i try to connect from Visual studio i have no probleme on the tnsnames and i can connect my db  from rman dunno what to do help please
DBA Pro (3 years ago)
+Anass Nouli Sorry but I am not sure what problem could be. Best of luck with search for solution.
Anass Nouli (3 years ago)
Hi sorry but where can i find the tnsnames.ora file ?
Mokhethea Lenyalo (3 years ago)
D:\app\"user"\product\12.1.0\client_1\Network\Admin

Would you like to comment?

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