QQ登录

只需一步,快速开始

 找回密码
 注册

QQ登录

只需一步,快速开始

查看: 562|回复: 1

求教!linux下Oracle访问出错

[复制链接]
发表于 2004-8-5 17:48:48 | 显示全部楼层 |阅读模式
用php网页连接oracle,可以在本机上连接,可是在其他机器上连时出现如下错误:
[unixODBC][Easysoft][Oracle]TNS: Could not resolve TARGETDB parameter as service name, SQL state 08001 in SQLConnect
我的tnsname.ora,listener.ora和sqlnet.ora文件内容如下:
tnsname.ora:
# TNSNAMES.ORA Network Configuration File: /opt/oracle/product/9.2.0/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

KEJIE =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 211.91.230.4(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = kejie)
    )
  )

EXTPROC_CONNECTION_DATA.LOCALDOMAIN =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )
**********************************
**********************************

listener.ora

# LISTENER.ORA Network Configuration File: /opt/oracle/product/9.2.0/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
      )
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = kejie)
      (ORACLE_HOME = /opt/oracle/product/9.2.0)
      (PROGRAM = extproc)
    )
  )
**************************************
*************************************
sqlnet.ora:
# SQLNET.ORA Network Configuration File: /opt/oracle/product/9.2.0/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.

# NAMES.DEFAULT_DOMAIN = LOCALDOMAIN

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

我糊涂了,请指教问题所在。。
急!!!!
 楼主| 发表于 2004-8-5 18:19:11 | 显示全部楼层
怎么没人解答吗?
都没遇到过这问题?斑竹在吗?帮帮手啊!
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

GMT+8, 2024-11-7 22:51 , Processed in 0.043982 second(s), 16 queries .

© 2021 Powered by Discuz! X3.5.

快速回复 返回顶部 返回列表