- 首先准备个软件,去oracle官网下载instantclient-basic-nt-12.1.0.2.0.zip,一定要下载32位的哟
地址:http://www.oracle.com/technetwork/topics/winsoft-085727.html
下载plsql,这个百度找一下,很好找的
在instantclient-basic-nt-12.1.0.2.0.zip解压出来,放在一个目录下,笔者就假设放在d盘吧,路径为:d:/instantclient
-
在instantclient目录下面增加network/admin/目录,并在该目录下面增加个tnsnames.ora文件,内容如下:
orcl =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ip)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = name)
)
)同时创建sqlnet.ora,文件内容如下
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT) 配置环境变量:TNS_ADMIN指向:d:/instantclient
- 打开PL/SQL,Tools–>Preferences,配置Connection的Oracle Home和OCI library,分别指向d:/instantclient和d:/isntantclient/oci.dll
- 重新启动plsql,登录