DB, Grid Infra version : 19c
OS : Oracle Linux 7.9
I have a 2-node RAC DB. I want to set SQLNET.EXPIRE_TIME = 15 (minutes)
As I understand, this change need to be done in the sqlnet.ora file located in the RDBMS_HOME/network/admin directory and NOT GRID Home (MOS Doc ID 562589.1)
So, I made the change in RDBMS_HOME/network/admin/sqlnet.ora and I did the reload of node listener (not SCAN listener) on both RAC nodes (like below)
As grid user,
$ lsnrctl reload LISTENER
I thought, this change will get reflected in node listener's listener.log. But, it did not get reflected in node listener log or DB alert log. i.e the below grep did not yield any results.
$ grep -i expire listener.log
$ grep -i expire alert_ORCL1.log
So, how do i verify if SQLNET.EXPIRE_TIME = 15 has taken effect ?