PL/SQL developer连接数据库写法

第一种直接连接数据库

192.168.0.210:1521/orcl

第二种在数据库连接文件修改

 

找到PLSQL里面的tnsnames.ora文件，然后用记事本打开

 

本地实例名 =

   (DESCRIPTION =

     (ADDRESS = (PROTOCOL = TCP)(HOST = 远程数据库IP地址)(PORT = 远程服务器端口号))

     (CONNECT_DATA =

       (SERVER = DEDICATED)

       (SERVICE_NAME = 远程数据库服务名)

     )

   )

一般位置在D:\oracle10\NETWORK\ADMIN

  举例：

       实际连接举例：

 

# tnsnames.ora Network Configuration File: D:\oracle10\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORCL =
   (DESCRIPTION =
       (ADDRESS = (PROTOCOL = TCP)(HOST = 3TU9M3WHD2KPUN8)(PORT = 1521))
       (CONNECT_DATA =
           (SERVER = DEDICATED)
           (SERVICE_NAME = orcl)
       )
   )

EXTPROC_CONNECTION_DATA =
   (DESCRIPTION =
       (ADDRESS_LIST =
           (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
       )
       (CONNECT_DATA =
           (SID = PLSExtProc)
           (PRESENTATION = RO)
       )
   )

ORCL35 =
   (DESCRIPTION =
       (ADDRESS_LIST =
           (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.35)(PORT = 1521))
       )
       (CONNECT_DATA =
           (SERVICE_NAME = orcl)
       )
   )

ORCL34 =
   (DESCRIPTION =
       (ADDRESS_LIST =
           (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.34)(PORT = 1521))
       )
       (CONNECT_DATA =
           (SERVICE_NAME = orcl)
       )
   )