当前位置:操作系统 > Unix/Linux >>

数据库范式那些事

 

PL/SQL Developer

 

远程连接Oracle数据库

 

网上搜了很多方法,这个可行!

 

1、    配置服务器tnsnames.ora文件,如果本机上没有安装oracle,可以从安装了oracle的机上拷贝一个(tnsnames.ora文件)放在指定目录下,因为我已安装oracle,所以直接配置该文件。

 

# tnsnames.ora Network Configuration File: D:\Oracle11g\product\11.2.0\dbhome_1\network\admin\tnsnames.ora

 

# Generated by Oracle configuration tools.

 

     

 

LISTENER_ORCL =

 

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

 

 

 

ORACLR_CONNECTION_DATA =

 

  (DESCRIPTION =

 

    (ADDRESS_LIST =

 

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

 

    )

 

    (CONNECT_DATA =

 

      (SID = CLRExtProc)

 

      (PRESENTATION = RO)

 

    )

 

  )

 

 

 

ORCL =

 

  (DESCRIPTION =

 

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

 

    (CONNECT_DATA =

 

      (SERVER = DEDICATED)

 

      (SERVICE_NAME = orcl)

 

    )

 

  )

 

lidashuang的博客

CopyRight © 2022 站长资源库 编程知识问答 zzzyk.com All Rights Reserved
部分文章来自网络,