ORA-12505: TNS: 监听程序当前无法识别连接描述符中所给出的 SID

来源:互联网 发布:淘宝宠物链 编辑:程序博客网 时间:2024/05/29 14:12

webconfig


<add name="HmFrameWorkEntities" connectionString="metadata=res://*/HMFW.csdl|res://*/HMFW.ssdl|res://*/HMFW.msl;provider=Oracle.DataAccess.Client;provider connection string=&quot;DATA SOURCE=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.44.153)(PORT=1521))(CONNECT_DATA=(SID=AA));PASSWORD=dbframework_gz369;USER ID=dbframework_gz&quot;" providerName="System.Data.EntityClient"/>
    <add name="StrConn" connectionString="DATA SOURCE=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.44.153(PORT=1521))(CONNECT_DATA=(SID=AA)));PASSWORD=dbframework_gz369;USER ID=dbframework_gz;" providerName="System.Data.SqlClient"/>



tnsnames.ora 配置:

BB=
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.44.151)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = AA
    )
  )



问题原因

BB是plsql登陆的别名,sid是     (SERVICE_NAME = AA)



webconfig  sid换成AA

阅读全文
0 0
原创粉丝点击