ORA-12514:TNS:listener does not currently know of service requested in connect descriptor

来源：学生作业帮助网编辑：作业帮时间：2024/05/10 17:07:11

ORA-12514:TNS:listener does not currently know of service requested in connect descriptor
ORA-12514:TNS:listener does not currently know of service requested in connect descriptor

ORA-12514:TNS:listener does not currently know of service requested in connect descriptor
建了个数据库（名：d0647073 sid：d0647073）
在用户登录的过程中出现如下错误：
Listener refused the connection with the following error:ORA-12514,TNS:listener does not currently know of service requested in connect descriptor The Connection descriptor used by the client was:(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=zsl)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=d0647073)))
解决方式：把注册表的ORA_D0647073_AUTOSTART值改为true,然后重新启动数据库的服务.（此问题可能有其他原因引起,但是这是一种原因）
在学习的过程中对这个问题有了进一步的认识：
其实它是数据库启动时,数据库的例程没有加载,也就说在注册表的ORA_D0647073_AUTOSTART值为FALSE在数据库启动时不自动加载例程.
另一种解决方法：
进入命令行,以sys用户登录
然后执行以下命令：
startup nomount；
alter database mount；
alter database open

修改\oracle\product\11.1.0\db_1\network\admin\listener.ora文件
加上
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = 你的数据库名称)
(ORACLE_HOME = D:\oracle\product\10.1.0\db_1)
)
)
然后重启lisener服务，就ok了

ORA-12514:TNS:listener does not currently know of service requested in connect descriptor java.sql.SQLException:Listener refused the connection with the following error:ORA-12505,TNS:lisjava.sql.SQLException:Listener refused the connection with the following error:ORA-12505,TNS:listener does not currently know of SID given in connect desc ORA-12505,TNS:listener does not currently know of SID given in connect descriptor怎么解决?求大师 java.sql.SQLException: Listener refused the connection with the following error: ORA-12505, TNS:服务里面的OracleServiceORCL和OracleOraDb11g_home1TNSListener都打开了,LISTENER.ORA下面的（HOST=zhangyang）也改成计算机名了,没用loc ERROR:ORA-12504:TNS:监听程序在 CONNECT_DATA 中未获得 SERVICE_NAME使用本地的SQLPlus连接服务器上的Oracle数据库,系统先提示：ORA-12504:TNS:监听程序在 CONNECT_DATA 中未获得 SERVICE_NAME再次输入用户名密码系具体信息如下：java.sql.SQLException:Listener refused the connection with the following error:ORA—12505,TNS：Listener dose not currentlly kown of SID given in connect descriptor the connection description used by client was 127.0.0.1:1521:yx 打不开nc,提示信息是java.sql.SQLException:Listener refused the connection wit我安装的是oracle数据库。具体的提示信息如下：java.sql.SQLException:Listener refused the connection with the following error:ORA—12505，TNS：List Myeclipse开发：ORA-12505,TNS:listener does not currently know of SID given in connect descriptor.开发环境：Myeclipse 6.5,Tomcat 5.5,oracle 10g,数据库服务器在IP为192.168.10.10的机子上,用户为：username.密码是：password,数意大利语ora ma minu 欧美歌手rita ora外号? tnsnames.ora是什么文件, Listen listen Listen Listen ORA-12514错误,用sqlplus连接oracle数据库,登陆时出现ORA－12514错误,说service－name不能解析?oracle中net端已经配置好并测通了sqlplus中tnsnames.ora文件如下：LISDB =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = T 借助sqlplus如何查找 spfile.ora,listener.ora ,tnsnames.ora,以及listener.log 的所在位置 Da ora in poi,voi tutti,ti