ORACLE listener監聽設定密碼

peggypoon發表於2009-09-07
[orademo@r12demo DEMO_r12demo]$ lsnrctl

LSNRCTL for Linux: Version 11.1.0.7.0 - Production on 07-SEP-2009 15:36:14

Copyright (c) 1991, 2008, Oracle. All rights reserved.

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> status
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias DEMO
Version TNSLSNR for Linux: Version 11.1.0.7.0 - Production
Start Date 07-SEP-2009 15:29:55
Uptime 0 days 0 hr. 6 min. 27 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/oracle/orademo/PROD/db/tech_st/11.1.0/network/admin/DEMO_r12demo/listener.ora
Listener Log File /u01/oracle/orademo/PROD/db/tech_st/11.1.0/log/diag/tnslsnr/r12demo/demo/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=r12demo.cml.com.cn)(PORT=1521)))
Services Summary...
Service "DEMO" has 2 instance(s).
Instance "DEMO", status UNKNOWN, has 1 handler(s) for this service...
Instance "DEMO", status READY, has 1 handler(s) for this service...
Service "DEMO_XPT" has 1 instance(s).
Instance "DEMO", status READY, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL> change_passwd
NL-00853: undefined command "change_passwd". Try "help"
LSNRCTL> change_password
Old password:
New password:
Reenter new password:
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
Password changed for LISTENER
The command completed successfully
LSNRCTL> save_config
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
Saved DEMO configuration parameters.
Listener Parameter File /u01/oracle/orademo/PROD/db/tech_st/11.1.0/network/admin/DEMO_r12demo/listener.ora
Old Parameter File /u01/oracle/orademo/PROD/db/tech_st/11.1.0/network/admin/DEMO_r12demo/listener.bak
The command completed successfully
LSNRCTL> status
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias DEMO
Version TNSLSNR for Linux: Version 11.1.0.7.0 - Production
Start Date 07-SEP-2009 15:29:55
Uptime 0 days 0 hr. 8 min. 30 sec
Trace Level off
Security ON: Password or Local OS Authentication
SNMP OFF
Listener Parameter File /u01/oracle/orademo/PROD/db/tech_st/11.1.0/network/admin/DEMO_r12demo/listener.ora
Listener Log File /u01/oracle/orademo/PROD/db/tech_st/11.1.0/log/diag/tnslsnr/r12demo/demo/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=r12demo.cml.com.cn)(PORT=1521)))
Services Summary...
Service "DEMO" has 2 instance(s).
Instance "DEMO", status UNKNOWN, has 1 handler(s) for this service...
Instance "DEMO", status READY, has 1 handler(s) for this service...
Service "DEMO_XPT" has 1 instance(s).
Instance "DEMO", status READY, has 1 handler(s) for this service...
The command completed successfully[@more@]

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/21988588/viewspace-1026700/,如需轉載,請註明出處,否則將追究法律責任。

相關文章