Wednesday, September 5, 2007

Protect the Listener by password

We can set password by two ways

a) Cleartext Password:
Add PASSWORDS_< your_listener_name > entry to your existing listener.ora file and restart the listener
PASSWORDS_listener1 = (p1,p2)

Example of a listener stop operation

LSNRCTL > set current_listener listener1
LSNRCTL > set password p1
LSNRCTL > stop

b)Encrypted Password
- Comment out PASSWORD_ line if cleartext password is set.
- Restart listener.
- Run lsnrctl
LSNRCTL > set current_listener LSNRCTL > set save_config_on_stop on
LSNRCTL > change_password
Old password: < enter >
New password: < enter_your_password >
Reenter new password: < reenter_your_password >
Example
LSNRCTL > change_password
Old password: < enter >
New password: e1
Reenter new password: e1
Just hit < enter > key for old password since no previuos password is set. The passwords you entered will not be echoed.

- Stop the listener

LSNRCTL > set password
Password: < enter_your_password_here >
LSNRCTL > stop

Example of a listener process
LSNRCTL > set password
Password: e1
LSNRCTL > stop

- Check your listener.ora file if PASSWORDS_< listener1 > exists

No comments: