Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2004
    Posts
    3

    Question Unanswered: Error trying to start LISTENER

    Hello,

    I have an Oracel 9.2.0.1.0 database running on HP9000. When I try to connect to it via SQLPLUS, I get ORA - 12541 No Listener.
    I did a lsnrctl start and I get the following errors

    LSNRCTL for HPUX: Version 9.2.0.1.0 - Production on 14-OCT-2004 13:15:08
    /u01/app/oracle/product/9.2.0/network/admin >
    Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)) )
    TNS-12541: TNS:no listener
    TNS-12560: TNSrotocol adapter error
    TNS-00511: No listener
    HPUX Error: 239: Connection refused
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST= IP address)(PORT=1521
    )))
    TNS-12541: TNS:no listener
    TNS-12560: TNSrotocol adapter error
    TNS-00511: No listener
    HPUX Error: 239: Connection refused

    What do I need to do? It it a permissions problem?? The reason why I am suspecting this is because it used to work before and also I get the HPUX Error 239: Connection refused message.

    Please help. I am new to UNIX so I need to know what to do if it is a permissions issue.

    Thanks
    Last edited by desta; 10-14-04 at 17:54.

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    post your tnsnames.ora and listener.ora and the database you want to connect to.

    also, run a : ps -ef | grep tnslsnr

    this might show you various listeners running on the machine (or at least verify that none are running)
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  3. #3
    Join Date
    Oct 2004
    Posts
    3
    The_Duck,

    Thank you for getting back to me. I run ps -ef | grep tnslsnr and it shows that there no listeners running.

    here is the tnsnames

    /u01/app/oracle/product/9.2.0/network/admin >more tnsnames.ora
    # tnsnames.ora Network Configuration File: /etc/tnsnames.ora
    # Generated by Oracle configuration tools.

    demo1 =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (COMMUNITY = ais_tcpcom.world)(PROTOCOL = TCP)(Host = IP Address)(Port = 1521))
    )
    (CONNECT_DATA =
    (SID = prod1)
    (GLOBAL_NAME = demo1.world)
    )
    )

    mil_1 =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (COMMUNITY = ais_tcpcom.world)(PROTOCOL = TCP)(Host = IP address)(Port = 1521))
    )
    (CONNECT_DATA =
    (SID = asi_e1)
    (GLOBAL_NAME = mil_1.world)
    )
    )

    and here is the listener.ora


    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = IP address)(PORT = 1521))
    )
    )
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = /u01/app/oracle/product/9.2.0)
    (PROGRAM = extproc)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = demo1.ny.wisc.pvt)
    (ORACLE_HOME = /u01/app/oracle/product/9.2.0)
    (SID_NAME = demo1)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = mil_1.ny.wisc.pvt)
    (ORACLE_HOME = /u01/app/oracle/product/9.2.0)
    (SID_NAME = mil_1)
    )
    )


    Thanks

  4. #4
    Join Date
    Aug 2004
    Location
    France
    Posts
    754
    Hello,

    I've looked at the listener.ora documentation, and I don't see any mention to DESCRIPTION_LIST or ADDRESS_LIST in the listener DESCRIPTION. I suggest you removed them :
    Code:
    LISTENER =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    (ADDRESS = (PROTOCOL = TCP)(HOST = IP address)(PORT = 1521)))
    Hope that helps,

    Regards,

    RBARAER

  5. #5
    Join Date
    Jul 2003
    Posts
    2,296
    try the below for both files (backup your old ones first).
    be sure to put in your machines IP address where indicated.

    tnsnames:
    PHP Code:
    demo1 =
    (
    description =
        (
    address_list =
            (
    address = (protocol tcp
                       (
    host /* put your machines IP here */
                       (
    port 1521))
        )
        (
    connect_data = (sid demo1))
    )

    mil_1 =
    (
    description =
        (
    address_list =
            (
    address = (protocol tcp
                       (
    host /* put your machines IP here */
                       (
    port 1521))
        )
        (
    connect_data = (sid mil_1))

    listener:
    PHP Code:
    MY_LISTENER =
       (
    ADDRESS_LIST =
          (
    ADDRESS = (PROTOCOL TCP)
                     (
    HOST /* put your machines IP here */)
                     (
    PORT 1521))
          )
       )
    SID_LIST_MY_LISTENER =
       (
    SID_LIST =
          (
    SID_DESC = (ORACLE_HOME = /u01/app/oracle/product/9.2.0) (SID_NAME demo1))
          (
    SID_DESC = (ORACLE_HOME = /u01/app/oracle/product/9.2.0) (SID_NAME mil_1))
       ) 
    then issue:
    lsnrctl start my_listener
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

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