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即可登录

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

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

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

转载于:https://www.cnblogs.com/mojie/p/10546118.html