This discussion is archived
1 2 Previous Next 21 Replies Latest reply: Jan 6, 2013 5:31 AM by EdStevens RSS

The listener support no services

newbieRyan Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    where does the sqlplus reside?
  • 3. Re: The listener support no services
    sb92075 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    [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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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.... Oracle ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    # 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 Pro
    Currently Being Moderated
    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 Pro
    Currently Being Moderated
    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 Pro
    Currently Being Moderated
    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 Pro
    Currently Being Moderated
    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 Pro
    Currently Being Moderated
    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 Pro
    Currently Being Moderated
    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

Legend

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