4 Replies Latest reply: Oct 15, 2013 7:07 AM by AjithPathiyil RSS

    Rac listener

    user10890219

      Hi all experts,

      We are in 11gr2 in windows 2008. Our database is 2-nodes rac. My EM 12c showing that  one of the listener is down but i checked ehe status by crs and LSNRCTL command , it shows that the listener is up. Please let me know what is going on and how i could resolve the issue. I appreciate your help.

        • 1. Re: Rac listener
          gottikere

          Restart the agent and check.

           

          If the restart agent did not work , than try to reload the agent .

           

          $emctl status agent

          $emctl start agent

          $emctl reload agent

           

          Thanks,

          http://gssdba.wordpress.com

          • 2. Re: Rac listener
            Anar Godjaev

            HI,

            can you please run this command :

            $emctl status agent

            $emctl start agent

            $emctl reload agent

            Otherwise

            emca -deconfig dbcontrol db -repos drop   ----(EM drop )

            emca -config dbcontrol db -repos create  ---- (EM create )

             

            For example:

            emca -deconfig dbcontrol db -repos drop

            STARTED EMCA at Nov 29, 2011 9:16:31 AM

            EM Configuration Assistant, Version 11.2.0.0.2 Production Copyright (c) 2003, 2005, Oracle.  All rights reserved.

            Enter the following information:

            Database SID: TEST11GR2

            Listener port number: 1521

            Password for SYS user:

            Password for SYSMAN user:

            ———————————————————————- WARNING : While repository is dropped the database will be put in quiesce mode. ———————————————————————-

            Do you wish to continue? [yes(Y)/no(N)]: y

            Nov 29, 2011 9:16:53 AM oracle.sysman.emcp.EMConfig perform

            INFO: This operation is being logged at

            /oracle/cfgtoollogs/emca/TEST11GR2/emca_2011_11_29_09_16_30.log.

            Nov 29, 2011 9:16:53 AM oracle.sysman.emcp.util.DBControlUtil stopOMS

            INFO: Stopping Database Control (this may take a while) …

            Nov 29, 2011 9:16:55 AM oracle.sysman.emcp.EMReposConfig invoke

            INFO: Dropping the EM repository (this may take a while) …

            Nov 29, 2011 9:19:15 AM oracle.sysman.emcp.EMReposConfig invoke

            INFO: Repository successfully dropped Enterprise Manager configuration completed successfully FINISHED EMCA at Nov 29, 2011 9:19:18 AM

            anar/oracle/ora11gR2> emca -config dbcontrol db -repos create

            STARTED EMCA at Nov 29, 2011 9:19:25 AM

            EM Configuration Assistant, Version 11.2.0.0.2 Production Copyright (c) 2003, 2005, Oracle.  All rights reserved.

            Enter the following information:

            Database SID: TEST11GR2

            Listener port number: 1521

            Listener ORACLE_HOME [ /oracle/ora11gR2 ]:

            Password for SYS user:

            Password for DBSNMP user:

            Password for SYSMAN user:

            Email address for notifications (optional):

            Outgoing Mail (SMTP) server for notifications (optional):

            —————————————————————–

            You have specified the following settings

            Database ORACLE_HOME ……………. /oracle/ora11gR2

            Local hostname ……………. dbanar

            Listener ORACLE_HOME ……………. /oracle/ora11gR2

            Listener port number ……………. 1521

            Database SID ……………. TEST11GR2

            Email address for notifications ……………

            Outgoing Mail (SMTP) server for notifications ……………

            —————————————————————–

            Do you wish to continue? [yes(Y)/no(N)]: y

            Nov 29, 2011 9:19:46 AM oracle.sysman.emcp.EMConfig perform

            INFO: This operation is being logged at

            /oracle/cfgtoollogs/emca/TEST11GR2/emca_2011_11_29_09_19_24.log.

            Nov 29, 2011 9:19:47 AM oracle.sysman.emcp.EMReposConfig createRepository

            INFO: Creating the EM repository (this may take a while) …

            Nov 29, 2011 9:26:16 AM oracle.sysman.emcp.EMReposConfig invoke

            INFO: Repository successfully created

            Nov 29, 2011 9:26:22 AM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository

            INFO: Uploading configuration data to EM repository (this may take a while) …

            Nov 29, 2011 9:27:19 AM oracle.sysman.emcp.EMReposConfig invoke

            INFO: Uploaded configuration data successfully

            Nov 29, 2011 9:27:21 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole

            INFO: Securing Database Control (this may take a while) …

            Nov 29, 2011 9:27:31 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole

            INFO: Database Control secured successfully.

            Nov 29, 2011 9:27:31 AM oracle.sysman.emcp.util.DBControlUtil startOMS

            INFO: Starting Database Control (this may take a while) …

            Nov 29, 2011 9:28:09 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration

            INFO: Database Control started successfully

            Nov 29, 2011 9:28:09 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration

            INFO: >>>>>>>>>>> The Database Control URL is https://dbanar:1158/em <<<<<<<<<<<

            Nov 29, 2011 9:28:13 AM oracle.sysman.emcp.EMDBPostConfig invoke

            WARNING:

            ************************  WARNING  ************************

            Management Repository has been placed in secure mode wherein Enterprise Manager data will be encrypted.  The encryption key has been placed in th file:

            /oracle/ora11gR2/dbanar_TEST11GR2/sysman/config/emkey.ora. Ensure this file is backed up as the encrypted data will becom unusable if this file is lost.

            ***********************************************************

            Enterprise Manager configuration completed successfully

            FINISHED EMCA at Nov 29, 2011 9:28:13 AM

            anar /oracle/ora11gR2> emctl status dbconsole

            Oracle Enterprise Manager 11g Database Control Release 11.2.0.2.0

            Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.https://dbanar:1158/em/console/aboutApplication

            Oracle Enterprise Manager 11g is running. ——————————————————————

            Logs are generated in directory /oracle/ora11gR2/dbanar_TEST11GR2/sysman/log anar /oracle/ora11gR2>

             

            ANd please check again listener status

             

            Thank you

            • 3. Re: Rac listener
              Simo Kemppinen

              Hi,

               

              Are you talking about local listener or SCAN-listener? At least Grid Control (EM) might sometimes give false alarms about SCAN-listeners because these listeners can be in any node of the cluster.

              So if you are getting alerts about the SCAN-listener then check that the listener is running (and where it is running) with following command:

              srvctl status scan_listener

               

              And it is also wise to test that that SCAN-IP is accepting connections. You can do this for example with telnet (this just open connection if it is working (says Connected to IP ...)):

              telnet <IP> 1521

               

              If the connection is working and usually IP is in different node than where the error comes then you can safely ignore the alert (mark it as acknowledged in EM).

              • 4. Re: Rac listener
                AjithPathiyil

                Hi,

                 

                Check if the listener is started from DB_HOME, If yes, stop it and start it again from GRID_HOME, and do a EM agent bounce.