Sunday 7 July 2019

TNS-12546: TNS:permission denied TNS-00516: Permission denied Incoming connection from ip address rejected


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$ 

No comments:

Post a Comment