Blog @民工甲

1.从http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html中 Download Instant Client，Basic包下一个即可 2,在磁盘创建上目录，解压过去，比如解压到c:\oracleclient 3,创建目录c:\oracleclient\network\admin 4,创建文件tnsnames.ora 内容如下 oracledata = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = yourhostIp )(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = yourSID ) ) ) 5,在环境变量中添加nls_lang＝SIMPLIFIED CHINESE_CHINA.ZHS16GBK 6,设置pl/sql Developer的perference，主要填二个文本框 OCI Library:“c:\oracleclient\oci.dll”, Oracle_home: “c:\oracleclient\” 7,重启pl/sql developer, 输入用户名密码，以及tnsnames.ora设置的oracledata, Enjoy it.