12 Replies Latest reply on Feb 17, 2012 2:00 PM by Fabricio_Jorge

    Listener Supports no services

    843238
      Hi DB Experts,

      I am new to the Oracle DB and specifically 11g.

      I have a VM Ware machine, which had Oracle DB installed.
      When I am trying to start the DB server, I get the below logs:


      LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 17-FEB-2012 01:36:53

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

      Starting /u01/app/oracle/product/11.2.0/dbhome_1//bin/tnslsnr: please wait...

      TNSLSNR for Linux: Version 11.2.0.1.0 - Production
      Log messages written to /u01/app/oracle/product/11.2.0/dbhome_1/log/diag/tnslsnr/fmw/listener/alert/log.xml
      Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=fmw)(PORT=1521)))

      Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
      STATUS of the LISTENER
      ------------------------
      Alias LISTENER
      Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
      Start Date 17-FEB-2012 01:36:54
      Uptime 0 days 0 hr. 0 min. 0 sec
      Trace Level off
      Security ON: Local OS Authentication
      SNMP OFF
      Listener Log File /u01/app/oracle/product/11.2.0/dbhome_1/log/diag/tnslsnr/fmw/listener/alert/log.xml
      Listening Endpoints Summary...
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=fmw)(PORT=1521)))
      The listener supports no services
      The command completed successfully

      SQL*Plus: Release 11.2.0.1.0 Production on Fri Feb 17 01:36:56 2012

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

      Connected to an idle instance.

      SQL> ORACLE instance started.

      Total System Global Area 534462464 bytes
      Fixed Size 2215064 bytes
      Variable Size 394265448 bytes
      Database Buffers 130023424 bytes
      Redo Buffers 7958528 bytes
      Database mounted.
      Database opened.


      Why is that message flashed - Listener supports no services and Connected to an idle instance
      Is my listener no registered with the ORACLE instance of the database?

      Please help
        • 1. Re: Listener Supports no services
          John Stegeman
          Why is that message flashed - Listener supports no services
          Because the database instance registers dynamically with the listener and you were checking before the database had started. Check after it's started.
          Connected to an idle instance
          Because the instance wasn't started yet
          • 2. Re: Listener Supports no services
            843238
            So it means, I have to start the listener after I have started the DB instance?

            Also, I tried starting DB instance using ./dbstart, but it throws the below error:

            Failed to auto-start Oracle Net Listener using ORACLE_HOME/bin/tnslsnr
            • 3. Re: Listener Supports no services
              Billy~Verreynne
              840235 wrote:

              Is my listener no registered with the ORACLE instance of the database?
              The other way around - the instance registers with the listener.

              To add to John's comments - there is nothing wrong here. Listener is running. Instance not. When instance starts, it will register itself with the listener and the listener will know about the services supported by that instance.

              The instance has a parameter called LOCAL_LISTENER. The instance uses this to determine how to contact the local listener and do the necessary registration stuff.

              When you start the instance, you can also use the command alter system register to force the registration process to run immediately.
              • 4. Re: Listener Supports no services
                Billy~Verreynne
                840235 wrote:
                So it means, I have to start the listener after I have started the DB instance?
                No.
                Also, I tried starting DB instance using ./dbstart, but it throws the below error:
                Failed to auto-start Oracle Net Listener using ORACLE_HOME/bin/tnslsnr
                That is because the dbstart script expects you to supply an ORACLE_HOME directory as parameter in order for the script to determine where to start the listener.

                No parameter. No listener started by the script.
                • 5. Re: Listener Supports no services
                  Nikolay Ivankin
                  840235 wrote:
                  So it means, I have to start the listener after I have started the DB instance?
                  No, DB will register itself while starting. This is called Dynamic registration.
                  Also you can consider Static Registration - when DB service is configured in listener.ora.
                  In this case listener will always support DB service whether it is started or not.
                  • 6. Re: Listener Supports no services
                    843238
                    Hi Billy,

                    I am trying to start the DB using the ./dbstart ORACLE_HOME
                    There are no messages flashed.

                    I could get the listener started. But still, the instance is not registered with the listener:


                    [oracle@fmw bin]$ ./dbstart /u01/app/oracle/product/11.2.0/dbhome_1
                    [oracle@fmw bin]$ ./lsnrctl status

                    LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 17-FEB-2012 02:33:28

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

                    Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
                    STATUS of the LISTENER
                    ------------------------
                    Alias LISTENER
                    Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
                    Start Date 17-FEB-2012 02:32:53
                    Uptime 0 days 0 hr. 0 min. 34 sec
                    Trace Level off
                    Security ON: Local OS Authentication
                    SNMP OFF
                    Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
                    Listener Log File /u01/app/oracle/product/11.2.0/dbhome_1/log/diag/tnslsnr/fmw/listener/alert/log.xml
                    Listening Endpoints Summary...
                    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=fmw)(PORT=1521)))
                    The listener supports no services
                    The command completed successfully
                    • 7. Re: Listener Supports no services
                      Nikolay Ivankin
                      You can force DB dynamic registration by:
                      SQL> alter system register;
                      1 person found this helpful
                      • 8. Re: Listener Supports no services
                        843238
                        The ./dbstart is not starting up the ORACLE instance:

                        SQL*Plus: Release 11.2.0.1.0 Production on Fri Feb 17 02:42:37 2012

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

                        Connected to an idle instance.

                        SQL> alter system register;
                        alter system register
                        *
                        ERROR at line 1:
                        ORA-01034: ORACLE not available
                        Process ID: 0
                        Session ID: 0 Serial number: 0


                        SQL> startup
                        ORACLE instance started.

                        Total System Global Area 534462464 bytes
                        Fixed Size 2215064 bytes
                        Variable Size 394265448 bytes
                        Database Buffers 130023424 bytes
                        Redo Buffers 7958528 bytes
                        Database mounted.
                        Database opened.
                        SQL> alter system register;

                        System altered.


                        Am I doing something wrong?
                        • 9. Re: Listener Supports no services
                          Nikolay Ivankin
                          In dynamic registration - no running DB, no supported services by listener.

                          Now if you run
                          lsnrctl status
                          you'll see your DB
                          • 10. Re: Listener Supports no services
                            Billy~Verreynne
                            840235 wrote:

                            I am trying to start the DB using the ./dbstart ORACLE_HOME
                            ORACLE_HOME needs to be the actual home directory. E.g.
                            /u01/app/oracle/product/11.2.0/dbhome_1/bin/dbstart /u01/app/oracle/product/11.2.0/dbhome_1
                            The ./dbstart is not starting up the ORACLE instance
                            Probably because +/etc/oratab+ is not configured accordingly - specifying that your instance need to be started via dbstart.
                            1 person found this helpful
                            • 11. Re: Listener Supports no services
                              EdStevens
                              840235 wrote:
                              Hi Billy,

                              I am trying to start the DB using the ./dbstart ORACLE_HOME
                              There are no messages flashed.

                              I could get the listener started. But still, the instance is not registered with the listener:
                              The instance will attempt to register itself with the listener when it (the instance) starts. If the listener is not started, it obviously cannot register with the listener.
                              The instance will register/attempt to register with the listener every minute or so (I forget the exact interval). So if the instance starts first, when the listener finally starts, it will have to wait until the next registration request from the instance before it knows about the instance.
                              >
                              [oracle@fmw bin]$ ./dbstart /u01/app/oracle/product/11.2.0/dbhome_1
                              [oracle@fmw bin]$ ./lsnrctl status

                              LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 17-FEB-2012 02:33:28

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

                              Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
                              STATUS of the LISTENER
                              ------------------------
                              Alias LISTENER
                              Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
                              Start Date 17-FEB-2012 02:32:53
                              Uptime 0 days 0 hr. 0 min. 34 sec
                              Trace Level off
                              Security ON: Local OS Authentication
                              SNMP OFF
                              Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
                              Listener Log File /u01/app/oracle/product/11.2.0/dbhome_1/log/diag/tnslsnr/fmw/listener/alert/log.xml
                              Listening Endpoints Summary...
                              (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=fmw)(PORT=1521)))
                              The listener supports no services
                              The command completed successfully
                              • 12. Re: Listener Supports no services
                                Fabricio_Jorge
                                Try setting the ORACLE_SID and restart your listener.