PLSQL的安装

下载工具：

https://download.csdn.net/download/qq_38389941/12805630

配置用户变量

NLS_LANG=AMERICAN_AMERICA.UTF8

 

在目录D:\software\instantclient-basic-win32-11.2.0.1.0\instantclient-basic-win32-11.2.0.1.0\instantclient_11_2 下建一个文件为tnsnames.ora

# tnsnames.ora Network Configuration File: d:\app\ZHYE\product\11.1.0\db_1\network\admin\tnsnames.ora # Generated by Oracle configuration tools. ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = zhangye)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) ) # tnsnames.ora Network Configuration File: E:\app\Administrator\product\11.2.0\dbhome_1\network\admin\tnsnames.ora # Generated by Oracle configuration tools. LISTENER_ORCL = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) ORACLR_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) (CONNECT_DATA = (SID = CLRExtProc) (PRESENTATION = RO) ) ) ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) )

 

在 D:\PLSQL\client\stage\cvu 目录下，oracle.client_InstantClient.xml和cvu_prereq.xml中新增以下部分

<OPERATING_SYSTEM RELEASE="6.2"> <VERSION VALUE="3"/> <ARCHITECTURE VALUE="64-bit"/> <NAME VALUE="Windows 10"/> <ENV_VAR_LIST> <ENV_VAR NAME="PATH" MAX_LENGTH="5119" /> </ENV_VAR_LIST> </OPERATING_SYSTEM>

 

运行client目录下的setup.exe

选择安装路径

安装成功

 

运行

 

没有“连接为”一栏

点击“取消”，进入PLSQL Develper，在工具---首选项---连接

Oracle主目录名

D:\PLSQL\instantclient-basic-win32-11.2.0.1.0\instantclient_11_2

OCI库

d:\plsql\instantclient-basic-win32-11.2.0.1.0\instantclient_11_2\oci.dll

退出重新进入PLSQL Develper