PL/SQL Develop的连接登陆

最新推荐文章于 2024-03-25 14:48:00 发布

wangpeng1201

最新推荐文章于 2024-03-25 14:48:00 发布

阅读量345

点赞数

CC 4.0 BY-SA版权

文章标签： oracle

本文链接：https://blog.youkuaiyun.com/wangpeng1201/article/details/103079740

本文详细介绍如何通过配置 Oracle 的 tnsnames.ora 文件来实现 PL/SQL Developer 的数据库连接。文章提供了具体的 tnsnames.ora 文件配置示例，并指导用户如何在 PL/SQL Developer 中选择正确的数据库进行登录。

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

PL/SQL Develop的连接登陆

https://www.cnblogs.com/nsw2018/p/9837611.html

Oracle安装之后，找到tnsnames.ora文件，添加tns配置

以下为tnsnames.ora文件的内容：

# # tnsnames.ora Network Configuration File: D:\oracle\product\10.2.0\db_2\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = zengzhouwu)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

test0233 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.33)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = fangcangdb)
)
)

test39 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.39)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = fangcangdb)
)
)

uat40 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.40)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = fangcangdb)
)
)

shengchan133 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 193.167.10.133)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME =fangcangdb)
)
)

shengchan137 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 193.167.10.160)(PORT = 1521))
)
(CONNECT_DATA =
(SID =fangcangdb)
)
)

shengchan139 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 193.167.10.139)(PORT = 1521))
)
(CONNECT_DATA =
(SID =fangcangdb)
)
)

logdb =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 193.167.10.161)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME =fangcangdb)
)
)
asda =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.44)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = fangcangdb)
)
)