oracle 10g 用戶端安裝____oracle

1. 從http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html
下載幾個壓縮包,解壓到一個目錄, d:/oracleclient

instantclient-basic-win32-10.1.0.2.zip : 這是最核心的包
instantclient-jdbc-win32-10.1.0.2.zip: 包含JDBC Driver的包
instantclient-sqlplus-win32-10.1.0.2.zip: 最簡單的SQLPLUS包
2.配置tnsnames.ora 如下格式（必須在主目錄如D:/oracleclient下network/admin下）
oracledata =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.58)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = oracledata)
    )
  )
3.下載並安裝PL.SQL.Developer配置應用
  配置tools->preferences->connection
  Oracle Home=D:/oracleclient
  OCI library=D:/oracleclient/oci.dll
4.再次開啟plsql則會在database中有oracledata 選項輸入使用者名稱密碼就可以登陸

                                                                                                                       oseica