This discussion is archived
6 Replies Latest reply: Oct 8, 2012 5:14 AM by Ecimen RSS

Problem With Listener

Ecimen Newbie
Currently Being Moderated
Hello i have a problem with listener; i have to turn off dynamic listener registration and make it static registration... so far couldnt make it;

theres no registered listener with srvctl as you see, output of srvctl config listener
 [oracle@localhost admin]$ srvctl config listener
            PRCN-2044 : No listener exists 
and there is no listener.ora under $GRID_HOME/network/admin or $ORACLE_HOME/network/admin (i deleted listener.ora under both location ) but even if i delete listener.ora from both location when i restart listener i still see listener is up.(maybe PMON starting listener itself tried to turn off but couldnt manage it as well)

i cant connect database remotely when i startup database with nomount.lsnrctl status shows Instance "secondarydb", status BLOCKED...
[oracle@localhost grid]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 08-OCT-2012 13:25:17

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                08-OCT-2012 11:29:47
Uptime                    0 days 1 hr. 55 min. 29 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Log File         /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM", status READY, has 1 handler(s) for this service...
Service "secondarydb" has 1 instance(s).
  Instance "secondarydb", status BLOCKED, has 1 handler(s) for this service...
The command completed successfully 
  • 1. Re: Problem With Listener
    Shivananda Rao Guru
    Currently Being Moderated
    A listener does not require a listener.ora file. Oracle starts it automatically. But since static registration of the database service is required, you can create one using NETCA.

    You can stop the existing listener process, use NETCA to create a new one and later you can add the static entry to it.
  • 2. Re: Problem With Listener
    Ecimen Newbie
    Currently Being Moderated
    Hello thx for answer;

    i recreated a new listener from grid home now everthing seems ok but i have another problem i think listener is pointing to wrong location when i start listener , it should point to grid home instead of oracle home?..

    output of lsnrctl status
    [oracle@localhost admin]$ lsnrctl status
    
    LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 08-OCT-2012 14:51:06
    
    Copyright (c) 1991, 2009, Oracle.  All rights reserved.
    
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
    STATUS of the LISTENER
    ------------------------
    Alias                     LISTENER
    Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
    Start Date                08-OCT-2012 14:25:30
    Uptime                    0 days 0 hr. 25 min. 36 sec
    Trace Level               off
    Security                  ON: Local OS Authentication
    SNMP                      OFF
    Listener Parameter File   /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
    Listener Log File         /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
    Listening Endpoints Summary...
      (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.150.30.162)(PORT=1521)))
    Services Summary...
    Service "PLSExtProc" has 1 instance(s).
      Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Service "secondarydb" has 2 instance(s).
      Instance "secondarydb", status UNKNOWN, has 1 handler(s) for this service...
      Instance "secondarydb", status BLOCKED, has 1 handler(s) for this service...
    The command completed successfully
  • 3. Re: Problem With Listener
    Shivananda Rao Guru
    Currently Being Moderated
    Hi,

    By default, from 11gR2, listener would be started from the Grid Infrastructure home, but you can have it started from the Oracle Home. This is not an issue.

    If you feel that your question has been answered, then please consider closing the thread by rewarding appropriate points !!
  • 4. Re: Problem With Listener
    Ecimen Newbie
    Currently Being Moderated
    Hello again;

    do i need to add +ASM entry into listener.ora manuanlly?  asm isntance is not up...this can cause trouble later?                                                                                                                                                                                                                                                                   
  • 5. Re: Problem With Listener
    Shivananda Rao Guru
    Currently Being Moderated
    Ecimen wrote:
    Hello again;

    do i need to add +ASM entry into listener.ora manuanlly?  asm isntance is not up...this can cause trouble later?
    Not required to add the ASM entry to the listener. You need to have your ASM instance started and it registers automatically with the listener.
  • 6. Re: Problem With Listener
    Ecimen Newbie
    Currently Being Moderated
    Thank you.

Legend

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