listener error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: listener error

  1. #1
    Join Date
    Oct 2007
    Posts
    114

    listener error

    Hi Friends,

    I cannot startup my listener when i run "lsnrctl start"

    I got these errors:
    ===============

    LSNRCTL for Linux: Version 10.2.0.3.0 - Production on 26-JUN-2008 18:26:45

    Copyright (c) 1991, 2006, Oracle. All rights reserved.

    Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROCPROD))
    TNS-12560: TNSrotocol adapter error
    TNS-00530: Protocol adapter error
    Linux Error: 20: Not a directory
    Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=orasvr1.abc.net.ph)(Port=1521))
    TNS-12541: TNS:no listener
    TNS-12560: TNSrotocol adapter error
    TNS-00511: No listener
    Linux Error: 111: Connection refused

    LSNRCTL for Linux: Version 10.2.0.3.0 - Production on 26-JUN-2008 18:26:45

    Copyright (c) 1991, 2006, Oracle. All rights reserved.

    Starting /u02/oracle/PROD/db/tech_st/10.2.0/bin/tnslsnr: please wait...

    TNSLSNR for Linux: Version 10.2.0.3.0 - Production
    System parameter file is /u02/oracle/PROD/db/tech_st/10.2.0/network/admin/PROD_orasvr1/listener.ora
    Log messages written to /u02/oracle/PROD/db/tech_st/10.2.0/network/admin/prod.log
    Error listening on: (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROCPROD))
    TNS-12560: TNSrotocol adapter error
    TNS-00530: Protocol adapter error
    Linux Error: 20: Not a directory

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




    LSNRCTL for Linux: Version 10.2.0.3.0 - Production on 26-JUN-2008 18:26:45

    Copyright (c) 1991, 2006, Oracle. All rights reserved.

    Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROCPROD))
    TNS-12560: TNSrotocol adapter error
    TNS-00530: Protocol adapter error
    Linux Error: 20: Not a directory
    Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=orasvr1.abc.net.ph)(Port=1521))
    TNS-12541: TNS:no listener
    TNS-12560: TNSrotocol adapter error
    TNS-00511: No listener
    Linux Error: 111: Connection refused

    LSNRCTL for Linux: Version 10.2.0.3.0 - Production on 26-JUN-2008 18:26:45

    Copyright (c) 1991, 2006, Oracle. All rights reserved.

    Starting /u02/oracle/PROD/db/tech_st/10.2.0/bin/tnslsnr: please wait...

    TNSLSNR for Linux: Version 10.2.0.3.0 - Production
    System parameter file is /u02/oracle/PROD/db/tech_st/10.2.0/network/admin/PROD_orasvr1/listener.ora
    Log messages written to /u02/oracle/PROD/db/tech_st/10.2.0/network/admin/prod.log
    Error listening on: (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROCPROD))
    TNS-12560: TNSrotocol adapter error
    TNS-00530: Protocol adapter error
    Linux Error: 20: Not a directory

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


    Please help me....thanks a lot
    Last edited by reeshe; 06-30-2008 at 06:12 AM.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    post the listener.ora - it has errors

  3. #3
    Join Date
    Oct 2007
    Posts
    114
    Thanks Dave ...why do I get dir error? >Linux Error: 20: Not a directory
    Which line was it?


    My listener.ora...bow
    ================

    #
    # Net8 definition for Database listener
    #

    PROD =
    (ADDRESS_LIST =
    (ADDRESS= (PROTOCOL= IPC)(KEY= EXTPROCPROD))
    (ADDRESS= (PROTOCOL= TCP)(Host= orasvr1.abc.net.ph )(Port= 1521))
    )

    SID_LIST_PROD =
    (SID_LIST =
    (SID_DESC =
    (ORACLE_HOME= /u02/oracle/PROD/db/tech_st/10.2.0)
    (SID_NAME = PROD)
    )
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = /u02/oracle/PROD/db/tech_st/10.2.0)
    (PROGRAM = extproc)
    )
    )

    STARTUP_WAIT_TIME_PROD = 0
    CONNECT_TIMEOUT_PROD = 10
    TRACE_LEVEL_PROD = OFF

    LOG_DIRECTORY_PROD = /u02/oracle/PROD/db/tech_st/10.2.0/network/admin
    LOG_FILE_PROD = PROD
    TRACE_DIRECTORY_PROD = /u02/oracle/PROD/db/tech_st/10.2.0/network/admin
    TRACE_FILE_PROD = PROD
    ADMIN_RESTRICTIONS_PROD = OFF
    SUBSCRIBE_FOR_NODE_DOWN_EVENT_PROD = OFF

    IFILE=/u02/oracle/PROD/db/tech_st/10.2.0/network/admin/PROD_orasvr1/listener_ifile.ora

    ===== end

    My /etc/hosts
    ===========
    127.0.0.1 localhost.localdomain localhost
    119.111.9.48 orasvr1.abc.net.ph orasvr1


    I can ping > orasvr1.abc.net.ph
    Last edited by reeshe; 06-29-2008 at 06:16 AM.

  4. #4
    Join Date
    Oct 2006
    Posts
    175
    did you try replacing hostname by ip?
    Listener.ora shows (ADDRESS= (PROTOCOL= TCP)(Host= orasvr1.abc.net.ph )(Port= 1521))
    whereas the error message shows :
    Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=orasvr1.prime.net.ph)(Port=1521))


    HTH,
    gtcol

  5. #5
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Quote Originally Posted by gtcol
    did you try replacing hostname by ip?
    Listener.ora shows (ADDRESS= (PROTOCOL= TCP)(Host= orasvr1.abc.net.ph )(Port= 1521))
    whereas the error message shows :
    Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=orasvr1.prime.net.ph)(Port=1521))
    As stated Poster can ping the host name, what are you planning to solve by replacing hostname by IP address?
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  6. #6
    Join Date
    Oct 2006
    Posts
    175
    i just got confused with these two different hosts in two different locations.
    listener.ora: (Host= orasvr1.abc.net.ph )
    error msg: (Host=orasvr1.prime.net.ph)


    gtcol

  7. #7
    Join Date
    Oct 2007
    Posts
    114
    hi....thats for confidentiality i used abc instead of prime....just forget the prime thing.

    So...any ideas please what is missing with listener.ora

    Thanks

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