ORACLE远程连接不成功的问题

jacketble

我的ORACLE服务端是9.0i，客户端是9.2
TNSPING 可以通的得到的结果如下：
C:\Documents and Settings\Administrator>TNSPING 192.168.1.107

TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 30-3月 -2
009 11:22:55

Copyright (c) 1997 Oracle Corporation.  All rights reserved.

已使用的参数文件:

已使用 HOSTNAME 适配器来解析别名
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SID=*)(SERVICE_NAME=192.168.1.
107))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.107)(PORT=1521)))
OK（0毫秒）
以下是tnsnames.ora
####################################
# TNSNAMES.ORA Configuration File:E:\oracle\ora90\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle Enterprise Manager V2
# Date..........: Sat Mar 28 14:36:02 CST 2009
####################################

HUYANG_192.168.1.107 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.107)(PORT = 1521))
    )
    (CONNECT_DATA = (SID = HUYANG)(SERVER = DEDICATED))
  )

HUYANG =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.107)(PORT = 1521))
    )
    (CONNECT_DATA = (SID = HUYANG)(SERVICE_NAME = HUYANG))
  )

INST1_HTTP =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.107)(PORT = 1521))
    )
    (CONNECT_DATA = (SERVER = SHARED)(SERVICE_NAME = MODOSE)(PRESENTATION = http://HRService))
  )

# TNSNAMES.ORA Network Configuration File: E:\oracle\ora90\network\admin\tnsnames.ora

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA = (SID = PLSExtProc)(PRESENTATION = RO))
  )
以下是listener.ora
# LISTENER.ORA Network Configuration File: E:\oracle\ora90\network\admin\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.107)(PORT = 1521))
      )
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = E:\oracle\ora90)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = huyang.domain)
      (ORACLE_HOME = E:\oracle\ora90)
      (SID_NAME = huyang)
    )
  )

但是用oracle in orahome92连接的时候就不行，提示
Unable to connect
SQLState=08004
[Oracle][ODBC][Ora]ORA-12154:TNS:无法处理服务名

连接参数
HUYANG_192.168.1.107
HUYANG
HUYANG

本地连接可以的，远程不行，请各位大侠指教

managergh

tnsping 服务名 看看

jacketble

我把客户端的TNSNAMES.ORA内容改成和服务端一样就可以了
我也不太清楚为什么？

HUYANG_192.168.1.107 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.107)(PORT = 1521))
    )
    (CONNECT_DATA = (SID = HUYANG)(SERVER = DEDICATED))
  )

dingning239

不知所云