3,配置环境变量。 Path:增加instance client解压的目录。 TNS_ADMIN:instance client解压的目录。
NLS_LANG:AMERICAN_AMERICA.ZHS16GBK
4,在instance client的目录下,增加tnsnames.ora文件。内容如下(根据实际需要修改): # tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\tnsnames.ora # Generated by Oracle configuration tools.
LEMONC = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.222)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = lemonc) ) )
EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) )
5,配置完成之后,程序就可以使用instance client连接oracle服务端了。 6,plsql配置: ![](http://image99.360doc.com/DownloadImg/2016/08/1816/78231635_1)
7,然后,就没有然后了。。。enjoy。
|