6 Replies Latest reply: Oct 8, 2012 7:14 AM by Ecimen RSS

    Problem With Listener

    Ecimen
      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
          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
            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
              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
                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
                  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
                    Thank you.