1.安装plsql
2.下载\instantclient-basic-win32-11.1.0.7.0。3.在instantclient-basic-win32-11.1.0.7.0文件夹下创建NETWORK/ADMIN/文件夹,拷贝tns.names.文件。进行配置。以下是一个连接举例。
nctest =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 21.8.129.135)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = nctest)
)
)
4.在plsql客户端,tools--preferences。配置如图信息。
5.登录PL/SQL.