Oracle- PL/SQL DEV的远程配置

首先装好Oracle企业版或者客户端精简版。之后要修改你的的tnsnames.ora文件，来增加数据库。

我的ORACLE实例是ORACLE1，放在D:\oracle\ 目录下。我的IP地址是 192.168.1.102

 

修改如下：

添加：

DEMO =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST =  192.168.1.102)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = ORACLE1)

    )

  )

 

这样就把一个远程的数据库添加到本机的客户端中了。然后打开PL/SQL DEV 软件。在工具->首选项中修改：

Oracle主目录名：D:\oracle\

OCI库：D:\oracle\ora92\bin\oci.dll

 

这样设置之后，就可以通过PL/SQL DEV来访问远程的Oracle数据库了。

 

 

附上最原始的tnsnames.ora文件

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36

# TNSNAMES.ORA Network Configuration File: D:\oracle\ora92\network\admin\tnsnames.ora # Generated by Oracle configuration tools.   ORACLE1 =   (DESCRIPTION =     (ADDRESS_LIST =       (ADDRESS = (PROTOCOL = TCP)(HOST = VKP1W8IQZW4QTSX)(PORT = 1521))     )     (CONNECT_DATA =       (SERVER = DEDICATED)       (SERVICE_NAME = Oracle1)     )   )   INST1_HTTP =   (DESCRIPTION =     (ADDRESS_LIST =       (ADDRESS = (PROTOCOL = TCP)(HOST = VKP1W8IQZW4QTSX)(PORT = 1521))     )     (CONNECT_DATA =       (SERVER = SHARED)       (SERVICE_NAME = MODOSE)       (PRESENTATION = http://HRService)     )   )   EXTPROC_CONNECTION_DATA =   (DESCRIPTION =     (ADDRESS_LIST =       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))     )     (CONNECT_DATA =       (SID = PLSExtProc)       (PRESENTATION = RO)     )   )