plsql远程连接oracle数据库

最新推荐文章于 2019-07-04 14:31:47 发布

shienquan

最新推荐文章于 2019-07-04 14:31:47 发布

阅读量550

点赞数

分类专栏： oracle

本文链接：https://blog.youkuaiyun.com/shienquan/article/details/52044706

版权

oracle 专栏收录该内容

6 篇文章

订阅专栏

1、客户机安装plsql

2、下载oracle32位客户端，将下载的文件解压后在D:\instantclient_11_232里面新建以下各文件和文件夹 \NETWORK\ADMIN\tnsnames.ora结果为D:\instantclient_11_232\NETWORK\ADMIN\tnsnames.ora，输入连接信息

# tnsnames.ora Network Configuration File: C:\app\Administrator\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORACLR_CONNECTION_DATA =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
    (CONNECT_DATA =
      (SID = CLRExtProc)
      (PRESENTATION = RO)
    )
)

SKDAT =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.201.128)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME =orac)
    )
)

201.128为远程数据库地址

3、在远程服务器上安装oracle数据库，dbca建库完成后新建用户
#sqlplus /nolog

SQL> conn / as sysdba;

SQL>create user username identified by password

SQL> grant dba to username;

SQL> conn username/password

SQL> select * from user_sys_privs;

4、在plsql中tools--选项 oracle Home配置为之前下载的客户端存放的目录 D:\instantclient_11_232，
OCI library 配置为oci存放的目录D:\instantclient_11_232\oci.dll

5、用plsql远程连接oracle数据库

6、环境变量配置：名称NLS_LANG值：SIMPLIFIED CHINESE_CHINA.ZHS16GBK（按实际情况来，确保客户端字符集和服务器端字符集保持一致）