ORA-12170: TNS:Connect timeout occurred错误怎么解决?谢谢!
我用的是sqlplus输入:
SQL> connect Test/Test@openview;
ERROR:
ORA-12170: TNS:Connect timeout occurred
但如果直接
SQL> connect Test/Test;
Connected.
由于项目接口要@SID,问下第一种方式为什么不能连?如何改?谢谢!
------解决方案--------------------connect Test/Test@ov_net;这样连接
------解决方案--------------------
1、创建一个openview服务就可以了
openview =
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS = (PROTOCOL = IPC)(KEY =openview))
(ADDRESS =
(COMMUNITY=OPENVIEW_COMMUNITY)
(PROTOCOL=TCP)
(HOST=16.173.243.88)
(PORT=20199)
)
)
(CONNECT_DATA=
(SID=openview)
)
)
然后再执行tnsping openview;