pl/sql ORA-12154: TNS:could not resolve the connect identifier specified的问题
来源:互联网 发布:软件技术职称 编辑:程序博客网 时间:2024/06/05 15:06
问题描述:安装完pl/sql以后 ,pl/sql连接数据库出现ora-12154错误:我这边是 服务器端,客户端都安装了。
我的服务器端 tnsnames没有问题。
# tnsnames.ora Network Configuration File: C:\app\Administrator\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
GZDBX =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = WIN-16VO2U84739)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = gzdbx)
)
)
----------------------------------------以上名字不存在空格问题---------------------------------------------------------
然后根据网上所说的问题检查路径:
原来:C:\app\Administrator\product\11.2.0\client_1\bin;D:\app\Administrator\product\11.2.0\dbhome_1\bin;%JAVA_HOME%\bin;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;%SYSTEMROOT%\System32\WindowsPowerShell\v1.0\
-------------------------------------------------------------------------------------------------
CMD命令行里面 输入tsnping
C:\Users\Administrator>tnsping dbframework_gz
TNS Ping Utility for 64-bit Windows: Version 11.2.0.4.0 - Production on 03-7月
2017 16:55:16
Copyright (c) 1997, 2013, Oracle. All rights reserved.
已使用的参数文件:
D:\app\Administrator\product\11.2.0\dbhome_1\network\admin\sqlnet.ora
TNS-03505: 无法解析名称
-------------------------------------------------------------------
根据以上已使用的参数文件结合环境变量里面的path路径:
决定修改path路径为
D:\app\Administrator\product\11.2.0\dbhome_1\bin;C:\app\Administrator\product\11.2.0\client_1\bin;%JAVA_HOME%\bin;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;%SYSTEMROOT%\System32\WindowsPowerShell\v1.0\
----------------------------修改以后,pl/sql链接仍然报ORA-12154错误------------------------------------------------
最终解决方案:在客户端第二个截图目录下粘贴一份从服务器端拷贝的tnsnames文件 解决问题,
此时进去cmd 输入tnsping dbframework_gz 仍然会提示03505错误,不影响链接,pl/sql已经可以正常链接
--------------------------------------中途不报12154错误后,会提示----
环境变量里面配置:
NLS_LANG
SIMPLIFIED CHINESE_CHINA.ZHS16GBK
即可,
最终问题解决。
- pl/sql ORA-12154: TNS:could not resolve the connect identifier specified的问题
- PL/SQL Developer 中的另一个问题:ORA-12154: TNS:could not resolve the connect identifier specified
- PL/SQL developer连接oracle出现“ORA-12154:TNS:could not resolve the connect identifier specified”问题的解决
- 用PL/SQL连接oracle遇到的问题及解决方法:ORA-12154:TNS:could not resolve the connect identifier specified。。
- PL/SQL developer连接oracle出现“ORA-12154:TNS:could not resolve the connect identifier specified”问题的解决
- PL/SQL 报错(ORA-12154:TNS:could not resolve the connect identifier specified)解决
- PL/SQL ORA-12154: TNS:could not resolve the connect identifier specified
- PL/SQ连接oracle数据库的问题,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
- JSP内置对象
- 适配器模式 有感
- 4102:宠物小精灵之收服
- Android Fragment Activity View中集成React Native页面
- SSO单点登录基本概念实现思路以及小的实例详解
- pl/sql ORA-12154: TNS:could not resolve the connect identifier specified的问题
- Spark-Spark Streaming例子整理(一)
- jQuery源码阅读(二)---初识init方法
- Activity的taskAffinity属性
- JavaScript Prototype 详解
- CentOS7 安装 MongoDB
- 【形状匹配算法】Shapecontext形状上下文算法的研究
- Linux 命令
- H264音视频编解码高质量博客