oracle 11g mysql_Oracle 11g与MySQL的异构连接

7、tnsping hsd

$ tnsping hsd

TNS Ping Utility for HPUX: Version 11.1.0.6.0 - Production on 17-NOV-2009 16:43:46

Copyright (c) 1997, 2007, Oracle.  All rights reserved.

Used parameter files:

/app/oracle/app/oracle/product/11.1.0/db_2/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.1)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = dp)) (HS = OK))

OK (0 msec)

8、创建DBLINK可以成功。

create public database link hsdlink connect to "root" identified by "123456" using 'hsd';

9、查询出错：

SQL> select * from dp.dp_path@hsdlink;

select * from dp.dp_path@hsdlink

*

ERROR at line 1:

ORA-28500: connection from ORACLE to a non-Oracle system returned this message:

ORA-02063: preceding line from HSDLINK

现在找不到错误的原因，还请各位大侠帮忙。先行谢过！！！

附加：oracle的环境变量：

export ORACLE_BASE=/app/oracle/app/oracle

export ORACLE_HOME=$ORACLE_BASE/product/11.1.0/db_2

export ORA_CRS_HOME=$ORACLE_HOME/crs

export ORACLE_SID=ora11ghs

export ORACLE_PATH=$ORACLE_BASE/common/oracle/sql:$ORACLE_HOME/rdbms/admin

export PATH=$PATH:$ORACLE_HOME/bin:/usr/local/bin:/app/unixodbc/bin:$HOME/bin:.

export TNS_ADMIN=$ORACLE_HOME/network/admin

export ORA_NLS10=$ORACLE_HOME/nls/data

export SHLIB_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib:/app/lib:/app/unixodbc/lib

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib:/usr/lib:/usr/local/lib:$ORACLE_HOME/oracm/lib:/app/unixodbc/lib:/app/lib

export CLASSPATH=$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/jlib:$ORACLE_HOME/network/jlib:$ORACLE_HOME/JRE

export THREADS_FLAG=native

export TEMP=/tmp

export TMPDIR=/tmp

export NLS_LANG=american_america.zhs16cgb231280

export ODBCINI=/app/configinfo/odbc.ini这个问题，没有哪位高手遇到过吗？

--------------------------------------------------------------------------------

22/2<12