Shulou(Shulou.com)06/01 Report--

This article will explain in detail the example analysis of the lsnrctl reload command provided by Oracle. The content of the article is of high quality, so the editor will share it with you for reference. I hope you will have some understanding of the relevant knowledge after reading this article.

Oracle provides the lsnrctl reload command in the following two cases

1 modify listener.ora

2 modify sqlnet.ora

If you don't want to stop listening after that, consider the lsnrctl reload command!

The reload command rereads the contents of the listener.ora, which allows the user to change the listener's configuration without stopping the listener. But consider the changes to sqlnet.ora:

1 if sqlnet.ora has not been used by the current listener before, you must turn it off and restart it!

2 if you are using sqlnet.ora before, then lsnrctl reload is the faster way. Currently established connections will not be affected, and dynamic monitoring services are completed very quickly and almost unaffected.

The official explanation for lsnrctl reload:

Use the RELOAD command to reread the listener.ora file. This command enables you to add or change statically configured services without actually stopping the listener.

In addition, the database services, instances, service handlers, and listening endpoints that were dynamically registered with the listener will be unregistered and subsequently registered again.

The meaning is similar to that explained above, and necessary caution should be taken to modify sqlnet.ora files in a production environment. Previous experiments with lsnrctl reload did not achieve the desired results. Lsnrctl start/stop is selected for execution on the production repository.

The time of these two steps is very short, and the shutdown and restart operations are completed in 3-4 seconds.

This is the end of the sample analysis of the lsnrctl reload command provided by Oracle. I hope the above content can be of some help and learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.