开发者

Error while connecting to oracle DB

开发者 https://www.devze.com 2023-04-04 08:03 出处:网络
I have an error while trying to connect to oracle db. The error is: ORA-12154: TNS:could not resolve the connect identifier specified

I have an error while trying to connect to oracle db.

The error is:

ORA-12154: TNS:could not resolve the connect identifier specified

When i launch the application and login, sometimes 开发者_开发知识库this error occur and sometimes not. in other words when logging into the system, the error pops only for certain users!

what might be the issue?


There might be a problem with the TNSNAMES.ORA file in the Oracle Client installation for those affected users. Check the TNS definitions.


This is 98% of the time an issue on the user's client (typically PC) with missing/wrong tnsnames.ora and/or sqlnet.ora files. Since it works for some users, make sure the files sqlnet.ora and tnsnames.ora exist for the problem users, and that they are the same version. You can also check the value of registry variable TNS_ADMIN, and look for the presence of multiple oracle homes. Sometimes developers inadvertently modify this situation by installing extra goodies, and then they don't pick up new changes.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号