Listener Password

[mahajanakhil198]

For what purpose do we set LSNRCTL utility password?

Because whenever I log into the LSNRCTL session, it never prompts for any password. Neither does it ask for password when I change any of listener attribute using SET command.
Then for what purpose are these commands meant?
LSNRCTL> set password
LSNRCTL> change_password


I know that the question is bit absurd but I have never come across a situation where I use LSNRCTL password. That's why, I am asking it.

[ales]

http://www.integrigy.com/security-re...urity.pdf/view

[mahajanakhil198]

yup I have started reading pdf on the same website at this URL :

http://www.integrigy.com/security-re...S_Security.pdf

I was unaware of sth like remote management of listener. There is one more thing I would like to know. Where do we set the following in listener.ora file?

LOCAL_OS_AUTHENTICATION_LISTENER = OFF

E.g:
In given listener.ora file, where shall we set LOCAL_OS_AUTHENTICATION_LISTENER parameter?

LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = EDP2-BSU3)(PORT = 1521))
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = wipro)
(ORACLE_HOME = E:\oracle\product\10.2.0\db_1)
(SID_NAME = wipro)
)
(SID_DESC =
(GLOBAL_DBNAME = test)
(ORACLE_HOME = E:\oracle\product\10.2.0\db_1)
(SID_NAME = test)
)
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = E:\oracle\product\10.2.0\db_1)
(SID_NAME = ORCL)
)
)

[mahajanakhil198]

Oops i have got it.

It is at the end of file.
e.g:
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = EDP2-BSU3)(PORT = 1521))
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = wipro)
(ORACLE_HOME = E:\oracle\product\10.2.0\db_1)
(SID_NAME = wipro)
)
(SID_DESC =
(GLOBAL_DBNAME = test)
(ORACLE_HOME = E:\oracle\product\10.2.0\db_1)
(SID_NAME = test)
)
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = E:\oracle\product\10.2.0\db_1)
(SID_NAME = ORCL)
)
)

LOCAL_OS_AUTHENTICATION_LISTENER = OFF