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
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
2) LSNRCTL> stop
Published by Osama Mustafa
Osama considered as one of the leaders in Cloud technology, DevOps and database in the Middle-East. I have more than ten years of experience within the industry. moreover, certfied 4x AWS , 4x Azure and 6x OCI, have also obtained database certifications for multiple providers.
In addition to having experience with Oracle database and Oracle products, such as middle-ware, OID, OAM and OIM, I have gained substantial knowledge with different databases.
Currently, I am architecting and implementing Cloud and DevOps. On top of that, I'm providing solutions for companies that allow them to implement the solutions and to follow the best practices.
View all posts by Osama Mustafa
3 thoughts on “Set Listener Password”
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.
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.
Thank you for your reply.