If I changed oracle tnsnames.ora , shall I restart the DB or listeners or just leave it?

If I changed oracle tnsnames.ora , shall I restart the DB or listeners or just 开发者_如何学JAVAleave it ?

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.

There is no need to restart anything. The listener doesn't use tnsnames.ora, only clients attempting to connect through the listener do.

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.