Set Listener Password

In Oracle 10g and above, the listener is secured by default, and only user who started the listener can run the commands.

In order to set password on listener, follow the steps:

1) LSNRCTL> set current_listener
2) LSNRCTL> change_password
Old password:
New password: yourpassword
Reenter new password: yourpassword
3) LSNRCTL> save_config
4) LSNRCTL> status

Now Any One Want Start Administrating Listener Will be Asked for Password , After This you can manager Your Listener .

As the another user, enter the password to administer the listener:

1) LSNRCTL> set password
Password: yourpassword
2) LSNRCTL> stop

Thank you
Osama mustafa

3 thoughts on “Set Listener Password

  1. Hi osama,I have some questionsQ1:Where is stocked the password of listener?Q2:if we forget the passeword of listner,how to retrieve the password?Thank you in advance.

    Like

  2. Thank you Mesli for you commentA1 : by default oracle Listener comes without password , but when you set password for DB listener you save it in listener.ora (encrypted). and you can check listener processps -ef | grep tnsA2 : you can't retrieve listener password , but you can remove password entry from listener.ora and reload listener.

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.