Ora-12154 after installing odp.net

Learn more. Asked 11 months ago. Active 9 months ago. Viewed times. I find lots of posts about the ORA TNS:could not resolve the connect identifier specified error error but all discussions about potential fixes evolve around client configuration issues. Kestrel[13] T Improve this question.

Add a comment. Active Oldest Votes. Improve this answer. EdStevens EdStevens 3, 2 2 gold badges 8 8 silver badges 17 17 bronze badges. The redacted connection string is in the log snippet and it does not reference a TNS name.

Also, I matched the connection string to the one suggested by Branko in his answer to this question but have tried a number of variations that all did not work, either.

See oracle. It will describe more exotic problems. In this article i will explain how ORA error will solve and why this error will come. This is the most common error and most searched error by developers and DBAs.

This error will come while trying to establish connection first time. So this is most common error in oracle. This error will come when oracle is unable to locate the service name specified in ODBC data source. I have seen people across trying to make this work after installing InstantClient. So, to workaround this problem, we can choose one of the following solutions:. Even if the user does not have all the database connection information readily available, Oracle recommends inserting placeholder values during the install process, then modifying the tnsnames.

NET tnsnames. NET's settings order of precedence. The tnsnames. NET, Unmanaged Driver. Oracle recommends using an app. Once the first tnsnames.

That means all Oracle Client configuration settings must be made in the app. Machine-wide configuration makes global changes to the machine's. Xcopy installations always create a machine. If non-machine-wide configuration is selected, then none of these changes are made. Starting with release For existing Oracle homes, ODAC re-installs the default to the same configuration setting chosen for that Oracle home from the previous installation.