Updating tnsnames ora
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? A change shouldn't require a reboot but some applications will read and parse the 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.The file is used to map connection information for each Oracle service to a logical alias.The Oracle driver allows you to retrieve basic connection information from a file, including: In a file, connection information for an Oracle service is associated with an alias, or Oracle net service name. SALES = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = server1)(PORT = 1521)) (CONNECT_DATA = (SID = ORCL) ) )ARMSTRONG.They are just for client access, so it is possible for the database to be created properly and the files not exist.file is by using a text editor to manually update the file; however, the SQL*Net Easy Configurator GUI can also be used.Note that you should leave the optional service name and port information empty, otherwise it may interfere with the connection by duplicating information.
Operating system TCP configurables, which vary by platform, define the actual keepalive timing details.
A 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 , 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.
To install Oracle Net Services, you run Oracle Database Client software installer, and choose the component ' Oracle Net Services' to be installed.
Oracle Database Client software is available on installation media or you can download it from the Oracle Technology Network website.To learn more about Oracle Net Services, see Introduction to Oracle Net Services By default, the file can be found at \network\admin. If no file is present on your computer, create one using a text editor. Elements in brackets must be replaced by values obtained from your database administrator.