form连不上数据库（求助）

splnet.ora里的是
# SQLNET.ORA Network Configuration File: C:\orawf\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES)

tnsnames.ora里的是
# tnsnames.ora Network Configuration File: C:\orawf\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

HAND1201 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ebs12.hand-china.com)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = vis01)
    )
  )

HAND_VIS01 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ebs11.hand-china.com)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = vis01)
    )
  )


（我郁闷了，还没搞定）

k_reinhaid

你ping一下ebs12.hand-china.com看看

chirsdong

最初由 ansonrobert 发布
[B]splnet.ora里的是
# SQLNET.ORA Network Configuration File: C:\orawf\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES)

tnsnames.ora里的是
# tnsnames.ora Network Configuration File: C:\orawf\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

HAND1201 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ebs12.hand-china.com)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = vis01)
    )
  )

HAND_VIS01 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ebs11.hand-china.com)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = vis01)
    )
  )


（我郁闷了，还没搞定） [/B]

sqlnet.ora改成如下内容：

　[PHP]
  
#SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, HOSTNAME)

[/PHP]

另外，你这个路径好像是workflow的ＨＯＭＥ，而不是ＦＯＲＭ的，他们是各自用各自的net80的。。所以，你要去配制FORM HOME

[B] C:\orawf\network\admin\sqlnet.ora [/B]

chirsdong

？？楼主问题解决了吗？

chirsdong，FORMS和REPORTS连上了，就是你说的路径问题。哎，这个都都没发现，要学的东西还很多阿。
谢谢chirsdong！！！

chirsdong

最初由 ansonrobert 发布
[B]chirsdong，FORMS和REPORTS连上了，就是你说的路径问题。哎，这个都都没发现，要学的东西还很多阿。
谢谢chirsdong！！！ [/B]