Listener Password
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Listener Password

  1. #1
    Join Date
    Oct 2008
    Location
    Chandigarh, India
    Posts
    322

    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.
    lucky

  2. #2
    Join Date
    Apr 2001
    Location
    Czechia
    Posts
    712
    Ales
    The whole difference between a little boy and an adult man is the price of toys

  3. #3
    Join Date
    Oct 2008
    Location
    Chandigarh, India
    Posts
    322
    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)
    )
    )
    lucky

  4. #4
    Join Date
    Oct 2008
    Location
    Chandigarh, India
    Posts
    322
    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
    lucky

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width