Error:
08-JUL-2019 10:09:57 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=badb1-t7-2)(USER=grid))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=202375680)) * status * 0
Incoming connection from 10.212.1.134 rejected
08-JUL-2019 10:10:12 * 12546
TNS-12546: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00516: Permission denied
Incoming connection from xx.xx.xx.xx rejected>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>Incoming connection from xx.xx.xx.xx rejected
Reason:
The issue is due to improper setting of tcp.invited_nodes in sqlnet.ora
The scan ip is missing tcp.invited_nodes.
tcp.invited_nodes = (
Solution:
-bash-4.1$ cd /d01/app/12.1.0/grid/network/admin/
-bash-4.1$ cat sqlnet.ora
TCP.VALIDNODE_CHECKING = YES
TCP.INVITED_NODES = (10.11.1.134,10.11.1.126,10.11.208.167,10.11.208.115,10.11.208.70)
#TCP.EXCLUDED_NODES = (10.11.208.115,10.11.208.78)
-bash-4.1$
-bash-4.1$ vim sqlnet.ora
TCP.VALIDNODE_CHECKING = YES
#TCP.INVITED_NODES = (10.11.1.134,10.11.1.126,10.11.208.167,10.11.208.115,10.11.208.70)
#TCP.EXCLUDED_NODES = (10.11.208.115,10.11.208.78)
-bash-4.1$
