1.安装Instant Client客户端和PLSQL Developer
下载资源链接地址:
PLSQL Developer(64位):https://pan.baidu.com/s/1kl1IA38zWMIg8WA16w6BXg 密码: 75j9
Instant Client客户端.exe文件:链接: https://pan.baidu.com/s/1rncVzW075yFj11SqFZlGQw 密码: ypq2
安装步骤:
参考主要以下链接:https://jingyan.baidu.com/article/546ae185d6969e1149f28ce6.html
1)环境变量的添加:
NLS_LANG = SIMPLIFIED CHINESE_CHINA.ZHS16GBK
TNS_ADMIN =D:\Oracle64\Instant Client(PLSQL 客户端的实际安装根目录)
Path: D:\Oracle64\Instant Client\bin
2)D:\Oracle64\Instant Client\network\admin下有一个连接配置文件tnsnames.ora 用来配置连接数据库信息,需要根据实际连接进行更改。
# tnsnames.ora Network Configuration File.
# Generated by Oracle InstantClient tools.
# For more information, please visit: http://www.oracle.com/technetwork/datab