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!!
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?
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/"p@ssword"
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
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
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)...
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 ·
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 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/"p@sswor
J'ai utilisé cette méthode et cela résolu mon problème. Merci beaucoup pour ce tuto simple et clair
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!!
+Daniel Saldinata that's awesome mate.
Thanks you so much i got resolve the issue after seeing this video.
good in fix mate
Thanks a lot. This video saved my life.
Hi, can you take oracle AMC ?
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?
Although my service name was same But I was not able to login. But this was learning for sure. Thanks Pal.
+Atul Tambe Thank you video watch.
Hi sorry but where can i find the tnsnames.ora file ?
D:\app\"user"\product\12.1.0\client_1\Network\Admin
@@MokhetheaLenyalo not able to find there also?
I have this error ORA-12514: TNS:listener does not currently know of service requested in connect
Did u fine the sol
@@nandiniagarwal8561 It's been 2 years I don't remember.
Bro it's not connecting only,
Service name is db name...!!!! right ? ..so how you change that one ..if possible pls show us .......
Thank you very much it works for me
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/"p@ssword"
Lem Bulangis Thank you😄
Thanks!
tyyyyyyyyyyyyy
Thank you so much
Thanks ..
The service name was the same as the parameter value yet still getting the error
Same with me
I flowed step by step but the still not work
Thank you so much! This video helped me a lot!
+theluffy99 Thank you watch video.
Still am getting the error
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
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
Anass Nouli Sorry but I am not sure what problem could be. Best of luck with search for solution.
not working
Thank you so much
nice work ...... Thank you
Love u brother
I have this error issue.
ERRO:
ORA-12543: TNS:host de destino inatingível
I chang the name but not replace show me Acces is denie how to solve
Why a txt file and not yourself speaking?? Why?!
7oi8
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)...
+Poke A Brain review good. Thanks!
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 ·
Suneel Kalapala i cannot help. good luck.
I like how most of this video is a microphone recording of him typing...
Duane Janes - And change your smoke detector battery.
Thanks
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 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/"p@sswor
OMG bro thank you! i cant believe it was that easy after trying almost every other solution on the internet.