oracle12c已经取消了监听启动密码的特性

lsnrctl
LSNRCTL> start
LSNRCTL> change_password
Old password:***
New password:***
Reenter new password:***
LSNRCTL> save_config
复制

在一次项目中需要设置数据库监听器(LISTENER)启动密码，但是发现lsnrctl交互界面中没有change_password这个命令。

报错：

NL-00853: undefined command "change_password". Try "help"
复制

help一下

LSNRCTL> help
The following operations are available
An asterisk (*) denotes a modifier or extended command:

start           stop            status          services
servacls        version         reload          save_config
trace           spawn           quit            exit
set*            show*
复制

在11g中查看监听的帮助信息，是有change_password参数的。

start               stop                status
services            version             reload
save_config         trace               change_password
quit                exit                set*
show*
复制

可以看到12c中这个命令确实不存在，查看官方文档，发现确实以及取消了监听密码这个特性。

8.6.3 Desupport of Oracle Net Listener Password

In Oracle Database 12c, the Oracle Net Listener password feature is no longer supported. This does not cause a loss of security because authentication is enforced through local operating system authentication.

See Also:
Oracle Database Net Services Reference for more information about Oracle Net Listener security
复制

官方文档链接：

https://docs.oracle.com/database/121/UPGRD/deprecated.htm#BABDBIBJ