Instant Client连接数据库

 

plsql客户端连接oracle

1. 关闭数据库服务器防火墙

查看防火墙状态

firewall-cmd --state

停止firewall

systemctl stop firewalld.service

禁止firewall开机启动

systemctl disable firewalld.service

 

2. 下载客户端Instant

https://www.oracle.com/cn/database/technologies/winsoft/instant-client-download.html

这里下载32位的

 

 

 

3. 配置

环境变量添加

ORACLE_HOME=D:\soft\instantclient_12_2

TNS_ADMIN=D:\soft\instantclient_12_2

在D:\soft\instantclient_12_2目录下创建tnsnames.ora文件

 

 

添加连接数据库的信息

ora19c =

    (DESCRIPTION =

    (ADDRESS_LIST =

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

    )

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = ora19c)

    )

  )

 

4. 连接问题

 

解决办法：

[oracle@localhost admin]$ more sqlnet.ora

# sqlnet.ora Network Configuration File: /u01/app/oracle/product/19.3.0.0/db_1/network/admin/sqlnet.ora

# Generated by Oracle configuration tools.

 

 

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8

SQLNET.ALLOWED_LOGON_VERSION_SERVER=8