Oracle 监听器密码设置方法(LISTENER)

[oracle@test ~]$ lsnrctl stop listener_demo92 –>停止监听，可以看出不需要任何密码便可停止

LSNRCTL for Linux: Version 9.2.0.8.0 – Production on 26-JUN⑵011 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

[oracle@test ~]$ lsnrctl

LSNRCTL for Linux: Version 9.2.0.8.0 – Production on 26-JUN⑵011 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

–>增加密码以后可以看到listener.ora文件中有一条新增的记录，即密码选项(注：虽然使用了密码管理方式,依然可以无需密码启动监听)
[oracle@test admin]$ more listener.ora
#—-ADDED BY TNSLSNR 26-JUN⑵011 05:12:48—
PASSWORDS_listener_demo92 =
#——————————————–

[oracle@test ~]$ lsnrctl stop listener_demo92
LSNRCTL for Linux: Version 9.2.0.8.0 – Production on 26-JUN⑵011 06:09:51
Copyright (c) 1991, 2006, Oracle Corporation. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test)(PORT=1521)))
TNS-01169: The listener has not recognized the password –>收到毛病信息，需要使用密码认证

[oracle@test ~]$ lsnrctl
LSNRCTL> set current_listener listener_demo92
Current Listener is listener_demo92
LSNRCTL> stop
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> stop
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test)(PORT=1521)))
The command completed successfully
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test)(PORT=1521)))
TNS⑴2541: TNS:no listener
TNS⑴2560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
TNS⑴2541: TNS:no listener
TNS⑴2560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 2: No such file or directory

–>在 Oracle 9i中，使用save_config命令将会失败
LSNRCTL> save_config
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<hostname>)(PORT=<port>)))
TNS-01169: The listener has not recognized the password

–>应当先使用set password以后再save_config，则保存配置成功。
LSNRCTL> set password
Password: <the password you chose>
The command completed successfully
/*在Oracle 10g 中不会出现类似的问题，由于在10g中可使用基于操作系统验证方式。listener将检测到如果用户属于dba组的成员，
将会被授与改变密码，保存配置和停止监听等权限。 */