discover problems

There are too many connections in the test environment. It is found that all the links are in the second rac node. No one calls or cares about the test environment

Manually test the specified instance:

C:\Users\caoyf>sqlplus system/xxxx@192.168.xxx.xxx:1521/server_taf

SQL*Plus: Release 11.2.0.4.0 Production on Thursday April 18 16:41:30 2019

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

ERROR:
ORA-12537: TNS: Connection closure

Handle

View / u01/app/11.2.0/grid/network/admin/listener.ora

The error is reported as follows:

<msg time='2019-04-18T16:51:32.666+08:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='node1'
 host_addr='192.168.60.11'>
 <txt>18-APR-2019 16:51:32 * (CONNECT_DATA=(SERVICE_NAME=server_taf)(CID=(PROGRAM=C:\python_pkg\instantclient_11_2\sqlplus.exe)(HOST=VD-IT-04)(USER=caoyf))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.20.219.63)(PORT=56219)) * establish * server_taf * 12518
 </txt>
</msg>
<msg time='2019-04-18T16:51:32.666+08:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='node1'
 host_addr='192.168.60.11'>
 <txt>TNS-12518: TNS:listener could not hand off client connection
 TNS-12547: TNS:lost contact
  TNS-12560: TNS:protocol adapter error
   TNS-00517: Lost contact
    Linux Error: 32: Broken pipe
 </txt>
</msg>

According to mos: 550859.1, no problem was found.

Find 1069517.1

The permission "-rwxr-x–x" is wrong as it's missing suid bit, oracle binary should have permission of 6751:

-rwsr-s–x 1 oracle asmadmin 184286251 Aug 9 16:25 /home/oracle/app/oracle/product/11.2/db/bin/oracle

When finding the problem of directory permission, the test can connect after modifying the directory permission
.

test

In order to further verify that it is about authority, change the authority to 777 again

[oracle@node1 bin]$ chmod 777 oracle

Retest:

SQL*Plus: Release 11.2.0.4.0 Production on Thursday April 18 17:32:42 2019

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

ERROR:
ORA-12537: TNS: Connection closure

I found that I couldn't connect. The test is successful after changing back again. Record and study the functions of each document later.