This discussion is archived
5 Replies Latest reply: Feb 23, 2013 9:25 AM by 802632 RSS

Listener in ORACLE GRID STANDALONE

802632 Newbie
Currently Being Moderated
Dear All,

I am getting "listener support no services oracle" in lsnrctl status services.

Can anybody provide step to database service in listener. This is standalone grid.


I am able to create a listener using netmgr utitlity where i can provide a service name .


But i want to try with local_listener parameter

this command will update the oracle restart

srvctl add listener -l LISTENER_ORCL -o /u01/app/oracle/product/11.2.0/db_orcl -p "TCP:1522/IPC:ORCL"

entry in tns

LISTENER_ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac1(PORT = 1522))
)



alter system set LOCAL_LISTENER="LISTENER_ORCL" scope=spfile;

but when i am doing lsnrctl status LISTENER_ORC it is giving no services.

Where should i mention the db name ...

Appreciate your help

Thanks,
Abdul
  • 1. Re: Listener in ORACLE GRID STANDALONE
    Sunny kichloo Expert
    Currently Being Moderated
    Try to add SID_LIST_LISTENER in listener.ora and then restart the listener and share your output.

    Check for SID_LIST_LISTENER in below mentioned link

    http://www.oracle-base.com/articles/misc/oracle-network-configuration.php


    Also do db register by below mentioned command

    SQL>alter system register;
  • 2. Re: Listener in ORACLE GRID STANDALONE
    802632 Newbie
    Currently Being Moderated
    Thanks for your reply.

    I am able to connect to database using tns when i am creating listener using netmgr.

    But here i want to connect using local_listener parameter

    i followed http://blog.yannickjaquier.com/oracle/oracle-restart-and-listener-configuration.html link.

    listener is unable to find the the database service.

    Thanks,
    AbdulMateen.
  • 3. Re: Listener in ORACLE GRID STANDALONE
    802632 Newbie
    Currently Being Moderated
    There is no sid present in listener.ora

    can any body provide sample lisetener.ora from grid standalone environment

    THanks,
    Abdul
  • 4. Re: Listener in ORACLE GRID STANDALONE
    JohnWatson Guru
    Currently Being Moderated
    >

    >
    alter system set LOCAL_LISTENER="LISTENER_ORCL" scope=spfile;

    but when i am doing lsnrctl status LISTENER_ORC it is giving no services.
    Doing this
    alter system set LOCAL_LISTENER="LISTENER_ORCL" scope=spfile;
    will not update the running database instances, only the spfile. Therefore they will not register with your new listener. You need either to re-start the instances, or run the command again with scope=both.
    --
    John Watson
    Oracle Certified Master DBA
    http://skillbuilders.com
  • 5. Re: Listener in ORACLE GRID STANDALONE
    802632 Newbie
    Currently Being Moderated
    I did this way.........................


    listener.ora
    ---------------
    MY_LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = host1.xyz.com)(PORT = 1521))
    )
    )



    tnsnames.ora
    -----------------
    MY_LISTENER =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = host1.xyz.com)(PORT = 1521))
    )




    SQL> show parameter local

    NAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------
    local_listener string MY_LISTENER
    log_archive_local_first boolean TRUE
    parallel_force_local boolean FALSE
    SQL>

    SQL> alter system register;

    System altered.

    SQL> exit



    [oracle@host1.xyz.com admin]$ lsnrctl status MY_LISTENER

    LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 23-FEB-2013 09:45:46

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

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=host1.xyz.com)(PORT=1521)))
    STATUS of the LISTENER
    ------------------------
    Alias MY_LISTENER
    Version TNSLSNR for Linux: Version 11.2.0.2.0 - Production
    Start Date 23-FEB-2013 09:44:55
    Uptime 0 days 0 hr. 0 min. 51 sec
    Trace Level off
    Security ON: Local OS Authentication
    SNMP ON
    Listener Parameter File /u01/app/oracle/product/11.2.0.2/db_1/network/admin/listener.ora
    Listener Log File /u01/app/oracle/diag/tnslsnr/host1.xyz.com/my_listener/alert/log.xml
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=host1.xyz.com)(PORT=1521)))
    Services Summary...
    Service "TESTER" has 1 instance(s).
    Instance "TESTER", status READY, has 1 handler(s) for this service...
    The command completed successfully




    $ sqlplus amateen/amateen@TESTER

    SQL*Plus: Release 11.2.0.2.0 Production on Sat Feb 23 12:20:56 2013

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


    Connected to:
    Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
    With the Partitioning and Real Application Testing options

    SQL> sho user
    USER is "AMATEEN"
    SQL>

Legend

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