How to enable the password for listener

How to enable  the password fro listener

To enable the password script addlnctl.pl must be used.

DB Tier: $ORACLE_HOME/appsutil/bin/addlnctl.pl
Apps Tier: $AD_TOP/bin/addlnctl.pl

1. Example 1: To enable listener password
2. addlnctl.pl contextfile=$CONTEXT_FILE enablepassword

Example 3: To change existing listener password

addlnctl.pl contextfile=$CONTEXT_FILE changepassword

The process above will do the following :-
• change the contextfile variable s_enable_listener_password to "ON" or "OFF"
• update/remove the listener.ora with a PASSWORDS_<LIST_NAME> entry and the encrypted password value
• if the listener is not running it will not start it.
• if the listener is currently running it will stop and restart it.

Disabling OS Authentication:

For the password feature to be fully enabled with OS Authentication disabled. 

• edit $TNS_ADMIN/listener_file.ora and add the following entry:

LOCAL_OS_AUTHENTICATION_<listener name>  = OFF

restart the listener

Controlling a password protected listener

Using Listener Control Utility (LSNRCTL)

• Start the Listener Control Utility
$ lsnrctl

• Enter the listener name
LSNRCTL > set current_listener PROD

• Enter password for the Listener
LSNRCTL > set password <unencrypted password> or <press enter>

Examples:

LSNRCTL > set password apps123
or:

LSNRCTL > set password <press enter>
Password: apps123

• To determine the Status of the listener:
LSNRCTL > status

• To Stop the listener:
LSNRCTL > stop

• To start the listener:
LSNRCTL > start

• To exit :
LSNRCTL > exit

To disable the "Local OS Authentication" feature follow the procedure outlined below:

1. Stop the listener.

2. Add the following parameter to the listener ifile:

LOCAL_OS_AUTHENTICATION_<listener_name> = OFF
DB Tier:
$TNS_ADMIN/listener_file.ora

Apps Tier:
$TNS_ADMIN/$CONTEXT_NAME_listener_file.ora

3. Restart the listener