重庆思庄Oracle、Redhat认证学习论坛

标题: 12c已经取消了监听设置密码的特性 [打印本页]

作者: jiawang 时间: 2022-11-3 09:10
标题: 12c已经取消了监听设置密码的特性
本帖最后由 jiawang 于 2022-11-3 13:03 编辑

[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.

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)