TNS-12505 TNS:listener could not resolve SID given in connect descriptor Cause: The SID in CONNECT_DATA was not found in the listener's tables. Action: Check to make sure that the SID specified is correct. The SIDs that are currently registered with the listener can be obtained by typing "LSNRCTL SERVICES listener_name". These SIDs correspond to SID_NAMEs in TNSNAMES.ORA, or DB_NAMES in the INIT.ORA file. 检查一下你的TNSNAMES.ORA
Cause: The SID in CONNECT_DATA was not found in the listener's tables.
Action: Check to make sure that the SID specified is correct. The SIDs that are
currently registered with the listener can be obtained by typing "LSNRCTL
SERVICES listener_name". These SIDs correspond to SID_NAMEs in
TNSNAMES.ORA, or DB_NAMES in the INIT.ORA file.
检查一下你的TNSNAMES.ORA
问题是别的同事用ADO连接都很正常
因为安装备份系统,别人将我的 host 文件改掉了!
在我的主机名称后面增加了域名!
然后就怎么都连接不上去了!
看看你的 conn string 以及
检查 tnsnames.ora 文件,运行 tnsping 命令!
tnsping SID (在安装了ORACLE客户端的机器上运行!)!
好象是你的linux有问题啊
你把192.0.1.55改成127.0.0.1试试