Database connection error error code=-70028 Create SOCKET connection failure. What to do

This article will explain in detail about database connection error reporting error code=-70028 Create SOCKET connection failure. What to do, the content of the article is of high quality, so the editor shares it for you as a reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.

There are usually several reasons for this.

1: most of this problem is that the default port has been modified. Please confirm the port_num port number in the dm.ini file. If the port number is modified, log in as follows:

D:\ dm7\ bin > disql SYSDBA/SYSDBA@127.0.0.1:8236

Server [127.0.0.1virtual 8236]: in normal open state

Login usage time: 66.208 (milliseconds)

Disql V7.6.0.142-Build (2019.03.12-103811) ENT

SQL >

2: check whether the database service is started.

[dmdba@localhost bin] $ps-e f | grep dms

3: for DM instances initialized with dminit for the first time, this problem will also occur when starting directly with the service.

Start by hand

[dmdba@localhost bin] $. / dmserver'/ dm/dmdbms/data/DAMENG/dm.ini'

4: check the status of the server and local firewall.

Red Hat 6 Series:

Service iptables status/start/stop/restart/save-status / enable / stop / restart Firewall / Save Firewall configuration

Chkconfig iptables off-permanently turn off the firewall

Chkconfig iptables on-permanently enable the firewall

Iptables-L-- View firewall status

Iptables-F-clear the firewall configuration

Red Hat 7 Series:

Systemctl stop firewalld-temporarily shuts down the firewall

Systemctl disable firewalld-permanently turn off the firewall since boot

Systemctl status firewalld-View firewall status

Firewall-cmd-- state-- View firewall status

Firewall-cmd-- add-port=5236/tcp-- temporarily add whitelist of port 5236

About database connection error error code=-70028 Create SOCKET connection failure. What to do to share here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.