Rac系统设置Tnslsnr口令的相关问题

Maclean Liu(刘相兵

Question from 网友


想咨询一下Rac系统设置Tnslsnr口令的相关问题，具体实施中需要注意哪些事项，
是不是两个节点都需要设置，对客户端设置有什么要求，我们的服务端是11.2.0.1.0 ，
客户端是9.0.1.0.0 的版本?

Maclean Liu(刘相兵

AS maclean said:


我想你要问的是 为listener 设置password?

不清楚你们为什么有这样的需求 ，

但是在11.2中listener 的密码password功能已经被废弃了 ，不建议为listener 设置密码


In Oracle Database 11g Release 2 (11.2), the password feature is being deprecated. This does not cause a loss of security because authentication is enforced through local operating system authentication.

What do you need to do?

When upgrading to Oracle Database 11g Release 2 (Patch Set 11.2.0.3 and later) , follow the steps below to migrate a listener that has a set password:

1. Remove all PASSWORDS_listener_name entries from the listener.ora file.
2. Reload the listener using the following command: lsnrctl reload listener_name

If remote administration of a listener is required, then use one of the following methods to connect to and administer the listener.

Connect to the host where listener is running using SSH or other secure method, and then perform local   administration. Local administration is enforced by the operating system authentication.
Use Oracle Enterprise Manager to administer the listener. Oracle Enterprise Manager uses HTTPS,  which ensures security.
Please note, that this feature will be de-supported in the next major Oracle Database version (currently called 12g) and will then no longer be available.

For more information please refer to the following Oracle Database 11g Release 2 documentation:
Oracle Database Net Services Administrator's Guide (html, pdf) - Chapter 9 'Configuring and Administering Oracle Net Listener'
Oracle Database Net Services Reference (html, pdf) - Appendix B 'Upgrade Considerations for Oracle Net Services'