Friday, June 22, 2012

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 comments:

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

    ReplyDelete
  2. Thank you Mesli for you comment

    A1 : 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 process
    ps -ef | grep tns

    A2 : you can't retrieve listener password , but you can remove password entry from listener.ora and reload listener.

    ReplyDelete
  3. Thank you for your reply.

    ReplyDelete