如果我更改了 oracle tnsnames.ora ，我应该重新启动数据库或侦听器还是就离开它？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/5847154/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
If I changed oracle tnsnames.ora , shall I restart the DB or listeners or just leave it?
提问by Mohamed Magdy
If I changed oracle tnsnames.ora , shall I restart the DB or listeners or just leave it ?
如果我更改了 oracle tnsnames.ora，我应该重新启动数据库或侦听器还是只保留它？
回答by ik_zelf
It depends on what changed. If an alias used by a database link changed, it could be useful to close old session that have that link open. Otherwise, no restarts are needed on the rdbms server side.
这取决于改变了什么。如果数据库链接使用的别名发生更改，关闭打开该链接的旧会话可能会很有用。否则，rdbms 服务器端不需要重新启动。
回答by ClassicThunder
There is no need to restart anything. The listener doesn't use tnsnames.ora, only clients attempting to connect through the listener do.
无需重新启动任何东西。侦听器不使用 tnsnames.ora，只有尝试通过侦听器连接的客户端才会使用。
回答by Karl
No need to restart anything on the server end (listener or DB). The client reads the tnsnames.ora and tries to access server described by the connect string in the file.
无需在服务器端（侦听器或数据库）重新启动任何东西。客户端读取 tnsnames.ora 并尝试访问文件中连接字符串描述的服务器。
