oracle创造与mysql的dblink 失败

oracle创建与mysql的dblink 失败
两种方式：第一，①安装mysql odbc驱动，配置mysql数据源。
                                ②配置listener.ora和tnsnames.ora,以及%oracle home%/hs/admin下增加对应的init<SID>.ora
                                       在listener.ora中添加如下代码
                                           (SID_DESC =
                                            (GLOBAL_DBNAME =psms)    
                                            (SID_NAME = psms)
                                              (ORACLE_HOME = E:\oracle\product\10.2.0\db_1)
                                             (PROGRAM = hsodbc)
                                            )
                                         在tnsnames.ora中添加如下代码：
                                       psms=
                                       (DESCRIPTION =
                                          (ADDRESS_LIST =
                                       (ADDRESS = (PROTOCOL = TCP)(HOST = IP地址)(PORT = 端口))
                                         )
                                        (CONNECT_DATA =
                                       (SERVICE_NAME = psms)
                                          (SID=psms)
                                           )
                                         )
                                       创建initpsms.ora,内容如下：
                                      HS_FDS_CONNECT_INFO = psms
                                      HS_FDS_TRACE_LEVEL = OFF