lsnrctl change_password old password: new password: reenter new password: connecting to (description=(address=(protocol=tcp)(host=ecp-uc-db1)(port=1521))) password changed for listener the command completed successfully lsnrctl set passwor
lsnrctl> change_password
old password:
new password:
reenter new password:
connecting to (description=(address=(protocol=tcp)(host=ecp-uc-db1)(port=1521)))
password changed for listener
the command completed successfully
lsnrctl> set password
password:
the command completed successfully
lsnrctl> save_config
connecting to (description=(address=(protocol=tcp)(host=ecp-uc-db1)(port=1521)))
saved listener configuration parameters.
listener parameter file /opt/oracle/product/10.2.0/db_1/network/admin/listener.ora
old parameter file /opt/oracle/product/10.2.0/db_1/network/admin/listener.bak
the command completed successfully
[oracle@ecp-uc-db1 admin]$ cat listener.ora
#—-added by tnslsnr 10-jun-2011 18:13:24—
passwords_listener = 6d7aa003392c436a
#——————————————–
note：10g数据库上需要上添加（重启监听）
local_os_authentication_listener = off
1、添加local_os_authentication_listener = off之前
security on: password or local os authentication
2、添加local_os_authentication_listener = off之后
security on: password
lsnrctl> status
connecting to (description=(address=(protocol=tcp)(host=ecp-uc-db1)(port=1521)))
tns-01169: the listener has not recognized the password
lsnrctl> stop
connecting to (description=(address=(protocol=tcp)(host=ecp-uc-db1)(port=1521)))
tns-01169: the listener has not recognized the password
lsnrctl> set password 123456
the command completed successfully
lsnrctl> status
connecting to (description=(address=(protocol=tcp)(host=ecp-uc-db1)(port=1521)))
status of the listener
————————
alias listener
version tnslsnr for linux: version 10.2.0.4.0 – production
start date 10-jun-2011 18:15:49
uptime 0 days 0 hr. 1 min. 16 sec
trace level off
security on: password
snmp off
listener parameter file /opt/oracle/product/10.2.0/db_1/network/admin/listener.ora
listener log file /opt/oracle/product/10.2.0/db_1/network/log/listener.log
listening endpoints summary…
(description=(address=(protocol=tcp)(host=ecp-uc-db1)(port=1521)))
(description=(address=(protocol=ipc)(key=extproc0)))
services summary…
service “plsextproc” has 1 instance(s).
instance “plsextproc”, status unknown, has 1 handler(s) for this service…
service “ecp” has 1 instance(s).
instance “ecp”, status ready, has 1 handler(s) for this service…
service “ecpxdb” has 1 instance(s).
instance “ecp”, status ready, has 1 handler(s) for this service…
service “ecp_xpt” has 1 instance(s).
instance “ecp”, status ready, has 1 handler(s) for this service…
the command completed successfully