17,377
社区成员
发帖
与我相关
我的任务
分享oracle的odbc连接问题
错误为12222和12514是指什么?
(出现问题是我的机子非法关机,自动修复后就连不上了,oracle服务器不是本机.uninstall oracle后重装也没用)
(出现问题是我的机子非法关机,自动修复后就连不上了,oracle服务器不是本机.uninstall oracle后重装也没用)
...全文
请发表友善的回复…
发表回复
jiezhi 2002-12-10
- 打赏
- 举报
查资料：www.orafaq.com使用ora-12514来查
jameschan 2002-12-10
- 打赏
- 举报
原因是ole db提供者丢失, 我再另外想办法.谢谢大家
adidasprince 2002-12-10
- 打赏
- 举报
用net assistant重新建一个，或者直接在TNSNAMES.ORA, LISTENER.ORA or TNSNET.ORA上修改：）
jlandzpa 2002-12-10
- 打赏
- 举报
ORA-12222 TNS:no such protocol adapter
Cause The protocol adapter requested (by way of the "(PROTOCOL=..)" keyword-value pair in a TNS address) is unknown. If the supplied address is typographically correct then the protocol adaptor is not installed.
Action Install the protocol adapter or correct typographically error, as appropriate. Note: if the supplied address was derived from resolving the service name, check the address in the appropriate file (TNSNAMES.ORA, LISTENER.ORA or TNSNET.ORA).
ORA-12514: tns:LISTENER COULD NOT RESOLVE service_name GIVEN IN CONNECT DESCRIPTOR
Cause The protocol adapter requested (by way of the "(PROTOCOL=..)" keyword-value pair in a TNS address) is unknown. If the supplied address is typographically correct then the protocol adaptor is not installed.
Action Install the protocol adapter or correct typographically error, as appropriate. Note: if the supplied address was derived from resolving the service name, check the address in the appropriate file (TNSNAMES.ORA, LISTENER.ORA or TNSNET.ORA).
ORA-12514: tns:LISTENER COULD NOT RESOLVE service_name GIVEN IN CONNECT DESCRIPTOR
