PL/SQL Developer 装配

2012-07-26

PL/SQL Developer 安装1、在oracle网站下载Instant Clinet Package的软件包（basic），解压，目录随意，这里以c:

PL/SQL Developer 安装

1、在oracle网站下载Instant Clinet Package的软件包（basic），解压，目录随意，这里以c:\oracleclient为例

2、在c:\oracleclient里创建network/admin目录，增加tnsnames.ora文件，内容如下

ORCL =  (DESCRIPTION =    (ADDRESS = (PROTOCOL = TCP)(HOST = xx.xx.xx.xx)(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)    )  )

3、安装PLSQl developer 客户端

4、工具---》首选项---》链接

???? 设置oracle home（oracle主目录）和OCI 库位置

PL/SQL Developer 装配

5、重启qlsql developer

问题：报错说找不到msvcr71.dll

解决：从http://www.dll-files.com/dllindex/dll-files.shtml?msvcr71 下载该dll，放入c:\oracleclient里

热点排行

SQL Server

PL/SQL Developer 装配