plsql连接oracle不安装oracle客户端
1.下载Oracle Client Package . http://www.oracle.com/technetwork/topics/winsoft-085727.html下载 Instant Client Package – Basic包( 标注:All files required to run OCI, OCCI, and JDBC-OCI applications)这里下载的是Version 11.1.0.7 2.本地保存Oracle Client Package: 创建文件夹,比如oracleclient,将下载的文件加压缩到此文件夹里.(笔者目录: D:\oracleclient\instantclient102) 3.在当前目录下,新建立两个文件,sqlnet.ora和tnsnames.ora然后再手动配置sqlnet.ora和tnsnames.ora 比如这里是: sqlnet.ora文件内容: SQLNET.AUTHENTICATIONSERVICES= (NTS) NAMES.DIRECTORYPATH= (TNSNAMES, EZCONNECT) tnsnam….