C#代碼訪問oracle資料庫

標籤：des   style   io   ar   os   sp   on   檔案   資料   

1 引用System.Data.OracleClient

         路徑：C:\Windows\Microsoft.NET\Framework\v2.0.50727\System.Data.OracleClient.dll

2 安裝Oracle client

1 官網下載

win32_11gR2_client.zip

注意版本及安裝步驟。

2設定檔 sqlnet.ora tnsnames.ora

路徑：本機為: D:\app\Administrator\product\11.2.0\client_1\network\admin\sqlnet.ora

注意oracle client的安裝路徑

內容

sqlnet.ora:

                   SQLNET.AUTHENTICATION_SERVICES= (NONE)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

tnsnames.ora:

SDEORCL =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = VASTSCENE_XP_01)(PORT = 1521))

    )

    (CONNECT_DATA =

           (SERVER = DEDICATED)

      (SERVICE_NAME = sdeorcl)

    )

  )

 

SDE =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = VASTSCENE_XP_01)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = orcl)

    )

  )

 

ORCL =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.20)(PORT = 1521))

    )

    (CONNECT_DATA =

      (SERVICE_NAME = orcl)

    )

)

3 安裝PLSQL Developer

 

若成功則能夠串連成功

 

伺服器開啟但無法成功串連（即能夠ping通，但無法訪問SDE）

可能原因:

伺服器沒有啟動SDE 以及ORACLE相關服務

解決方案

啟動oracle sde相關服務：

cmd->services.msc 將arcsde服務啟動，將oracle相關服務啟動

C#代碼訪問oracle資料庫