PLSQL连接oracle
1、下载免安装的客户端,解压到E:\soft\instantclient_11_2,解压后修改E:\soft\instantclient_11_2\network\admin目录下的tnsnames.ora文件
数据库名=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = IP地址)(PORT = 端口))
)
(CONNECT_DATA =
(SERVICE_NAME = servicem)
)
)
2、进入plsql,点击tools=>preferences
oracle home:E:\soft\instantclient_11_2
oci library:E:\soft\instantclient_11_2\oci.dll
3、从新进入plsql即可登录
----------------------------------------------------------------------------------------------------------------
记录下自己的安装过程,以便于后期自己再次安装方便
--------------------------------------------------------------------------------------------------------------