环境变量配置
1) 变量名:ORACLE_HOME 变量值:E:\PLSQLDeveloper\PLSQL\instantclient_11_2
2) 变量名:TNS_ADMIN 变量值:E:\PLSQLDeveloper\PLSQL\instantclient_11_2
3) 变量名:NLS_LANG 变量值:SIMPLIFIED CHINESE_CHINA.ZHS16GBK
plsq配置
D:\tools\instantclient_11_2\oci.dl
D:\tools\instantclient_11_2\oci.dll
tnsnames.ora 配置
名称 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ip )(PORT = 端口))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = jydb)
)
)