✦

Technology Geek

18+ YEARS AMONG THE CLOUDS

✦ TRANSMISSION

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 responses to “Set Listener Password”

  1. MESLI ABDELHADI

    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

    Reply
  2. Osama Mustafa

    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

    Reply
  3. MESLI ABDELHADI

    Thank you for your reply.

    Like

    Reply

Leave a comment

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