Results 1 to 6 of 6
  1. #1
    Join Date
    Jan 2003
    Posts
    41

    Unanswered: How create new listener from command prompt

    Hello,
    I have problem with Oracle Net and Net8 tools and thus I am not able to create new listener, does anybody know how create new listener using command prompt?

    Thank you for any advice!

    Ondrej

  2. #2
    Join Date
    Oct 2004
    Posts
    145
    What is your OS?

    In unix it is very simple, windows should be similar but I am not sure how you would register the new listener service. Add another entry in listener.ora file and start the listener. If you are using same version ensure you identify second listener to be started on different port (ie. not 1521/1541 default).

    From example below
    Set proper environment variable than
    to start lsn_817
    lsnrctl start lsn_817
    to start lsn_920
    lsnrctl start lsn_920

    eg.

    LSN_817 =
    (ADDRESS_LIST =
    (ADDRESS= (PROTOCOL= TCP)(Host= pf1d7.tcpl.ca)(Port= 1521))
    )
    STARTUP_WAIT_TIME_LSN_817 = 0
    CONNECT_TIMEOUT_LSN_817 = 10
    LOG_DIRECTORY_LSN_817 = /oracle/network/log
    LOG_FILE_LSN_817 = lsn_817.log
    TRACE_LEVEL_LSN_817 = OFF
    TRACE_DIRECTORY_LSN_817 = /oracle/network/trace
    TRACE_FILE_LSN_817 = lsn_817.trc
    SID_LIST_LSN_817 =
    (SID_LIST =
    (SID_DESC = (SID_NAME = davt)(ORACLE_HOME = /oracle/product/8.1.7))
    )
    LSN_920 =
    (ADDRESS_LIST =
    (ADDRESS= (PROTOCOL= TCP)(Host= pf1d7.tcpl.ca)(Port= 1541))
    )
    STARTUP_WAIT_TIME_LSN_920 = 0
    CONNECT_TIMEOUT_LSN_920 = 10
    LOG_DIRECTORY_LSN_920 = /oracle/network/log
    LOG_FILE_LSN_920 = lsn_920.log
    TRACE_LEVEL_LSN_920 = OFF
    TRACE_DIRECTORY_LSN_920 = /oracle/network/trace
    TRACE_FILE_LSN_920 = lsn_920.trc
    SID_LIST_LSN_920 =
    (SID_LIST =
    (SID_DESC = (SID_NAME = dbfs)(ORACLE_HOME = /oracle/product/9.2.0))
    )

  3. #3
    Join Date
    Jan 2003
    Posts
    41
    We use windows 2000 server and Oracle 9.2.0.5

  4. #4
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    It should be basically the same for Windows (although, being honest, I haven't actually tried it myself). Try these two links:

    http://www.davidbradford.com/CS138B_AddingAListener.pdf

    http://www.lazydba.com/oracledba.pl?0%3A200308

    I have come across this article, which may be worth paying attention to:

    Failed to start service, TNS-12560, TNS-00530 when create new listener
    services

    Problem:
    To recreate Oracle TNS listener service on Windows NT, you delete the
    service entry in registry. When using lsnrctl to start the listener,
    you get the following errors:

    LSNRCTL> start
    Starting tnslsnr: please wait...

    Failed to start service, error 3.

    TNS-00530: Protocol adapter error

    The Listener service is not recreated and the Listener would not start.
    You are using a valid listener.ora file and protocol adapters.


    Solution:
    After you delete the Listener service from registry, you have to reboot NT
    for it to take effect. Then you can use lsnrctl to start the Listener,
    which would re-create the listener service.



    HTH.
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  5. #5
    Join Date
    Oct 2004
    Posts
    145
    I tried it in win2000 oracle instance and the method used in unix works.

    However this is a manual process. I am not familiar enough with Windows to add this to the service. You need to consult someone else regarding this.

    Bottom line

    Add new listener entry to listener.ora
    than use command line to manually start it.

    lsnrctl start new_listenername

  6. #6
    Join Date
    Jan 2003
    Posts
    41
    OK. Thank you very much for your help.

Posting Permissions

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