关于 dblink 检查你的tns有没有建立,文件tnsname.ora 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 在31.0.181.1机器上,使用#tnsping wxjj_kf看是否报错,我认是wxjj_kf配置不对。 谢谢大家!tnsname.ora 中有:31.0.182.1= (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 31.0.182.1)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = wxjj_kf) ) ) 写错了:(31.0.181.1= (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 31.0.181.1)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = wxjj_kf) ) ) tnsping 能ping同,无错误提示,显示Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=wxjj_2)(PORT=1521))OK (150 msec) oracle更新语句问题 ctl问题(50分相送) 请教两个sql语句的写法 高手指点,存储过程的问题 我在oracle中要用sql语句建一个表,但是有的列的数据要用前面的列数据运算获得,这个表怎么建? 请问怎样以加密形式显示表列? 查询数据变慢的原因? Oracle在NT环境下如何使用Pro*c进行开发?(不通过VC) P4安装完ORACLE9 出现的问题! ///////////////给我讲讲oracle里面的trigger是怎么回事,如果让我理解了我给200分////////// 急救调用java源出错,出100分 还有一个例子程序怎么在我的机器上运行错误?
#tnsping wxjj_kf
看是否报错,我认是wxjj_kf配置不对。
31.0.182.1=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 31.0.182.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = wxjj_kf)
)
)
31.0.181.1=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 31.0.181.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = wxjj_kf)
)
)
显示Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=wxjj_2)(PORT=1521))
OK (150 msec)