用plsql链接oracle数据库

环境变量配置

　　1) 变量名：ORACLE_HOME 变量值：E:PLSQLDeveloperPLSQLinstantclient_11_2

　　2) 变量名：TNS_ADMIN 变量值：E:PLSQLDeveloperPLSQLinstantclient_11_2

　　3) 变量名：NLS_LANG 变量值：SIMPLIFIED CHINESE_CHINA.ZHS16GBK

plsq配置

　　D: oolsinstantclient_11_2oci.dl

　　D: oolsinstantclient_11_2oci.dll

tnsnames.ora 配置

名称 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ip )(PORT = 端口))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = jydb)
)
)