Anytime you change Oracle’s sqlnet.ora or tnsnames.ora files, does the system require a reboot? In my instance, I only have the Oracle client installed on the machine I’m referring to, but out of curiosity what would it mean for an Oracle server installation?
In general, no. A tnsnames.ora change shouldn’t require a reboot but some applications will read and parse the tnsnames.ora at startup to be able to present a drop-down list of servers to the user, for example, and will cache whatever was read when the application started up rather than re-reading the file. Depending on the situation, it might be easiest to reboot a Windows client rather than figuring out how to kill and restart any applications that might have the data cached.
A sqlnet.ora change might benefit from a reboot for the sake of consistency though it is not required. If you are doing something like enabling dead connection detection on a server by setting
sqlnet.expire_time, for example, it probably makes sense to reboot the server to make sure that the setting applies to all connections rather than just new connections– if you’re trying to debug why a particular dead connection is still hanging around, knowing that the server was restarted and that you’re not looking at some artifact of a connection that was opened prior to the setting being made would generally be helpful.
from my expierience wih sqlplus and some other tools:
tnsnames.orais read whenever a clients wants to open a connection
sqlnet.orais read whenever a client process starts up
at least for sqlplus you can verify this easily:
- start sqlplus and then add a new entry in tnsnames.ora. you can use it.
- start sqlplus and then configure tracing in sqlnet.ora, this should not work:
trace_directory_clint = c:trace trace_timestamp_client = on trace_level_client = 16 trace_unique_client = on
But of course other application could behave in another way
Of course the trace will not work if the trace directory if the trace_directory does not exist or is not writable. so you yshould also check that your tracing works if you coigure it before you start sqlplus