Password protection for listener
                                                 Last update (2011-02-22 12:59:08)
                                                                                                                   Date added (2008-02-27 10:38:22)

To avoid inadvertent stopping of your listener or to prevent unauthorized access to your listener, you may set up password protection for your listener. There are two ways to set a password:

1. Clear text Password
2. Encrypted Password

1.Clear text Password
Lets say that in your $TNS_ADMIN/listener.ora you have a listener named LISTENER1
(i)Add PASSWORDS_LISTENER1 entry to your existing listener.ora file. e.g.PASSWORDS_LISTENER1 = (p1,p2)
(ii)Stop your listener, and restart it.

Now passwords are in effect.

To administer the listener, set password command must be used.
 LSNRCTL> set current_listener LISTENER1
 LSNRCTL> set password p1
 LSNRCTL> stop
2. Encrypted Password
Lets say that in your $TNS_ADMIN/listener.ora you have a listener named LISTENER2
run lsnrctl
LSNRCTL> set current_listener LISTENER2
LSNRCTL> set save_config_on_stop on
LSNRCTL> change_password
Old password: 
New password: 
Reenter new password: 

Just hit 'Enter' key for old password since no previous password is set.
The passwords you entered will not be echoed. If you are in Oracle10g after that execute 
LSNRCTL> save_config
If you are in Oracle9i the command save_config will not work! You have to stop the listener first and then start it again Stop the listener LSNRCTL> set password Password: LSNRCTL> stop LSNRCTL> set password Password: **** LSNRCTL> start Check your listener.ora file Entries similar to the following should have been added to your listener.ora automatically. SAVE_CONFIG_ON_STOP_listener2 = ON PASSWORDS_listener2 = 2D6C48144CF753AC
Other links
Block specific IP from connecting to database
Oracle DBA-> (147)
  Alertlog (3)
  Archivelog (5)
  Auditing (1)
  Backup - Recovery (19)
  Database files (6)
  Database options (2)
  DB links (2)
  Dependencies (1)
  Dictionary (2)
  Exp-Imp Datapump (6)
  Jobs (2)
  Mview (2)
  Networking (3)
  Objects (7)
  Parameters (2)
  Redologs (6)
  Roles - Grants (2)
  Rollback - Undo (8)
  Segments (3)
  Sequences (2)
  Sessions (14)
  SGA (14)
  Tables (10)
  Tablespaces (10)
  Temp (4)
  Toad (5)
  Transactions (1)
  Upgrade (2)
  Users (3)
Oracle APPS DBA-> (66)
Exadata (1)
Performance Tuning-> (59)
Oracle Real Cases (24)
Oracle Errors (23)
Oracle SQL tricks (32)
Oracle RAC (3)
Oracle Security (8)