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

[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

[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                      
                               
-->增加密码之后可以看到listener.ora文件中有一条新增的记录，即密码选项(注：尽管使用了密码管理方式,仍然可以无需密码启动监听)
[oracle@test admin]$ more listener.ora                      
#----ADDED BY TNSLSNR 26-JUN-2011 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-2011 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-12541: TNS:no listener               
 TNS-12560: TNS:protocol adapter error           
 TNS-00511: No listener              
  Linux Error: 111: Connection refused          
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))     
TNS-12541: TNS:no listener               
 TNS-12560: 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组的成员，
将会被授予改变密码，保存配置以及停止监听等权限。 */