This discussion is archived
1 2 Previous Next 21 Replies Latest reply: Jan 6, 2013 5:31 AM by EdStevens Go to original post RSS
  • 15. Re: The listener support no services
    newbieRyan Newbie
    Currently Being Moderated
    it doesn't work



    [ryan@localhost admin]$ cat listener.ora
    # listener.ora Network Configuration File: /home/ryan/app/ryan/product/11.2.0/dbhome_1/network/admin/listener.ora
    # Generated by Oracle configuration tools.

    SID_LIST_LISTENER_ORCL =
    (SID_LIST =
    (SID_DESC =
    (GLOBAL_DBNAME = orcl)
    (ORACLE_HOME = /home/ryan/app/ryan/product/11.2.0)
    (SID_NAME = EBUM6PRD)
    )
    )

    LISTENER_EBUM6PRD =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
    )
    )






    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
    )

    ADR_BASE_LISTENER = /home/ryan/app/ryan
  • 16. Re: The listener support no services
    Aman.... Oracle ACE
    Currently Being Moderated
    There is no need for doing it now and since 9i as the dynamic registration would take care. The error is not with the listener.ora as the description says clearly.

    Aman....
  • 17. Re: The listener support no services
    Aman.... Oracle ACE
    Currently Being Moderated
    What happens when you issue the below commands?
    $. oraenv
    
    <this would prompt for the SID, enter *orcl* there >
    
    $tnsping orcl 
    Show us the output and read the FAQ mentioned on top-right to learn how to use code tag to format the output. It's difficult to read it without the formatting.

    Aman....
  • 18. Re: The listener support no services
    Aman.... Oracle ACE
    Currently Being Moderated
    What happens when you issue the below commands?
    $. oraenv
    
    <this would prompt for the SID, enter *orcl* there >
    
    $tnsping orcl 
    Show us the output and read the FAQ mentioned on top-right to learn how to use code tag to format the output. It's difficult to read it without the formatting.

    Aman....
  • 19. Re: The listener support no services
    newbieRyan Newbie
    Currently Being Moderated
    I did a ps -e check, how come there is no Oracle process except tnslsnr
  • 20. Re: The listener support no services
    newbieRyan Newbie
    Currently Being Moderated
    [ryan@localhost bin]$ ./oraenv
    ORACLE_SID = [ryan] ? orcl
    The Oracle base for ORACLE_HOME=/home/ryan/app/ryan/product/11.2.0/dbhome_1 is /home/ryan/app/ryan
    [ryan@localhost bin]$ ./tnsping0 orcl

    TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 06-JAN-2013 14:43:58

    Copyright (c) 1997, 2009, Oracle. All rights reserved.

    Used parameter files:
    /home/ryan/app/ryan/product/11.2.0/dbhome_1/network/admin/sqlnet.ora


    Used TNSNAMES adapter to resolve the alias
    Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))
    OK (0 msec)



    Thank you all
  • 21. Re: The listener support no services
    EdStevens Guru
    Currently Being Moderated
    newbieRyan wrote:
    it doesn't work



    [ryan@localhost admin]$ cat listener.ora
    # listener.ora Network Configuration File: /home/ryan/app/ryan/product/11.2.0/dbhome_1/network/admin/listener.ora
    # Generated by Oracle configuration tools.

    SID_LIST_LISTENER_ORCL =
    you are defining a sid list for a listerner named 'LISTENER_ORCL', but you don't define a listener by that name.
    (SID_LIST =
    (SID_DESC =
    (GLOBAL_DBNAME = orcl)
    (ORACLE_HOME = /home/ryan/app/ryan/product/11.2.0)
    (SID_NAME = EBUM6PRD)
    )
    )

    LISTENER_EBUM6PRD =
    Here you are defining a listener named 'LISTENER_EBUM6PRD'
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    defining it with a host name of 'localhost' guarantees this listener will receive/accept a request from any remote client.
    )
    )
    )






    LISTENER =
    And now you are defining another listener named 'LISTENER'
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    Again with host=localhost this listener will never accept any remote requests. And assigning it to port 1521 conflicts with the the fact that you assigned your other listener to the same port.
    )
    )

    ADR_BASE_LISTENER = /home/ryan/app/ryan
    One single listener, with the deault name of LISTENER, using the default port of 1521, is quite capable of - indeed WAS DESIGNED TO -- service multiple database instances of multiple versions running from multiple homes. Your listener.ora file indicates you still have some profound misunderstandings of how tns works.

    I suggest you read the following:
    http://edstevensdba.wordpress.com/2011/02/09/sqlnet_overview/ (Help! I can’t connect to my database )
    http://edstevensdba.wordpress.com/2011/02/16/sqlnet_client_cfg/ (Help! I can’t connect to my database (part duex) )
    http://edstevensdba.wordpress.com/2011/02/26/ora-12154tns-03505/
    http://edstevensdba.wordpress.com/2011/03/19/ora-12514/
    http://edstevensdba.wordpress.com/2011/03/05/ora-12545/
    http://edstevensdba.wordpress.com/2011/02/27/tnsping-101/
    http://edstevensdba.wordpress.com/2011/07/30/exploring-the-local_listener-parameter/
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points