Listener not using SQLNET.EXPIRE_TIME value
Hello,
I have set SQLNET.EXPIRE_TIME to 2 minutes in the sqlnet.ora of the database server:
SQLNET.EXPIRE_TIME = 2;
Despite of that, the listener processes continue using the default value indicated by the kernel parameter tcp_keepalive_interval which is 2 hours (7200000 msecs) instead of the SQLNET.EXPIRE_TIME value.
/home/root# ndd -get /dev/tcp tcp_keepalive_interval
7200000
I have checked out that other parameters of the sqlnet.ora file are properly read and applied for the database. I am not intersted in changing the kernel parameter to 2 minutes so other applications could be affected apart from Oracle database. Is there any way to solve this?