PLSQL连接oracle

1、下载免安装的客户端,解压到E:softinstantclient_11_2,解压后修改E:softinstantclient_11_2 etworkadmin目录下的tnsnames.ora文件

数据库名=
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = IP地址)(PORT = 端口))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = servicem)
    )
  )

2、进入plsql,点击tools=>preferences  

oracle home:E:softinstantclient_11_2

oci library:E:softinstantclient_11_2oci.dll

3、从新进入plsql即可登录

----------------------------------------------------------------------------------------------------------------

记录下自己的安装过程,以便于后期自己再次安装方便

--------------------------------------------------------------------------------------------------------------

原文地址:https://www.cnblogs.com/mojie/p/10546118.html