1.网络通信异常
排查方法:
1). 确定连接的ip地址、数据库端口号、数据库用户名、用户密码输入正确无误
2).确定网络正常
ping 192.168.11.1
3).确定数据库端口正常
#语法 telnet ip port_num
telnet 192.168.11.1 5236
4).确定防火墙关闭或者数据库已开放数据库使用的端口
查看防火墙状态
systenctl status firewalld.service
查看服务器开放的端口
待补充
5).确定是否是句柄资源限制导致的连接无法创建
确定/etc/security/limits.conf中open files是否设置为65536
[root@localhost security]# ulimit -a
core file size (blocks, -c) 0
data seg size (kbytes, -d) unlimited
scheduling priority (-e) 0
file size (blocks, -f) unlimited
pending signals (-i) 30518
max locked memory (kbytes, -l) 64
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
real-time priority (-r) 0
stack size (kbytes, -s) 10240
cpu time (seconds, -t) unlimited
max user processes (-u) 1024
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
[root@localhost security]# ulimit -n 10240
[root@localhost security]# ulimit -a
core file size (blocks, -c) 0
data seg size (kbytes, -d) unlimited
scheduling priority (-e) 0
file size (blocks, -f) unlimited
pending signals (-i) 30518
max locked memory (kbytes, -l) 64
max memory size (kbytes, -m) unlimited
open files (-n) 10240
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
real-time priority (-r) 0
stack size (kbytes, -s) 10240
cpu time (seconds, -t) unlimited
max user processes (-u) 1024
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
6).确定内存资源限制情况