DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: Listener Problem

  1. #1
    Join Date
    Nov 2000
    Posts
    157

    Angry

    Hi Guys,

    I am trying to start the listener. Its giving the problem like:


    LSNRCTL> reload
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
    The command completed successfully

    LSNRCTL> stop
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
    The command completed successfully

    LSNRCTL> start
    Starting tnslsnr: please wait...

    TNSLSNR for 32-bit Windows: Version 8.1.7.0.0 - Production
    System parameter file is C:\programfiles\Ora81\network\admin\listener.ora
    Log messages written to C:\programfiles\Ora81\network\log\listener.log
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc
    )))
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=msft-man)(PORT=1521)))
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=msft-man)(PORT=1521))(PR
    OTOCOL_STACK=(PRESENTATION=GIOP)(SESSION=RAW)))

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
    TNS-12597: TNS:connect descriptor already in use
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=msft-man)(PORT=1521)))
    TNS-12597: TNS:connect descriptor already in use
    LSNRCTL>

    Can you please give me any solution ASAP.

    Thanks
    Ravi
    ravi

  2. #2
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    Check listener.ora file in $ORACLE_HOME/network/admin, may be you have double lines in this file.

  3. #3
    Join Date
    Nov 2000
    Posts
    157
    This is my Listener.ora. Please correct me if i am wrong.

    # LISTENER.ORA Network Configuration File: C:\programfiles\Ora81\network\admin\listener.ora
    # Generated by Oracle configuration tools.

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )

    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = msft-man)(PORT = 1521))
    )

    )
    (DESCRIPTION =
    (PROTOCOL_STACK =
    (PRESENTATION = GIOP)
    (SESSION = RAW)
    )
    (ADDRESS = (PROTOCOL = TCP)(HOST = msft-man)(PORT = 1521))
    )
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = C:\programfiles\Ora81)
    (PROGRAM = extproc)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = test.domain)
    (ORACLE_HOME = C:\programfiles\Ora81)
    (SID_NAME = test)
    )

    )

    Thanks
    Ravi

    ravi

  4. #4
    Join Date
    Jul 2000
    Posts
    521
    Have you checked whether the listener is already running ?
    svk

  5. #5
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    Check (on my mind you have double ADDRESS declaration)

    # LISTENER.ORA Network Configuration File: C:\programfiles\Ora81\network\admin\listener.ora
    # Generated by Oracle configuration tools.

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    # (ADDRESS = (PROTOCOL = TCP)(HOST = msft-man)(PORT = 1521))
    )
    )
    (DESCRIPTION =
    (PROTOCOL_STACK =
    (PRESENTATION = GIOP)
    (SESSION = RAW)
    )
    (ADDRESS = (PROTOCOL = TCP)(HOST = msft-man)(PORT = 1521))
    )
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = C:\programfiles\Ora81)
    (PROGRAM = extproc)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = test.domain)
    (ORACLE_HOME = C:\programfiles\Ora81)
    (SID_NAME = test)
    )
    )

    PS: I thing you use NetConfig for setup listener parameters.
    This program add ADDRESS_LIST each time, when you use it.
    This is little bit not correct.




    [Edited by Shestakov on 10-19-2001 at 02:12 PM]

  6. #6
    Join Date
    Nov 2000
    Posts
    157
    Hi,

    1)I tried to stop and start the listener then only i am getting the above mentioned problem.

    2) Yes. I used netconfig to setup my listener. The actual Listener.ora was also posted for ur verification.

    Any solution please.

    Thanks
    ravi

  7. #7
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    I see, that is Win NT(2000) box.
    Check NT services, is OraListener running as service.
    Try to stop it thru control panel and start it again.

  8. #8
    Join Date
    Nov 2000
    Posts
    157
    I am sorry. I didn't mentioned my environment. It is oracle 817 on windows 2000. But i already checked that ora listener is running.

    Thanks
    Ravi
    ravi

  9. #9
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    If it running, then in DOS session exec :
    lsnrctl status
    If you may, then show result.

  10. #10
    Join Date
    Dec 1999
    Location
    Cincinnati, Ohio USA
    Posts
    99
    Make a backup of the listener.ora file and Change it to this.
    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    )
    (DESCRIPTION =
    (PROTOCOL_STACK =
    (PRESENTATION = GIOP)
    (SESSION = RAW)
    )
    (ADDRESS = (PROTOCOL = TCP)(HOST = msft-man)(PORT = 1521))
    )
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = C:\programfiles\Ora81)
    (PROGRAM = extproc)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = test.domain)
    (ORACLE_HOME = C:\programfiles\Ora81)
    (SID_NAME = test)
    )

    )
    Doug

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