1 2 Previous Next 21 Replies Latest reply: Jan 6, 2013 7:31 AM by EdStevens RSS

    The listener support no services

    newbieRyan
      hello all,

      I just installed Oracle 11g r2 on linux x64
      after installation, i went to sqldeveloper to test the connection. it worked, so i shutdown the box.
      now, i turned on the box. I opened sqldeveloper to create a new account.
      it return an error ORA-12514
      I checked lsnrctl status, it said no services.
      what should i do to get the database running again?


      LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 06-JAN-2013 12:06:49

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

      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
      STATUS of the LISTENER
      ------------------------
      Alias LISTENER
      Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
      Start Date 06-JAN-2013 20:04:58
      Uptime 496 days 18 hr. 29 min. 44 sec
      Trace Level off
      Security ON: Local OS Authentication
      SNMP OFF
      Listener Parameter File /home/ryan/app/ryan/product/11.2.0/dbhome_1/network/admin/listener.ora
      Listener Log File /home/ryan/app/ryan/diag/tnslsnr/localhost/listener/alert/log.xml
      Listening Endpoints Summary...
      (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
      The listener supports no services
      The command completed successfully
        • 1. Re: The listener support no services
          sb92075
          newbieRyan wrote:
          hello all,

          I just installed Oracle 11g r2 on linux x64
          after installation, i went to sqldeveloper to test the connection. it worked, so i shutdown the box.
          now, i turned on the box. I opened sqldeveloper to create a new account.
          it return an error ORA-12514
          I checked lsnrctl status, it said no services.
          what should i do to get the database running again?
          I suspect that the DB has not bee started.
          open a Terminal Window & type line for line as below

          id
          env | sort
          sqlplus
          / as sysdba
          startup

          COPY the results from commands above then PASTE all results back here

          >
          >
          LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 06-JAN-2013 12:06:49

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

          Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
          STATUS of the LISTENER
          ------------------------
          Alias LISTENER
          Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
          Start Date 06-JAN-2013 20:04:58
          Uptime 496 days 18 hr. 29 min. 44 sec
          Trace Level off
          Security ON: Local OS Authentication
          SNMP OFF
          Listener Parameter File /home/ryan/app/ryan/product/11.2.0/dbhome_1/network/admin/listener.ora
          Listener Log File /home/ryan/app/ryan/diag/tnslsnr/localhost/listener/alert/log.xml
          Listening Endpoints Summary...
          (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
          (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
          The listener supports no services
          The command completed successfully
          • 2. Re: The listener support no services
            newbieRyan
            where does the sqlplus reside?
            • 3. Re: The listener support no services
              sb92075
              newbieRyan wrote:
              where does the sqlplus reside?
              /home/ryan/app/ryan/product/11.2.0/dbhome_1/bin/
              • 4. Re: The listener support no services
                newbieRyan
                [root@localhost bin]# clear;./sqlplus / as sysdba

                SQL*Plus: Release 11.2.0.1.0 Production on Sun Jan 6 13:32:21 2013

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

                ERROR:
                ORA-12162: TNS:net service name is incorrectly specified


                Enter user-name:
                • 5. Re: The listener support no services
                  sb92075
                  newbieRyan wrote:
                  [root@localhost bin]# clear;./sqlplus / as sysdba
                  NEVER operate against Oracle DB as OS user "root"!
                  • 6. Re: The listener support no services
                    newbieRyan
                    it the same as run as ryan.

                    [ryan@localhost bin]$ ./sqlplus / as sysdba

                    SQL*Plus: Release 11.2.0.1.0 Production on Sun Jan 6 13:48:48 2013

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

                    ERROR:
                    ORA-12162: TNS:net service name is incorrectly specified


                    Enter user-name:
                    • 7. Re: The listener support no services
                      Aman....
                      This is what the error message says,
                      ORA-12162:
                      TNS:net service name is incorrectly specified
                      Cause:      The connect descriptor corresponding to the net service name in TNSNAMES.ORA or in the directory server (Oracle Internet Directory) is incorrectly specified.
                      Action:      If using local naming make sure there are no syntax errors in the corresponding connect descriptor in the TNSNAMES.ORA file. If using directory naming check the information provided through the administration used for directory naming.
                      So can you post here your tnsnames.ora file? It would be under the $ORACLE_HOME/network/admin folder.

                      Aman....
                      • 8. Re: The listener support no services
                        newbieRyan
                        # tnsnames.ora Network Configuration File: /home/ryan/app/ryan/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
                        # Generated by Oracle configuration tools.

                        ORCL =
                        (DESCRIPTION =
                        (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
                        (CONNECT_DATA =
                        (SERVER = DEDICATED)
                        (SERVICE_NAME = orcl)
                        )
                        )
                        • 9. Re: The listener support no services
                          moreajays
                          Hi,

                          Register your oracle service to listener like below in listener.ora
                          SID_LIST_LISTENER_EBUM6PRD =
                            (SID_LIST =
                                 (SID_DESC =
                                (GLOBAL_DBNAME = EBUM6PRD)
                                (ORACLE_HOME = /corpm6-oracle9i/product/9.2.0)
                                (SID_NAME = EBUM6PRD)
                              )
                            )
                          
                          LISTENER_EBUM6PRD =
                            (DESCRIPTION_LIST =
                              (DESCRIPTION =
                                (ADDRESS_LIST =
                                  (ADDRESS = (PROTOCOL = TCP)(HOST = M6EBU-DB)(PORT = 1521))
                                )
                              )
                            )
                          Thanks,
                          Ajay More
                          http://moreajays.blogspot.com
                          • 10. Re: The listener support no services
                            moreajays
                            Hi,

                            Register your oracle service to listener like below in listener.ora
                            SID_LIST_LISTENER_EBUM6PRD =
                              (SID_LIST =
                                   (SID_DESC =
                                  (GLOBAL_DBNAME = EBUM6PRD)
                                  (ORACLE_HOME = /corpm6-oracle9i/product/9.2.0)
                                  (SID_NAME = EBUM6PRD)
                                )
                              )
                            
                            LISTENER_EBUM6PRD =
                              (DESCRIPTION_LIST =
                                (DESCRIPTION =
                                  (ADDRESS_LIST =
                                    (ADDRESS = (PROTOCOL = TCP)(HOST = M6EBU-DB)(PORT = 1521))
                                  )
                                )
                              )
                            Thanks,
                            Ajay More
                            http://moreajays.blogspot.com
                            • 11. Re: The listener support no services
                              moreajays
                              Hi,

                              Register your oracle service to listener like below in listener.ora
                              SID_LIST_LISTENER_EBUM6PRD =
                                (SID_LIST =
                                     (SID_DESC =
                                    (GLOBAL_DBNAME = EBUM6PRD)
                                    (ORACLE_HOME = /corpm6-oracle9i/product/9.2.0)
                                    (SID_NAME = EBUM6PRD)
                                  )
                                )
                              
                              LISTENER_EBUM6PRD =
                                (DESCRIPTION_LIST =
                                  (DESCRIPTION =
                                    (ADDRESS_LIST =
                                      (ADDRESS = (PROTOCOL = TCP)(HOST = M6EBU-DB)(PORT = 1521))
                                    )
                                  )
                                )
                              Thanks,
                              Ajay More
                              http://moreajays.blogspot.com
                              • 12. Re: The listener support no services
                                moreajays
                                Hi,

                                Register your oracle service to listener like below in listener.ora
                                SID_LIST_LISTENER_EBUM6PRD =
                                  (SID_LIST =
                                       (SID_DESC =
                                      (GLOBAL_DBNAME = EBUM6PRD)
                                      (ORACLE_HOME = /corpm6-oracle9i/product/9.2.0)
                                      (SID_NAME = EBUM6PRD)
                                    )
                                  )
                                
                                LISTENER_EBUM6PRD =
                                  (DESCRIPTION_LIST =
                                    (DESCRIPTION =
                                      (ADDRESS_LIST =
                                        (ADDRESS = (PROTOCOL = TCP)(HOST = M6EBU-DB)(PORT = 1521))
                                      )
                                    )
                                  )
                                Thanks,
                                Ajay More
                                http://moreajays.blogspot.com
                                • 13. Re: The listener support no services
                                  moreajays
                                  Hi,

                                  Register your oracle service to listener like below in listener.ora
                                  SID_LIST_LISTENER_EBUM6PRD =
                                    (SID_LIST =
                                         (SID_DESC =
                                        (GLOBAL_DBNAME = EBUM6PRD)
                                        (ORACLE_HOME = /corpm6-oracle9i/product/9.2.0)
                                        (SID_NAME = EBUM6PRD)
                                      )
                                    )
                                  
                                  LISTENER_EBUM6PRD =
                                    (DESCRIPTION_LIST =
                                      (DESCRIPTION =
                                        (ADDRESS_LIST =
                                          (ADDRESS = (PROTOCOL = TCP)(HOST = M6EBU-DB)(PORT = 1521))
                                        )
                                      )
                                    )
                                  Thanks,
                                  Ajay More
                                  http://moreajays.blogspot.com
                                  • 14. Re: The listener support no services
                                    moreajays
                                    Hi,

                                    Register your oracle service to listener like below in listener.ora
                                    SID_LIST_LISTENER_EBUM6PRD =
                                      (SID_LIST =
                                           (SID_DESC =
                                          (GLOBAL_DBNAME = EBUM6PRD)
                                          (ORACLE_HOME = /corpm6-oracle9i/product/9.2.0)
                                          (SID_NAME = EBUM6PRD)
                                        )
                                      )
                                    
                                    LISTENER_EBUM6PRD =
                                      (DESCRIPTION_LIST =
                                        (DESCRIPTION =
                                          (ADDRESS_LIST =
                                            (ADDRESS = (PROTOCOL = TCP)(HOST = M6EBU-DB)(PORT = 1521))
                                          )
                                        )
                                      )
                                    Thanks,
                                    Ajay More
                                    http://moreajays.blogspot.com
                                    1 2 Previous Next