数据库客户端的问题

显示全部楼层 · 2012-7-12 18:47:29

今天烦了一天了！
我的oracle是8.0.5的，安装在一台unix上（10.95.128.18）
现在我在局城网内（10.95.128.189）安装了那个10.2.0版本的简洁客户端，服务器的tnsname.ora是：
extproc_connection_data =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = ora8))
(CONNECT_DATA = (SID = extproc))
)
ora8 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL= TCP)(Host= zx2)(Port= 1521))
(CONNECT_DATA = (SID = ora8))
)
ora82 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL =TCP)(Host = zx3)(Port=1521))
(CONNECT_DATA = (SID = ora82))
)
oracle7 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL =TCP)(Host = ghzx)(Port=1526))
(CONNECT_DATA = (SID = oracle7))
)
ufs =
(DESCRIPTION =
(ADDRESS = (PROTOCOL =TCP)(Host = ljzh)(Port=1526))
(CONNECT_DATA = (SID = ufs))
)
ora8_BEQ =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = BEQ)(PROGRAM = /home/oracle/app/oracle/product/8.0.5)

(argv0 = oracleora8)

(args = '(DESCRIPTION = (LOCAL=YES)(ADDRESS=(PROTOCOL=BEQ)))')

(envs = 'ORACLE_HOME=/home/oracle/app/oracle/product/8.0.5,ORACLE_SID=ora8')
)
)
dbs.fxz.dy.sc.cpn =
(DESCRIPTION =
(ADDRESS = (PROTOCOL =TCP)(Host = dbs.fxz.dy.sc.cpn)(Port = 1526))
(CONNECT_DATA = (SID = oracle7))
)
zxbkfx =
(DESCRIPTION =
(ADDRESS = (PROTOCOL= TCP)(Host= dbs1.zx.sf.dy.sc.cpn)(Port= 1521))
(CONNECT_DATA = (SID = oracle7))
)

newbk =
(DESCRIPTION =
(ADDRESS = (PROTOCOL =TCP)(Host = newbk )(Port = 1521))
(CONNECT_DATA = (SID = oracle7))
)

我已经拷贝过来了，但是连接的时候却报
ERROR:
ORA-12560: TNS: 协议适配器错误
这个错误，我查了很多资料了，因为以前没有接触过oracle，所以今天忙了一天，也没有弄好，只有请求帮助了，谢谢！

千问 · 2012-7-12 18:47:29

两版本相差太远，估计不兼容。