Plsql Developer 关于oracle 的配置
1、所需安装包:oracle 客户端(免安装) 、plsql Developer 安装包
PS: instantclient_11_2 附件中有,可直接下载
2、系统环境变量配置如下值:
path目录后面加: D:\workFiles\PLSQL\instantclient_11_2
ORACLE_HOME = D:\workFiles\PLSQL\instantclient_11_2
TNS_ADMIN = D:\workFiles\PLSQL\instantclient_11_2
NLS_LANG SIMPLIFIED CHINESE_CHINA.ZHS16GBK ----(设置语言)
修改 D:\workFiles\PLSQL\instantclient_11_2\tnsnames.ora 文件:
ORA12 =(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = sid)
)
)
3.启动plsql,因为还没有配置好,所以你就cancel ,
进入到plsql,在上方的选项栏中 tools-->connection 设置 oracle home 路径 和 oci library 路径
然后apply,重启plsql,就会发现,database 就会显示 cs_de_o, 然后输入你的用户,密码,就可以登录了