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 > 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:
Post a Comment