plsql连接oracle方法

最新推荐文章于 2025-08-04 23:14:52 发布

Vincent8080

最新推荐文章于 2025-08-04 23:14:52 发布

阅读量91

点赞数

CC 4.0 BY-SA版权

文章标签：数据库网络

原文链接：https://my.oschina.net/sunyh/blog/125015

本文详细介绍了如何安装PLSQLDeveloper及Oracle客户端，并配置必要的环境变量与sqlnet.ora、tnsnames.ora文件，确保能成功连接到不同的Oracle数据库实例。

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

为什么80%的码农都做不了架构师？>>>

1：PLSQL Developer安装

2：解压instantclient

3：设置instantclient 相关的环境变量

4：新增sqlnet.ora文件

内容为

# sqlnet.ora Network Configuration File: E:\app\limn\product\11.1.0\db_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES= (NONE)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

5：新增tnsnames.ora文件

内容为

# tnsnames.ora Network Configuration File: E:\app\limn\product\11.1.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

1.1.7.88 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 1.1.7.88)(PORT = 1521))
(CONNECT_DATA =
(SERVER = TEST)
(SERVICE_NAME = TEST)
)
)
1.1.2.26 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 1.1.2.26)(PORT = 1521))
(CONNECT_DATA =
(SERVER = ORCL11G)
(SERVICE_NAME = ORCL11G)
)
)
1.1.2.28 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 1.1.2.28)(PORT = 1521))
(CONNECT_DATA =
(SERVER = orcl)
(SERVICE_NAME = orcl)
)
)