12c已经取消了监听设置密码的特性

jiawang

[grid@sztech ~]$ lsnrctl
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 25-OCT-2022 10:20:40
Copyright (c) 1991, 2021, Oracle.  All rights reserved.
Welcome to LSNRCTL, type "help" for information.

LSNRCTL> statis
NL-00853: undefined command "statis".  Try "help"
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=sztech)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                25-OCT-2022 10:19:53
Uptime                    0 days 0 hr. 1 min. 9 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/19.14/grid/network/admin/listener.ora
Listener Log File         /u01/app/grid/diag/tnslsnr/sztech/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sztech)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=sztech)(PORT=5500))(Security=(my_wallet_directory=/u01/app/oracle/product/19.14/db_1/admin/orclcdb/xdb_wallet))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM", status READY, has 1 handler(s) for this service...
Service "+ASM_DATA" has 1 instance(s).
  Instance "+ASM", status READY, has 1 handler(s) for this service...
Service "86b637b62fdf7a65e053f706e80a27ca" has 1 instance(s).
  Instance "orclcdb", status READY, has 1 handler(s) for this service...
Service "e69255bb8c70336ae0537a85a8c0eb42" has 1 instance(s).
  Instance "orclcdb", status READY, has 1 handler(s) for this service...
Service "orclcdb" has 1 instance(s).
  Instance "orclcdb", status READY, has 1 handler(s) for this service...
Service "orclcdbXDB" has 1 instance(s).
  Instance "orclcdb", status READY, has 1 handler(s) for this service...
Service "orclpdb" has 1 instance(s).
  Instance "orclcdb", status READY, has 1 handler(s) for this service...
The command completed successfully

LSNRCTL> change_password
NL-00853: undefined command "change_password".  Try "help"
查看监听帮助

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

rawmode                              displaymode                          
trc_file                             trc_directory                        
trc_level                            log_file                             
log_directory                        log_status                           
current_listener                     inbound_connect_timeout              
startup_waittime                     save_config_on_stop                  
dynamic_registration                 enable_global_dynamic_endpoint      
connection_rate_limit                valid_node_checking_registration     
registration_invited_nodes           registration_excluded_nodes         

LSNRCTL>

可见12c中并没有change_password的参数了。
在11g中查看监听的帮助信息，有change_password参数。
C:\Users\Administrator>lsnrctl
LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 24-10月-2022 10:3
6:35
Copyright (c) 1991, 2010, Oracle.  All rights reserved.
欢迎来到LSNRCTL, 请键入"help"以获得信息。
LSNRCTL> help
以下操作可用
星号 (*) 表示修改符或扩展命令:

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

于是查看oracle的官方文档，发现12c已经取消了监听设置密码的特性： Desupport of Oracle Net Listener Password
In Oracle Database 12c, the Oracle Net Listener password feature is no longer supported.
This change does not cause a loss of security, because Oracle Database enforces authentication through local operating system authentication.