problem while starting the listener
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: problem while starting the listener

Hybrid View

  1. #1
    Join Date
    Apr 2008
    Location
    bangalore
    Posts
    25

    problem while starting the listener

    LSNRCTL> start LISTENER_DBDOCD01
    Starting /data/oracle/product/9.2.0.8/bin/tnslsnr: please wait...

    TNSLSNR for IBM/AIX RISC System/6000: Version 9.2.0.8.0 - Production
    System parameter file is /data/oracle/product/9.2.0.8/network/admin/listener.ora
    Log messages written to /data/oracle/DBDOCD01/admin/cdump/LISTENER_DBDOCD01.log
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=DBDOCD01)))
    Error listening on: (ADDRESS=(COMMUNITY=TCPIP.world)(PROTOCOL=TCP)(Host=sintsdbdocd1.sg.db.com)(Port=1801))
    TNS-12542: TNS:address already in use
    TNS-12560: TNSrotocol adapter error
    TNS-00512: Address already in use
    IBM/AIX RISC System/6000 Error: 67: Address already in use

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


    let me know some solns.

  2. #2
    Join Date
    Apr 2003
    Location
    Pune,Maharashtra. India.
    Posts
    245
    check if Port 1801 is free.

    check netstat -an | grep 1801
    Rgds
    Parag

  3. #3
    Join Date
    Apr 2008
    Location
    bangalore
    Posts
    25
    /tshome/td01 > netstat -an | grep 1801
    tcp4 0 0 *.1801 *.* LISTEN
    tcp4 0 0 10.171.216.55.1801 10.171.217.57.38225 ESTABLISHED
    tcp4 0 0 10.171.216.55.1801 10.171.217.57.38227 ESTABLISHED
    tcp4 0 0 10.171.216.55.1801 10.171.217.57.38229 ESTABLISHED
    tcp4 0 0 10.171.216.55.1801 10.171.217.57.38232 ESTABLISHED
    tcp4 0 0 10.171.216.55.1801 10.171.217.57.38233 ESTABLISHED
    tcp4 0 0 10.171.216.55.1801 10.171.217.57.38235 ESTABLISHED
    tcp4 0 0 10.171.216.55.1801 10.171.217.57.38237 ESTABLISHED
    tcp4 0 0 10.171.216.55.1801 10.171.217.57.38260 ESTABLISHED
    tcp4 0 0 10.171.216.55.1801 10.171.217.57.38263 ESTABLISHED
    /tshome/td01 >


    --this is wat i get

  4. #4
    Join Date
    Apr 2003
    Location
    Pune,Maharashtra. India.
    Posts
    245
    some other processes is using your port.

    was this listener running previously. if not then change port and try starting the listener.

    If yes then find out who is using listener port and should it use that port. if not suppose to use then stop that process and start listener.

    To find which process is using port

    lsof | grep
    Rgds
    Parag

  5. #5
    Join Date
    Apr 2003
    Location
    Pune,Maharashtra. India.
    Posts
    245
    I think you have 2 different versions OH on same machine.
    as you got this error
    "TNS-12618: TNS:versions are incompatible"

    Most probably you are using small version utility to operate on high version listener.

    Refer this link...

    http://forums.oracle.com/forums/thre...hreadID=306402
    Rgds
    Parag

  6. #6
    Join Date
    Apr 2008
    Location
    bangalore
    Posts
    25
    I found out the problem
    there is one 10g database listener in the same machine which is using the same port number.
    Where i was trying to restart the listener for 9i database.

  7. #7
    Join Date
    Apr 2008
    Location
    bangalore
    Posts
    25
    LSNRCTL> status LISTENER_DBDOCD01
    Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=DBDOCD01))
    TNS-12541: TNS:no listener
    TNS-12560: TNSrotocol adapter error
    TNS-00511: No listener
    IBM/AIX RISC System/6000 Error: 2: No such file or directory
    Connecting to (ADDRESS=(COMMUNITY=TCPIP.world)(PROTOCOL=TCP)(Host=sintsdbdocd1.sg.db.com)(Port=1801))
    TNS-12618: TNS:versions are incompatible

    ---this is the status of the listener
    pls 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
  •  



Click Here to Expand Forum to Full Width