PLSQL的安装

最新推荐文章于 2025-04-22 00:11:57 发布

qq_38389941

最新推荐文章于 2025-04-22 00:11:57 发布

阅读量300

点赞数

分类专栏： Oracle PLSQL

本文链接：https://blog.youkuaiyun.com/qq_38389941/article/details/108383156

版权

Oracle 同时被 2 个专栏收录

1 篇文章

订阅专栏

PLSQL

1 篇文章

订阅专栏

本文详细介绍了如何在Windows环境下配置PLSQL Developer与Oracle数据库的连接，包括下载和安装必要的Oracle客户端组件，设置环境变量，修改配置文件，以及在PLSQL Developer中指定正确的Oracle主目录名和OCI库路径。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

下载工具：

https://download.youkuaiyun.com/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