1. plsqldev客户端
下载地址:https://www.allroundautomations.com/bodyplsqldevreg.html(可下载汉化包)
第一次启动不填写数据库地址和密码,直接点击取消,
Help > Register填写注册信息;
PLSQL Developer 12 注册码
product code: 4vkjwhfeh3ufnqnmpr9brvcuyujrx3n3le
serial Number:226959
password: xs374ca
2. oracle客户端
下载instantclient-basic-win32-11.2.0.1.0(oracle官网下载地址:http://www.oracle.com/technetwork/topics/winsoft-085727.html )
3. 环境变量配置
客户端(windows下配置两个环境变量):
NLS_LANG=american_america.ZHS16GBK
TNS_ADMIN=E:\app\JimLee\product\11.2.0\client_1
PATH=E:\app\JimLee\product\11.2.0\client_1
注意,上面的地址要根据自己安装oracle客户端的路径来配置,默认在C:\app\$user\product\11.2.0\client_1 下,$user是你当前登录用户
4. 配置PLSQL首选项
(打开plsql,选“工具”——“首选项”):
E:\app\JimLee\product\11.2.0\client_1
E:\app\JimLee\product\11.2.0\client_1\oci.dll
5.创建一个目录存放instantclient
E:\app\JimLee\product\11.2.0\client_1
在该文件夹下创建文件:
tnsnames.ora 内容为
f4dp_bak =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = f4dbetl.fastfish.com.cn)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)