PL SQL Developer14与Navicat Premium连接Oracle方法

一、Navicat Premium连接Oracle方法

二、PL SQL Developer14连接Oracle方法

1、安装PL SQL Developer 14中文破解版

2、设置中文界面

3、下载Oracle Clinet并解压

下载地址：https://www.oracle.com/database/technologies/instant-client/downloads.html

4、配置Oracle的主目录与OCI连接库

5、登录Oracle(登录之前先保存以上配置，重新启动PLSQL)

1.  临时连接可以不用配置tns文件在plsql登录窗口输入：//IP:PORT/SID

2. 配置连接文件tnsnames.ora(在Oracle Clinet解压目录下新建目录network\admin，再添加 tnsnames.ora文件)

TOPPTH =											    
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.3.156)(PORT = 1521))     
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = toppth)		
   )
  )

TOPTST =																
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.3.156)(PORT = 1521))     
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = toptst)			    
   )
  )