Setting password for listener in 10g


This is a post in which i will tell you that how can you setup the password for your listener in 10g

NOTE:-It is not absolute necessary that you have to set a password for your listener in 10g because 10g is already very much secure as you can only run any oracle executable from only the authorised user

Follow these simple steps to add a password for your listener,screenshots are also provided for a better result

Step 1)_Start lsnrctl from cmd and type change_password <listener_name> for changing password of the listener

Step 2)_Type save_config to save the configuration in the listener.ora file

Step 3)_Now go to computer management and create a new user and dsnt give the ora_dba group to the new user(ora_dba is the group for accessing the oracle executables)

Step 4)_Now logout of the main administrator user and login with the newly created user,this step is necessary because any user who is having privilege to ora_dba group can start and stop the listener without the password,only the remote users i.e who dsnt have ora_dba group assign to them will require password for using lsnrctl utility,and we are pretending a similar remote user situation here

Step 5)_Now run cmd and type lsnrctl and then try stopping the listener for which you have set the password(in this case its listener1) it will show the error

NOTE:-for accessing lsnrctl utility you must have already instaled it

Step 6)_Now type set password this will prompt for the password of the listener which you have already set,provide it the password

Step 7)_Now try to stop the listener again and this time it will stop successfully

Congratulations!!!!

You have successfully controlled a listener using a password