PLSQL免安装oracle配置
1、解压instantclient-basic-win32-10.2.0.4.zip至磁盘的任何位置
2、在instantclient_10_2目录下新建NETWORK\ADMIN\tnsnames.ora并录入内容,内容模
板如下:
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.128.219.15)(PORT = 1521))
(CONNECT_DA TA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
参数解释:
别名:ORCL
服务器ip: 10.128.219.15
数据库实例:orcl
3、配置环境变量
ORACLE_HOME:至instantclient_10_2止(必须)
TNS_ADMIN: 至instantclient_10_2\NETWORK\ADMIN止(视情况,当前plsql无法自动解析tnsnames.ora时配置)
NLS_LANG: SIMPLIFIED CHINESE_CHINA.ZHS16GBK(解决中文乱码)