ORA-12505错误

大家好,我是学IT的一名学员,今天遇到了一个问题,就是在用myeclipse连接oracle时,报了500的错,但又是ORA-12505的错误,报错如下:

ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
localhost:1521:orcl.我该怎么解决呢???请帮忙,这样我就不能写项目了。

oracle的ORA-12505错误

04-16

今天弄了一上午没弄出来打开sqldeveloper后出现一个错误rn[code=Java]Listener refused the connection with the following error:rnORA-12505, TNS:listener does not currently know of SID given in connect descriptorrnThe Connection descriptor used by the client was:rnlocalhost:1521:orcl[/code]rnrn后来在网上找了很多说把listener.ora改,我看他那配置不一样,试了,也不管用各位大吓教教我rnlistener.orarn[code=SQL]rn# listener.ora Network Configuration File: C:\app\wang\product\11.1.0\db_1\network\admin\listener.orarn# Generated by Oracle configuration tools.rnrnLISTENER =rn (DESCRIPTION_LIST =rn (DESCRIPTION =rn (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))rn (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))rn )rn )rnrnrn[/code]rntnsnames.orarn[code=SQL]rn# tnsnames.ora Network Configuration File: C:\app\wang\product\11.1.0\db_1\network\admin\tnsnames.orarn# Generated by Oracle configuration tools.rnrnORCL =rn (DESCRIPTION =rn (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.102)(PORT = 1521))rn (CONNECT_DATA =rn (SERVER = DEDICATED)rn (SERVICE_NAME = orcl)rn )rn )rnrn[/code]rnsqlnet.orarn[code=SQL]# sqlnet.ora Network Configuration File: C:\app\wang\product\11.1.0\db_1\network\admin\sqlnet.orarn# Generated by Oracle configuration tools.rnrn# This file is actually generated by netca. But if customers choose to rn# install "Software Only", this file wont exist and without the native rn# authentication, they will not be able to connect to the database on NT.rnrnSQLNET.AUTHENTICATION_SERVICES= (NTS)rnrnNAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)[/code]

没有更多推荐了,返回首页

私密
私密原因:
请选择设置私密原因
  • 广告
  • 抄袭
  • 版权
  • 政治
  • 色情
  • 无意义
  • 其他
其他原因:
120
出错啦
系统繁忙,请稍后再试

关闭