|
1. 下載oracle的客戶端程序包（30M）
只需要在 Oracle 下載一個叫 Instant Client Package 的軟件就可以了，這個軟件不需要安裝，只要解壓就可以用了，很方便，就算重裝了系統(tǒng)還是可以用的。 下載地址： http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html 解壓到一個目錄中即可，例如c:\oracleclient 2. 配置操作系統(tǒng)環(huán)境變量 NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK TNS_ADMIN=C:\oracleclient 3. 配置連接Oracle的配置。tnsnames.ora文件到目錄C:\oracleclient?？梢詮膐racle服務(wù)器拷貝一個過來。 內(nèi)容類似： # tnsnames.ora Network Configuration File: E:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools. ORCLProduct =
(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = prmpatm1.asiapacific.hpqcorp.net)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) ) ORCL122 =
(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 16.157.133.122)(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) ) ) 4. 安裝PLSQL Developer 5. 配置PLSQL Developer（第一次可以不用登錄直接進到PLSQL Developer） Tools --> Preferences--> Connections, Oracle Home內(nèi)容為 C:\oracleclient OCI library內(nèi)容為C:\oracleclient\oci.dll 重新啟動PLSQLDeveloper 完畢 |
|
|
