2. vi $ORACLE_HOME/network/admin/listener.ora
添加如下内容
LOCAL_OS_AUTHENTICATION_LISTENER=OFF ---涂绿为监听器的名字
3. bash-3.00$ lsnrctl ---输入lsnrctl进入监听器
LSNRCTL for Solaris: Version 10.2.0.1.0 - Production on 20-NOV-2009 10:30:46
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> set current_listener LISTENER --- LISTENER为配置的监听器的名字
Current Listener is LISTENER
LSNRCTL> change_password ---为监听器配置密码
Old password: ---如以前没配置过密码,回车就可
New password: ---配置新密码
Reenter new password: --重新确认新密码
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=240a)(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=240a)(PORT=1521)))
Saved LISTENER configuration parameters.
Listener Parameter File /export/home/oracle/oracle/product/10.2.0/db_1/network/admin/listener.ora
Old Parameter File /export/home/oracle/oracle/product/10.2.0/db_1/network/admin/listener.bak
The command completed successfully
LSNRCTL> status ----查看配置后监听器状态
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=240a)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Solaris: Version 10.2.0.1.0 - Production
Start Date 20-NOV-2009 10:30:37
Uptime 0 days 0 hr. 1 min. 36 sec
Trace Level off
Security ON: Password ---请注意,此时密码开启
SNMP OFF
Listener Parameter File /export/home/oracle/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /export/home/oracle/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=240a)(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 "source" has 1 instance(s).
Instance "source", status READY, has 1 handler(s) for this service...
Service "sourceXDB" has 1 instance(s).
Instance "source", status READY, has 1 handler(s) for this service...
Service "source_XPT" has 1 instance(s).
Instance "source", status READY, has 1 handler(s) for this service...
The command completed successfully
4. 下次再对监听器进行任何操作
bash-3.00$ lsnrctl
LSNRCTL for Solaris: Version 10.2.0.1.0 - Production on 20-NOV-2009 10:33:58
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=240a)(PORT=1521)))
TNS-01169: The listener has not recognized the password ---表明需要输入密码
LSNRCTL> set password ---输入密码就可,进行相关操作
Password:
The command completed successfully
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/9240380/viewspace-620124/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/9240380/viewspace-620124/