Database Software

Hi,

With Oracle Restart the Listener runs from the Oracle-Home of the Grid Infrastructure. Nevertheless it seems that the entries from sqlnet.ora are not taken from this Oracle-Home, but from the Oracle-Home of the database (if the file exists).

“lsnrctl status” shows that the listener.ora is taken from the Oracle-Home of the GI. One would expect that the sqlnet.ora comes from the same directory.

Strace shows that the sqlnet.ora which is placed in the Home of the Grid Infrastructure will be read by the listener. Nevertheless the entry SQLNET.EXPIRE_TIME which was defined in this location didn't come into effect. Strace also shows that a sqlnet.ora placed in the database-home will be read as well (if the file exists). Setting the SQLNET.EXPIRE_TIME in the database-home does actually work.

Searching the Oracle Documentation for "grid infrastructure" and sqlnet.ora will return only 2 hits (one of them is a broken link):

“ In an Oracle Grid Infrastructure installation, the sqlnet.ora file is located in the following directory by default: Grid_home\network\admin
In the %ORACLE_HOME%\network\admin directory, in addition to a default sqlnet.ora file, you also can find a sample sqlnet.ora file in the subdirectory sample.
“
[http://download.oracle.com/docs/cd/E11882_01/install.112/e18069/undrstnd.htm#RIWIN611 (“Beta Draft: 2011-05-20”???)]

This suggests that the sqlnet.ora is taken from the Oracle-Home of the GI.

I have never seen a documentation which clearly states at which time the entries from sqlnet.ora will be read (say once by the listener or later by each shadow process). So the behavior seen may be intended. Nevertheless it is not what one would expect by reading the documentation.

Any suggestions for this behavior?

Thanks & regards
Konrad