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

Summary
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
 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
Reviews
Categories
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)
Filters
Search