ORA-12154: TNS:could not resolve the connect identifier specified
来源:互联网 发布:淘宝背景怎么下调 编辑:程序博客网 时间:2024/05/18 22:46
在安装PL/SQL来连接oracle数据库时,发现如下错误:
ORA-12154: TNS:could not resolve the connect identifier specified
经过百度,解决方案如下:
在用户变量的系统变量中新建如下变量;
变量名为:TNS_ADMIN
变量值为:%ORACLE_HOME%/NETWORK/ADMIN/
其中 %ORACLE_HOME% 即 Orcale 的安装路径,
其实,设置的该环境变量的值为 tnsnames.ora文件所在路径,特别是重装后或其它操作,忘了设置TNS_ADMIN 变量,PL/SQL 登陆就会报“无法解析指定的连接标识符”的错误 ,而设置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"解决办法
- ExtJS中的accordion布局如何展开特定的item
- 字符串-04 字符串逆序(15)
- 关于oracle登录出现ORACLE initialization or shutdown in progress
- Android基础和进阶知识总结
- JS event使用方法详解
- ORA-12154: TNS:could not resolve the connect identifier specified
- js forEach
- Effective C++ 条款19
- oracle 查询前一小时、一天、一个月、一年的数据
- 关于shape的corners问题
- 活动倒计时代码(精确到毫秒)jquery插件
- 【ios开发系列】block详解
- Java事务
- 67.读入字符串把每个单词开始的字母大写