1 2 Previous Next 21 Replies Latest reply: Jan 6, 2013 7:31 AM by EdStevens Go to original post RSS
      • 15. Re: The listener support no services
        newbieRyan
        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....
          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....
            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....
              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
                I did a ps -e check, how come there is no Oracle process except tnslsnr
                • 20. Re: The listener support no services
                  newbieRyan
                  [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
                    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