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?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
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
from my expierience wih sqlplus and some other tools:
at least for sqlplus you can verify this easily:
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