设置 Oracle 监听器密码 LISTENER

最新推荐文章于 2023-02-23 20:29:25 发布

这个就不用说了吧

最新推荐文章于 2023-02-23 20:29:25 发布

阅读量817

点赞数

本文链接：https://blog.csdn.net/fsfsdfsdw/article/details/83938879

版权

本文介绍了设置Oracle监听器密码的步骤，包括ADMIN_RESTRICTIONS参数的配置，并提供了Oracle体系结构、性能优化、备份恢复、故障处理、ASM管理和SQL/PLSQL等多方面的参考资料。

摘要由CSDN通过智能技术生成

分享一下我老师大神的人工智能教程！零基础，通俗易懂！http://blog.csdn.net/jiangjunshow

也欢迎大家转载本篇文章。分享知识，造福人民，实现我们中华民族伟大复兴！

                --==================================
-- 设置 Oracle 监听器密码(LISTENER)
--==================================

   监听器也有安全？Sure！在缺省的情况下，任意用户不需要使用任何密码即通过lsnrctl 工具对Oracle Listener进行操作或关闭，从
而造成任意新的会话都将无法建立连接。在Oracle 9i 中Oracle监听器允许任何一个人利用lsnrctl从远程发起对监听器的管理。也容易导致数
据库受到损坏。

1. 未设定密码情形下停止监听

[oracle@test ~]$ lsnrctl stop listener_demo92   -->停止监听，可以看出不需要任何密码即可停止                                                                                             LSNRCTL for Linux: Version 9.2.0.8.0 - Production on 26-JUN-2011 08:22:26                                                                                                               Copyright (c) 1991, 2006, Oracle Corporation.  All rights reserved.                                                                                                                     Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test)(PORT=1521)))                  The command completed successfully

2. 重新启动监听并设置密码

[oracle@test ~]$ lsnrctl                                                                                                                                                                                                                            LSNRCTL for Linux: Version 9.2.0.8.0 - Production on 26-JUN-2011 08:24:09                                                 Copyright (c) 1991, 2006, Oracle Corporation.  All rights reserved.                                                                                                                                                                                 Welcome to LSNRCTL, type "help" for information.                                                                         LSNRCTL> set current_listener listener_demo92  -->设置当前监听器                                                          Current Listener is listener_demo92                                                                                       LSNRCTL> start             -->启动过程也不需要任何密码,启动的详细信息省略                                                 LSNRCTL> change_password   -->使用change_password来设置密码                                                               Old password:                                                                                                             New password:                                                                                                             Reenter new password:                                                                                                     Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test)(PORT=1521)))                                                Password changed for listener_demo92                                                                                      The command completed successfully                                                                                        LSNRCTL> save_config        -->注意此处的save_config失败                                                                  Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test)(PORT=1521)))                                                TNS-01169: The listener has not recognized the password                                                                   LSNRCTL> set password       -->输入新设定的密码验证                                                                       Password:                                                                                                                 The command completed successfully                                                                                        LSNRCTL> save_config       -->再次save_config成功                                                                         Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test)(PORT=1521)))                                                Saved listener_demo92 configuration parameters.                                                                           Listener Parameter File   /oracle/92/network/admin/listener.ora                                                           Old Parameter File   /oracle/92/network/admin/listener.bak                                                                The command completed successfully                                                                                                                                                                                                                  -->增加密码之后可以看到lis