ORA-12514错误:Listenerrefusedtheconnectionwiththefollowing&


ORA-12514错误:Listener refused theconnection with the following error

Orcale学习——无法监听(Listener refused the connection with the follo...

最近学习Orcale遇到下面的问题:

Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of servicerequested in connect descriptor
The Connection descriptor used by the client was:
//localhost:1521/ecmis

昨天还正常呢,今天就报错误了;

在网上查了很多资料,虽然浪费了很多时间,不过还是解决了

原来是由于ip地址改变引起的“ORA-12541:TNS:无监听程序”错误

解决方法:

查看listener.ora的内容:
# listener.ora Network Configuration File:D:oracleproduct10.2.0db_1networkadminlistener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC=
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:oracleproduct10.2.0db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
ORA-12514错误:Listenerrefusedtheconnectionwiththefollowing&
(DESCRIPTION=
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST= localhost)(PORT= 1521))
)
)

原来本机的ip发生改变后,就出现了上述问题,改变数据库的监听ip地址:
把(ADDRESS = (PROTOCOL = TCP)(HOST=localhost)(PORT= 1521))
改成
(ADDRESS = (PROTOCOL = TCP)(HOST= 计算机名)(PORT =1521))

在重启下监听器就可以了

  

爱华网本文地址 » http://www.aihuau.com/a/25101012/145038.html

更多阅读

错误SyntaxError illegal character的解决方法 syntax error near

错误SyntaxError illegal character的解决方法——简介今天写jquery,fireBug报的错误:SyntaxError:illegalcharacter.自己稍微看了一会就解决了。但想到光大的js初学者可能会有点问题,把它的解决方法分享出来。错误SyntaxError illeg

工信部ICP备案系统的电话格式错误 域名icp工信部备案

工业和信息化部为国家通信管理部门,是制定通信行业标准的权威机构,但在其ICP/IP地址/域名信息备案管理系统中出现了一个非常外行的错误:要求用户在填写备案信息时,按照以下格式输入固定电话号码:“办公电话填写标准格式:国家代码-区号-号

声明:《ORA-12514错误:Listenerrefusedtheconnectionwiththefollowing&》为网友屌丝舞分享!如侵犯到您的合法权益请联系我们删除