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

Thread: Listener Problem

  1. #1
    Join Date
    Dec 2005
    Posts
    195

    Listener Problem

    Dear all,

    I have oracle9i in my home computer. I could not connect through oracle client. I tried to stop and start the listener. Here is the error message. How do i solve this prolem.

    Microsoft Windows XP [Version 5.1.2600]
    (C) Copyright 1985-2001 Microsoft Corp.

    C:\Documents and Settings>lsnrctl

    LSNRCTL for 32-bit Windows: Version 9.2.0.1.0 - Production on 28-DEC-2005 14:52:
    23

    Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

    Welcome to LSNRCTL, type "help" for information.

    LSNRCTL> stop
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=VALUED-CB7D4C82)(PORT=15
    21)))
    TNS-12541: TNS:no listener
    TNS-12560: TNSrotocol adapter error
    TNS-00511: No listener
    32-bit Windows Error: 61: Unknown error
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
    TNS-12541: TNS:no listener
    TNS-12560: TNSrotocol adapter error
    TNS-00511: No listener
    32-bit Windows Error: 2: No such file or directory
    LSNRCTL> start
    Starting tnslsnr: please wait...

    TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production
    System parameter file is d:\oracle\ora92\network\admin\listener.ora
    Log messages written to d:\oracle\ora92\network\log\listener.log
    Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=VALUED-CB7D4C82)(P
    ORT=1521)))
    TNS-12532: TNS:invalid argument
    TNS-12560: TNSrotocol adapter error
    TNS-00502: Invalid argument
    32-bit Windows Error: 22: Invalid argument

    Listener failed to start. See the error message(s) above...

    LSNRCTL>

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    post the listener.ora

  3. #3
    Join Date
    Dec 2005
    Location
    china
    Posts
    2
    post the d:\oracle\ora92\network\admin\listener.ora
    and d:\oracle\ora92\network\log\listener.log

  4. #4
    Join Date
    Dec 2005
    Posts
    195
    d:\oracle\ora92\network\admin\listener.ora
    ================================
    # LISTENER.ORA Network Configuration File: d:\oracle\ora92\network\admin\listener.ora
    # Generated by Oracle configuration tools.

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = VALUED-CB7D4C82)(PORT = 1521))
    )
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    )
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = d:\oracle\ora92)
    (PROGRAM = extproc)
    )
    )

    =========================================
    d:\oracle\ora92\network\log\listener.log
    =========================================

    TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production on 28-DEC-2005 14:24:10

    Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

    System parameter file is d:\oracle\ora92\network\admin\listener.ora
    Log messages written to d:\oracle\ora92\network\log\listener.log
    Trace information written to d:\oracle\ora92\network\trace\listener.trc
    Trace level is currently 0

    Started with pid=172
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
    Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=VALUED-CB7D4C82)(PORT=1521)))
    TNS-12532: TNS:invalid argument
    TNS-12560: TNSrotocol adapter error
    TNS-00502: Invalid argument
    32-bit Windows Error: 22: Invalid argument
    No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))

    TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production on 28-DEC-2005 14:40:01

    Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

    System parameter file is d:\oracle\ora92\network\admin\listener.ora
    Log messages written to d:\oracle\ora92\network\log\listener.log
    Trace information written to d:\oracle\ora92\network\trace\listener.trc
    Trace level is currently 0

    Started with pid=2804
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
    Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=VALUED-CB7D4C82)(PORT=1521)))
    TNS-12532: TNS:invalid argument
    TNS-12560: TNSrotocol adapter error
    TNS-00502: Invalid argument
    32-bit Windows Error: 22: Invalid argument
    No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))

    TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production on 28-DEC-2005 14:40:13

    Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

    System parameter file is d:\oracle\ora92\network\admin\listener.ora
    Log messages written to d:\oracle\ora92\network\log\listener.log
    Trace information written to d:\oracle\ora92\network\trace\listener.trc
    Trace level is currently 0

    Started with pid=2832
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
    Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=VALUED-CB7D4C82)(PORT=1521)))
    TNS-12532: TNS:invalid argument
    TNS-12560: TNSrotocol adapter error
    TNS-00502: Invalid argument
    32-bit Windows Error: 22: Invalid argument
    No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))

    TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production on 28-DEC-2005 14:41:33

    Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

    System parameter file is d:\oracle\ora92\network\admin\listener.ora
    Log messages written to d:\oracle\ora92\network\log\listener.log
    Trace information written to d:\oracle\ora92\network\trace\listener.trc
    Trace level is currently 0

    Started with pid=2584
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
    Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=VALUED-CB7D4C82)(PORT=1521)))
    TNS-12532: TNS:invalid argument
    TNS-12560: TNSrotocol adapter error
    TNS-00502: Invalid argument
    32-bit Windows Error: 22: Invalid argument
    No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))

    TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production on 28-DEC-2005 14:47:04

    Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

    System parameter file is d:\oracle\ora92\network\admin\listener.ora
    Log messages written to d:\oracle\ora92\network\log\listener.log
    Trace information written to d:\oracle\ora92\network\trace\listener.trc
    Trace level is currently 0

    Started with pid=164
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
    Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=VALUED-CB7D4C82)(PORT=1521)))
    TNS-12532: TNS:invalid argument
    TNS-12560: TNSrotocol adapter error
    TNS-00502: Invalid argument
    32-bit Windows Error: 22: Invalid argument
    No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))

    TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production on 28-DEC-2005 14:52:10

    Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

    System parameter file is d:\oracle\ora92\network\admin\listener.ora
    Log messages written to d:\oracle\ora92\network\log\listener.log
    Trace information written to d:\oracle\ora92\network\trace\listener.trc
    Trace level is currently 0

    Started with pid=1048
    Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=VALUED-CB7D4C82)(PORT=1521)))
    TNS-12532: TNS:invalid argument
    TNS-12560: TNSrotocol adapter error
    TNS-00502: Invalid argument
    32-bit Windows Error: 22: Invalid argument

    TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production on 28-DEC-2005 14:52:42

    Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

    System parameter file is d:\oracle\ora92\network\admin\listener.ora
    Log messages written to d:\oracle\ora92\network\log\listener.log
    Trace information written to d:\oracle\ora92\network\trace\listener.trc
    Trace level is currently 0

    Started with pid=572
    Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=VALUED-CB7D4C82)(PORT=1521)))
    TNS-12532: TNS:invalid argument
    TNS-12560: TNSrotocol adapter error
    TNS-00502: Invalid argument
    32-bit Windows Error: 22: Invalid argument

    TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production on 28-DEC-2005 14:58:39

    Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

    System parameter file is d:\oracle\ora92\network\admin\listener.ora
    Log messages written to d:\oracle\ora92\network\log\listener.log
    Trace information written to d:\oracle\ora92\network\trace\listener.trc
    Trace level is currently 0

    Started with pid=996
    Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=VALUED-CB7D4C82)(PORT=1521)))
    TNS-12532: TNS:invalid argument
    TNS-12560: TNSrotocol adapter error
    TNS-00502: Invalid argument
    32-bit Windows Error: 22: Invalid argument

    TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production on 28-DEC-2005 15:07:01

    Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

    System parameter file is d:\oracle\ora92\network\admin\listener.ora
    Log messages written to d:\oracle\ora92\network\log\listener.log
    Trace information written to d:\oracle\ora92\network\trace\listener.trc
    Trace level is currently 0

    Started with pid=1624
    Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=VALUED-CB7D4C82)(PORT=1521)))
    TNS-12532: TNS:invalid argument
    TNS-12560: TNSrotocol adapter error
    TNS-00502: Invalid argument
    32-bit Windows Error: 22: Invalid argument

    TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production on 28-DEC-2005 15:07:30

    Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

    System parameter file is d:\oracle\ora92\network\admin\listener.ora
    Log messages written to d:\oracle\ora92\network\log\listener.log
    Trace information written to d:\oracle\ora92\network\trace\listener.trc
    Trace level is currently 0

    Started with pid=332
    Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=VALUED-CB7D4C82)(PORT=1521)))
    TNS-12532: TNS:invalid argument
    TNS-12560: TNSrotocol adapter error
    TNS-00502: Invalid argument
    32-bit Windows Error: 22: Invalid argument

    TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production on 28-DEC-2005 15:26:55

    Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

    System parameter file is d:\oracle\ora92\network\admin\listener.ora
    Log messages written to d:\oracle\ora92\network\log\listener.log
    Trace information written to d:\oracle\ora92\network\trace\listener.trc
    Trace level is currently 0

    Started with pid=1500
    Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=VALUED-CB7D4C82)(PORT=1521)))
    TNS-12532: TNS:invalid argument
    TNS-12560: TNSrotocol adapter error
    TNS-00502: Invalid argument
    32-bit Windows Error: 22: Invalid argument

    TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production on 28-DEC-2005 15:37:46

    Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

    System parameter file is d:\oracle\ora92\network\admin\listener.ora
    Log messages written to d:\oracle\ora92\network\log\listener.log
    Trace information written to d:\oracle\ora92\network\trace\listener.trc
    Trace level is currently 0

    Started with pid=3248
    Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=VALUED-CB7D4C82)(PORT=1521)))
    TNS-12532: TNS:invalid argument
    TNS-12560: TNSrotocol adapter error
    TNS-00502: Invalid argument
    32-bit Windows Error: 22: Invalid argument

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    you have two addrsss_lists

    have something simple like this
    Code:
    LISTENER =
      (DESCRIPTION_LIST =
        (DESCRIPTION =
          (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
          (ADDRESS = (PROTOCOL = TCP)(HOST = VALUED-CB7D4C82)(PORT = 1521))
        )
      )

  6. #6
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    Code:
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
    Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=VALUED-CB7D4C82)(PORT=1521)))
    TNS-12532: TNS:invalid argument
    TNS-12560: TNSrotocol adapter error
    TNS-00502: Invalid argument
    32-bit Windows Error: 22: Invalid argument
    No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))

    Problem is with the Protocol - correct,save and run.
    "What is past is PROLOGUE"

  7. #7
    Join Date
    Dec 2005
    Posts
    195
    Hello,

    I changed the listener content as you said. But still having the problem...


    # LISTENER.ORA Network Configuration File: D:\oracle\ora92\network\admin\listener.ora
    # Generated by Oracle configuration tools.

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    (ADDRESS = (PROTOCOL = TCP)(HOST = VALUED-CB7D4C82)(PORT = 1521))
    )
    )
    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = D:\oracle\ora92)
    (PROGRAM = extproc)
    )
    )


    Here is the error message after changed the listener.ora as above.

    Microsoft Windows XP [Version 5.1.2600]
    (C) Copyright 1985-2001 Microsoft Corp.

    C:\Documents and Settings\Govindasamy>lsnrctl

    LSNRCTL for 32-bit Windows: Version 9.2.0.1.0 - Production on 29-DEC-2005 10:27:
    38

    Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

    Welcome to LSNRCTL, type "help" for information.

    LSNRCTL> stop
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=VALUED-CB7D4C82)(PORT=15
    21)))
    TNS-12541: TNS:no listener
    TNS-12560: TNSrotocol adapter error
    TNS-00511: No listener
    32-bit Windows Error: 61: Unknown error
    LSNRCTL> start
    Starting tnslsnr: please wait...

    TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production
    System parameter file is d:\oracle\ora92\network\admin\listener.ora
    Log messages written to d:\oracle\ora92\network\log\listener.log
    Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=VALUED-CB7D4C82)(P
    ORT=1521)))
    TNS-12532: TNS:invalid argument
    TNS-12560: TNSrotocol adapter error
    TNS-00502: Invalid argument
    32-bit Windows Error: 22: Invalid argument

    Listener failed to start. See the error message(s) above...

    LSNRCTL> sto
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=VALUED-CB7D4C82)(PORT=15
    21)))
    TNS-12541: TNS:no listener
    TNS-12560: TNSrotocol adapter error
    TNS-00511: No listener
    32-bit Windows Error: 61: Unknown error
    LSNRCTL> stop
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=VALUED-CB7D4C82)(PORT=15
    21)))
    TNS-12541: TNS:no listener
    TNS-12560: TNSrotocol adapter error
    TNS-00511: No listener
    32-bit Windows Error: 61: Unknown error
    LSNRCTL> start
    Starting tnslsnr: please wait...

    TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production
    System parameter file is d:\oracle\ora92\network\admin\listener.ora
    Log messages written to d:\oracle\ora92\network\log\listener.log
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc
    )))
    Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=VALUED-CB7D4C82)(P
    ORT=1521)))
    TNS-12532: TNS:invalid argument
    TNS-12560: TNSrotocol adapter error
    TNS-00502: Invalid argument
    32-bit Windows Error: 22: Invalid argument

    Listener failed to start. See the error message(s) above...

    LSNRCTL> STOP
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=VALUED-CB7D4C82)(PORT=15
    21)))
    TNS-12541: TNS:no listener
    TNS-12560: TNSrotocol adapter error
    TNS-00511: No listener
    32-bit Windows Error: 61: Unknown error
    LSNRCTL> start
    Starting tnslsnr: please wait...

    TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production
    System parameter file is d:\oracle\ora92\network\admin\listener.ora
    Log messages written to d:\oracle\ora92\network\log\listener.log
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc
    )))
    Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=VALUED-CB7D4C82)(P
    ORT=1521)))
    TNS-12532: TNS:invalid argument
    TNS-12560: TNSrotocol adapter error
    TNS-00502: Invalid argument
    32-bit Windows Error: 22: Invalid argument

    Listener failed to start. See the error message(s) above...

    LSNRCTL> stop
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=VALUED-CB7D4C82)(PORT=15
    21)))
    TNS-12541: TNS:no listener
    TNS-12560: TNSrotocol adapter error
    TNS-00511: No listener
    32-bit Windows Error: 61: Unknown error
    LSNRCTL> exit

    C:\Documents and Settings\Govindasamy>lsnrctl

    LSNRCTL for 32-bit Windows: Version 9.2.0.1.0 - Production on 29-DEC-2005 10:39:
    37

    Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

    Welcome to LSNRCTL, type "help" for information.

    LSNRCTL> start
    Starting tnslsnr: please wait...

    TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production
    System parameter file is d:\oracle\ora92\network\admin\listener.ora
    Log messages written to d:\oracle\ora92\network\log\listener.log
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc
    )))
    Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=VALUED-CB7D4C82)(P
    ORT=1521)))
    TNS-12532: TNS:invalid argument
    TNS-12560: TNSrotocol adapter error
    TNS-00502: Invalid argument
    32-bit Windows Error: 22: Invalid argument

    Listener failed to start. See the error message(s) above...

    LSNRCTL>


    The listener was working fine. Suddenly, it is started giving problem. Then reinstalled the oracle. but no luck..

  8. #8
    Join Date
    Dec 2005
    Posts
    195
    Dear Dbasan,

    You said, the problem is with protocol. But how do i correct? What should i do now?. Please let me know.

  9. #9
    Join Date
    Dec 2005
    Posts
    195
    Dear Dbasan,

    You said, the problem is with protocol. But how do i correct? What should i do now?. Please let me know.

  10. #10
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    Quote Originally Posted by pranavgovind
    Dear Dbasan,

    You said, the problem is with protocol. But how do i correct? What should i do now?. Please let me know.
    Code:
    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    (ADDRESS = (PROTOCOL = TCP)(HOST = VALUED-CB7D4C82)(PORT = 1521))
    )
    )
    )
    
    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = D:\oracle\ora92)
    (PROGRAM = extproc)
    )
    )
    When you are editing these file be carefull take acopy before doing. Address parameter is not set right. Also it is better to use IP address in host instead of name. Good luck.
    "What is past is PROLOGUE"

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