Smart Info About How To Resolve Ora-12154

In other words, you establish a connection via the listener, to an.

How to resolve ora-12154. Error 12154 orasys as sysdbaselect * from global_name;or show parameter service_name;the service that u see. Tns:could not resolve the connect identifier specified what i have tried: Tns:could not resolve the connect identifier specified.

Make sure that the service name that you are. Check if the indentation of the connection strings in the file tnsnames.ora is correct. What the listener unable to connectopen d:\app.

Listener = (address = (protocol = tcp)(host =. When application try to connect to an oracle service via oracle. There is no alias orclpdb in your tnsnames.ora, so oracle complains that it can't find it.

Tns:could not resolve the connect identifier specified.oracle database: You are trying to connect to demo/password@orclpdb. Tns alias could not be resolved into a connect descriptor below is a list of.

Here is a sample string: Make sure your tnsnames.ora file is updated to your new database in the oracle folder and it will work fine. Something is wrong with the way the alias is created in the tnsnames.ora file (incorrect syntax) 3.

It told us that we should use a matched. I had the same issue and couldn't figure out what was happening,. 2 how to fix it.