本机不安装oracle客户端如何使用plsql连接远程oracle数据库

    xiaoxiao2021-03-25  58

    首先准备个软件,去oracle官网下载instantclient-basic-nt-12.1.0.2.0.zip,一定要下载32位的哟

    地址:http://www.oracle.com/technetwork/topics/winsoft-085727.html

    下载plsql,这个百度找一下,很好找的

    在instantclient-basic-nt-12.1.0.2.0.zip解压出来,放在一个目录下,笔者就假设放在d盘吧,路径为:d:/instantclient

    在instantclient目录下面增加network/admin/目录,并在该目录下面增加个tnsnames.ora文件,内容如下:

    orcl = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = ip)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = name) ) )

    同时创建sqlnet.ora,文件内容如下

    SQLNET.AUTHENTICATION_SERVICES= (NTS) NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

    配置环境变量:TNS_ADMIN指向:d:/instantclient

    打开PL/SQL,Tools–>Preferences,配置Connection的Oracle Home和OCI library,分别指向d:/instantclient和d:/isntantclient/oci.dll重新启动plsql,登录
    转载请注明原文地址: https://ju.6miu.com/read-38778.html

    最新回复(0)