ORA-12154: TNS:could not resolve the connect identifier specified
来源:互联网 发布:java线程栈大小 编辑:程序博客网 时间:2024/05/05 12:13
ORA-12154: TNS:could not resolve the connect identifier specified
1. 安装HA-Instant Client-v11.2.0.3.0.exe
2. 安装PLSQL_Developer_cngr
3. 将tnsnames.ora放到HA-Instant Client-v11.2.0.3.0.exe安装目录下的network\admin目录下
4. 在PLSQL_Developer_cngr中配置工具→首选项
5. 输入正确的用户名密码之后,一直报错ORA-12154:TNS:could not resolve the connect identifier specified。
6. 网上的解决办法都是重启oracle服务之类的,但是本机确实是没有安装oracle,plsql的安装路径也是没有问题的。
7. 最终的解决方式是:配置环境变量:
变量名为:TNS_ADMIN
变量值为:tnsnames.ora 文件所在路径
0 0
- ORA-12154: TNS:could not resolve the connect identifier specified
- ORA-12154: TNS:could not resolve the connect identifier specified
- ORA-12154: TNS:could not resolve the connect identifier specified
- ORA-12154:TNS could not resolve the connect identifier specified
- ORA-12154: TNS: could not resolve the connect identifier specified
- ORA-12154:TNS:could not resolve the connect identifier specified
- ORA-12154: TNS:could not resolve the connect identifier specified
- ORA-12154: TNS:could not resolve the connect identifier specified
- ORA-12154: TNS:could not resolve the connect identifier specified
- ORA-12154: TNS:could not resolve the connect identifier specified
- ORA-12154: TNS:could not resolve the connect identifier specified
- ORA-12154: TNS:could not resolve the connect identifier specified
- ORA-12154: TNS:could not resolve the connect identifier specified
- ORA-12154: TNS:could not resolve the connect identifier specified
- ora--12154 :TNS :could not resolve the connect identifier specified
- ORA-12154: TNS:could not resolve the connect identifier specified
- ORA-12154: TNS:could not resolve the connect identifier specified
- 使用sqlplus连接数据库时报"ORA-12154:TNS:could not resolve the connect identifier specified"解决办法
- 命令行
- LeetCode Weekly Contest 25 之 537.Complex Number Multiplication
- 支付宝接口调用
- CentOS6.5下Redis安装与配置
- js中的鼠标移动
- ORA-12154: TNS:could not resolve the connect identifier specified
- c++ 默认参数
- 曲率卷积核提取图像曲率
- 2017网易笔试矩阵快速幂
- jquery 总结
- QQ第三方登陆接口
- android网络学习中没有接口的尴尬
- 线程通信---1.wait/notify
- 服务器篇01-配置SSH