1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Oracle 11gR2 - The listener supports no services

Discussion in 'Server Administration and Options' started by Benjamin, Jul 21, 2014.

  1. Benjamin

    Benjamin Active Member

    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    55
    Hi all,

    I installed Oracle Database 11gR2 as well as Oracle Grid Infrastructure on a linux box, then I created the orcl database.

    I have always been able to connect to my database using sqlplus or oem. But lately, I'm facing an issue when typing the command lsnrctl status, and so I'm not able to connect to the database.

    My listener.ora file:


    # listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/grid/network/admin/listener.ora
    # Generated by Oracle configuration tools.
    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = pc.company.com)(PORT = 1521))
    )
    )
    ADR_BASE_LISTENER = /u01/app/oracle



    My tnsnames.ora file :

    # tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
    # Generated by Oracle configuration tools.

    ORCL =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = pc.company.com)(PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = orcl.example.com)
    )
    )



    When typing lsnrctl status, I get the following :



    LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 21-JUL-2014 03:35:48

    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 21-JUL-2014 03:25:58
    Uptime 0 days 0 hr. 9 min. 50 sec
    Trace Level off
    Security ON: Local OS Authentication
    SNMP OFF
    Listener Log File /u01/app/oracle/diag/tnslsnr/pc151/listener/alert/log.xml
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=pc.company.com)(PORT=1521)))
    The listener supports no services
    The command completed successfully



    Thanks in advance.
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,351
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    You are certain the service name for your database is orcl.example.com? You need to verify that before you complain about the 'error' the listener is reporting. It isn't an error, it's a statement that the database hasn't registered with the listener. Is the hostname you have in the listener.ora file found in the /etc/hosts file? I seriously doubt it since the output from 'lsnrctl status' shows this:


    Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))


    You need to put that entry into /etc/hosts so the address can be resolved locally. Once it can connect to the address it can connect to the listener and your 'problem' may go away.


    There is more to installing Oracle than simply running the installer.