-
Listener Password
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.
-
-
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)
)
)
-
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