oracle 10G在windows 7中與Oracle database 10G Enterprise Edition形成連接

我正在嘗試將 Oracle Forms 10g 版本 (9.0.4) 連接到 Oracle 10G 企業版。

起初我嘗試連接到數據庫而沒有在 Oracle Net Configuration Assistant 中設置“本地網路服務名稱配置”。我得到了錯誤

在 Oracle Net Configuration Assistant 中設置“本地網路服務名稱配置”後，我仍然收到錯誤消息

誰能解釋我如何使用表單連接到數據庫，因為我一直在努力連接數據庫？

# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORCL =
 (DESCRIPTION =
   (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
   (CONNECT_DATA =
     (SERVER = DEDICATED)
     (SERVICE_NAME = orcl)
   )
 )

EXTPROC_CONNECTION_DATA =
 (DESCRIPTION =
   (ADDRESS_LIST =
     (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
   )
   (CONNECT_DATA =
     (SID = PLSExtProc)
     (PRESENTATION = RO)
   )
 )

以下是 listener.ora 和 tnsnames.ora 內容

# listener.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
 (SID_LIST =
   (SID_DESC =
     (SID_NAME = PLSExtProc)
     (ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
     (PROGRAM = extproc)
   )
 )

LISTENER =
 (DESCRIPTION_LIST =
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
     (ADDRESS = (PROTOCOL = TCP)(HOST = RahulSingh-PC)(PORT = 1521))
   )
 )

該消息表明您與作業系統（即 Windows 7）使用的表單版本不兼容。

您需要安裝帶有更新檔集 3 的 Oracle Forms 版本 10.1.2.0.2才能更正此問題。

否則，您還可以安裝經過 Windows 7 認證的Oracle Forms 11g R2

將此添加到 tnsnames.ora 或

hr = (SID_LIST = (SID_DESC = (SID_NAME = hr) (ORACLE_HOME = ) (PROGRAM = extproc) )

引用自：https://dba.stackexchange.com/questions/19408