ORA-12514:TNS:listener does not currently know of service re

来源：学生作业帮编辑：大师作文网作业帮分类：综合作业时间：2024/11/12 13:25:42

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

ORA-12505,TNS:listener does not currently know of SID given We're sorry that service is currently unavailable 求中文翻译 System is currently under maintainance.All service are not a 借助sqlplus如何查找 spfile.ora,listener.ora ,tnsnames.ora,以及listen We're sorry.Our Service is currently only available in Mainl 为什么多米音乐主页会出现We're sorry. Our Service is currently only avail Your device does not currently have any browser configuratio She does not know . 我玩美服CF We're sorry,but this offer is not currently available Service currently unavailable什么意思``尽快回答`` We're sorry,you are not allowed access to the service you re Do not know what you're talking?