7 Replies Latest reply: Dec 6, 2012 12:43 PM by bmill RSS

    Em 12c : RAC scan listener target status down

    782073
      i am using em control 12c and added a 2 nodes rac database system.
      grid control always shows two of scan listener targets down but actually they are not.

      srvctl status scan
      srvctl status scan_listener

      returns everything is ok. what is the problem??
        • 1. Re: Em 12c : RAC scan listener target status down
          Loc Nhan -Oracle
          Hi,

          Was the clusterware stopped recently? There is a known issue where a scan listener target show as down due to cluster master agent switch. In this case, the target's availability status should be corrected within 24 hours, or you can correct it by running the following command from the master agent:

          <Agent Home>/bin/emctl control agent runCollection <cluster target name>:cluster crs_event12g

          Regards,
          - Loc
          • 2. Re: Em 12c : RAC scan listener target status down
            894985
            what use ip ?
            public ip or vip
            • 3. Re: Em 12c : RAC scan listener target status down
              782073
              when i issue that command from gridcontrol server it says

              Oracle Enterprise Manager 12c Cloud Control 12.1.0.1.0
              Copyright (c) 1996, 2011 Oracle Corporation. All rights reserved.
              ---------------------------------------------------------------
              EMD runCollection error:
              crs_event12g:no target collection


              i really dont understand public or private ip? i added using add target manually wizard. first added the hosts and it discovered cluster, scan listeners, cluster database and database instances.
              it still shows down for 2 of scan listeners. but one is up for grid control.
              • 4. Re: Em 12c : RAC scan listener target status down
                Loc Nhan -Oracle
                Regarding the problem with running the "emctl control agent" command, can you verify that the cluster target is monitored by the agent and the target name specified in the command line is correct. You can check this from the console or by running the "emctl config agent listtargets" on the agent host.

                Also, try to see what differences between the listener that shows as up and the 2 listeners that show as down. Are the 3 listeners monitored by the same agent?
                • 5. Re: Em 12c : RAC scan listener target status down
                  782073
                  [oracle@rac01 agent_inst]$ ./bin/emctl config agent listtargets
                  Oracle Enterprise Manager 12c Cloud Control 12.1.0.1.0
                  Copyright (c) 1996, 2011 Oracle Corporation. All rights reserved.
                  [rac01, host]
                  [rac01:3872, oracle_emd]
                  [agent12g1_3_rac01, oracle_home]
                  [LISTENER_SCAN1_rac-cluster, oracle_listener]
                  [LISTENER_rac01, oracle_listener]
                  [Ora11g_gridinfrahome1_1_rac01, oracle_home]
                  [has_rac01, has]
                  [rac_cluster, cluster]
                  [crac_orcl_orcl1, oracle_database]
                  [+ASM_rac-cluster, osm_cluster]
                  [+ASM1_rac01, osm_instance]
                  [rac_orcl, rac_database]
                  [OraDb11g_home1_2_rac01, oracle_home]




                  [oracle@rac02 agent_inst]$ ./bin/emctl config agent listtargets
                  Oracle Enterprise Manager 12c Cloud Control 12.1.0.1.0
                  Copyright (c) 1996, 2011 Oracle Corporation. All rights reserved.
                  [rac02, host]
                  [rac02:3872, oracle_emd]
                  [agent12g1_3_rac02, oracle_home]
                  [has_rac02, has]
                  [rac_cluster, cluster]
                  [rac_orcl_orcl2, oracle_database]
                  [LISTENER_SCAN2_rac-cluster, oracle_listener]
                  [LISTENER_rac02, oracle_listener]
                  [+ASM2_rac02, osm_instance]
                  [+ASM_rac-cluster, osm_cluster]
                  [rac_orcl, rac_database]
                  [LISTENER_SCAN3_rac-cluster, oracle_listener]
                  [OraDb11g_home1_2_rac02, oracle_home]
                  [Ora11g_gridinfrahome1_1_rac02, oracle_home]


                  there is no significant difference.. i think.

                  GC shows LISTENER_SCAN2 and LISTENER_SCAN3 is down, and LISTENER_SCAN1 is up.

                  Edited by: user12154354 on 27.Şub.2012 10:14
                  • 6. Re: Em 12c : RAC scan listener target status down
                    Loc Nhan -Oracle
                    Please run command "srvctl status scan_listener" to verify that the SCAN listeners are running on the hosts shown in the output of the "emctl config agent listtargets". That is, LISTENER_SCAN1 on host rac01 and the other 2 SCAN listeners on host rac02.

                    If the host names match:
                    - For each of the down listeners:
                    - Navigate to the listener homepage > Target Setup > Monitoring Configuration
                    - Verify that the monitoring configuration for the down listeners are correct

                    If the host names don't match:
                    - Go to the cluster homepage, then click the View All Properties link to find out on what host the master agent is.
                    - Go the master agent's host
                    - Run command "emctl control agent runCollection rac_cluster:cluster crs_event12g"
                    • 7. Re: Em 12c : RAC scan listener target status down
                      bmill
                      This update was clearly explained and helped me resolve a similar issue I was having. Thank you!