Tuesday, September 2, 2014

Securing the Listener



Setting Listener Password :

step 1 :

  1.  Stop the listener.
  2.  Add the following parameter in the listener.ora: LOCAL_OS_AUTHENTICATION_listener_name = OFF
  3.  Restart the listener



Step 2 :

 set the password using lsnrctl :

   [oracle@pbltest ~]$ lsnrctl

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 02-SEP-2014 16:29:32

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> change_password
Old password:
New password:
Reenter new password:
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.41)(PORT=1521)))
Password changed for LISTENER
The command completed successfully
LSNRCTL> save_config
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.41)(PORT=1521)))
Saved LISTENER configuration parameters.
Listener Parameter File   /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
Old Parameter File   /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.bak
The command completed successfully
LSNRCTL>
LSNRCTL> set password
Password:
The command completed successfully
LSNRCTL> save_config
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.41)(PORT=1521)))
No changes to save for LISTENER.
The command completed successfully
LSNRCTL> exit


Step 3 :

 Check the below entry on the listener.ora file :

  LOCAL_OS_AUTHENTICATION_listener = OFF

#----ADDED BY TNSLSNR 02-SEP-2014 16:30:00---
PASSWORDS_LISTENER = ADD733DA61CD19A5


step 4 : Bounce the Listener .

[oracle@pbltest admin]$ lsnrctl

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 02-SEP-2014 16:32:30

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> stop
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.41)(PORT=1521)))
TNS-01169: The listener has not recognized the password


Step 5 : How to access to LISTENER


 using 'set password' command .


Metalink Note Password Not Required When Administering 10g or Newer Listeners Using Lsnrctl Utility (Doc ID 372717.1)

No comments:

Post a Comment