1 2 Previous Next 18 Replies Latest reply: Feb 23, 2009 5:20 AM by bitchingbob RSS

    How to remove manually a blackout added with the agent (command emctl) ?

    yvesthib
      Hi,

      Does anybody know how to remove "manually" (without using the GUI of EM) a blackout added with the following command (added by the agent):

      D:\logiciels\Oracle\agent10g\BIN> emctl start blackout <blackout name> ...


      I know I can remove it using the EM Grid but I would like to remove it in a script.

      Thank's
        • 1. Re: How to remove manually a blackout added with the agent (command emctl) ?
          Bobcatalog
          I know I can remove it using the EM Grid but I would like to remove it in a script.
          Blackout Usage :
          emctl start blackout <Blackoutname> [-nodeLevel] [<Target_name>[:<Target_Type>]].... [-d <Duration>]
          emctl stop blackout <Blackoutname>
          emctl status blackout [<Target_name>[:<Target_Type>]]....
          • 2. Re: How to remove manually a blackout added with the agent (command emctl) ?
            yvesthib
            Hi,

            I know those commands but none of them let me remove (delete) the blackout added by the emctl commands ...

            Thank's
            • 3. Re: How to remove manually a blackout added with the agent (command emctl) ?
              Bobcatalog
              Do you get any errors?

              What is the status of the blackout?
              emctl status blackout [<Target_name>[:<Target_Type>]]....
              Edited by: Bobcatalog on Feb 13, 2009 3:58 PM
              • 4. Re: How to remove manually a blackout added with the agent (command emctl) ?
                yvesthib
                OK,

                I put here all of my test (I put the command I did in bold text):

                D:\logiciels\Oracle\agent10g\BIN>emctl start blackout test_black DEV1_TRACB:oracle_database -d 00:05
                Oracle Enterprise Manager 10g Release 3 Grid Control 10.2.0.3.0.
                Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
                Blackout test_black added successfully
                EMD reload completed successfully

                D:\logiciels\Oracle\agent10g\BIN>emctl status blackout DEV1_TRACB:oracle_database
                Oracle Enterprise Manager 10g Release 3 Grid Control 10.2.0.3.0.
                Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
                Blackoutname = Blackout dÚploiement massif Hot fix Windows
                Targets = (DEV1_TRACB:oracle_database,)
                Time = ({2008-4-26|23:45:0|64800 Sec,|} )
                Expired = True

                Blackoutname = Blackout Hot Fix Windows
                Targets = (DEV1_TRACB:oracle_database,)
                Time = ({2008-11-2|3:0:0|54000 Sec,|} )
                Expired = True

                Blackoutname = Blackout RMAN HEBDO
                Targets = (DEV1_TRACB:oracle_database,)
                Time = ({2009-2-8|23:15:0|28800 Sec,|} )
                Expired = True

                Blackoutname = Blackout backup semaine
                Targets = (DEV1_TRACB:oracle_database,)
                Time = ({2008-9-4|23:30:0|27000 Sec,|} )
                Expired = True

                Blackoutname = Blackout Hot Fix Windows 14-15 juin 2008
                Targets = (DEV1_TRACB:oracle_database,)
                Time = ({2008-6-14|6:0:0|136800 Sec,|} )
                Expired = True

                Blackoutname = Blackout DÚploiement Hot Fix Windows
                Targets = (DEV1_TRACB:oracle_database,)
                Time = ({2009-1-25|4:0:0|50400 Sec,|} )
                Expired = True

                Blackoutname = Blackout EXPORT
                Targets = (DEV1_TRACB:oracle_database,)
                Time = ({2009-2-13|23:15:0|28800 Sec,|} )
                Expired = True

                Blackoutname = Blackout BD pour hot fix Windows
                Targets = (DEV1_TRACB:oracle_database,)
                Time = ({2008-8-23|8:0:0|28800 Sec,|} )
                Expired = True

                Blackoutname = Blackout Windows Patch maintenance prise 2
                Targets = (DEV1_TRACB:oracle_database,)
                Time = ({2008-3-16|11:22:46|39600 Sec,|} )
                Expired = True

                Blackoutname = Blackout RMAN
                Targets = (DEV1_TRACB:oracle_database,)
                Time = ({2008-9-7|23:15:0|28800 Sec,|} )
                Expired = True

                Blackoutname = Blackout Hebdo RMAN
                Targets = (DEV1_TRACB:oracle_database,)
                Time = ({2008-9-21|23:30:0|28800 Sec,|} )
                Expired = True

                Blackoutname = test_black
                Targets = (DEV1_TRACB:oracle_database,)
                Time = ({2009-02-14|09:20:46|5 Min,|} )
                Expired = False

                Blackoutname = Blackout ALL BD
                Targets = (DEV1_TRACB:oracle_database,)
                Time = ({2008-2-24|9:4:8|36000 Sec,|} )
                Expired = True

                Blackoutname = Blackout EXPORT la semaine
                Targets = (DEV1_TRACB:oracle_database,)
                Time = ({2008-9-23|23:15:0|30600 Sec,|} )
                Expired = True

                Blackoutname = Blackou Hebdo Backup RMAN
                Targets = (DEV1_TRACB:oracle_database,)
                Time = ({2008-4-27|8:30:0|26100 Sec,|} )
                Expired = True

                Blackoutname = Blackout Hebdo EXPORT
                Targets = (DEV1_TRACB:oracle_database,)
                Time = ({2008-9-24|23:15:0|28800 Sec,|} )
                Expired = True

                Blackoutname = Blackout SGBDD09
                Targets = (DEV1_TRACB:oracle_database,)
                Time = ({2008-3-11|12:10:4|1196 Sec,|} )
                Expired = True

                Blackoutname = Blackout EXPORT sur semaine
                Targets = (DEV1_TRACB:oracle_database,)
                Time = ({2008-1-16|23:30:0|27000 Sec,|} )
                Expired = True

                Blackoutname = Blackout Maintenance Techno
                Targets = (DEV1_TRACB:oracle_database,)
                Time = ({2008-11-23|4:0:0|54000 Sec,|} )
                Expired = True


                D:\logiciels\Oracle\agent10g\BIN>emctl stop blackout test_black
                Oracle Enterprise Manager 10g Release 3 Grid Control 10.2.0.3.0.
                Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
                Blackout test_black stopped successfully
                EMD reload completed successfully

                D:\logiciels\Oracle\agent10g\BIN>emctl status blackout DEV1_TRACB:oracle_database
                Oracle Enterprise Manager 10g Release 3 Grid Control 10.2.0.3.0.
                Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
                Blackoutname = Blackout dÚploiement massif Hot fix Windows
                Targets = (DEV1_TRACB:oracle_database,)
                Time = ({2008-4-26|23:45:0|64800 Sec,|} )
                Expired = True

                Blackoutname = Blackout Hot Fix Windows
                Targets = (DEV1_TRACB:oracle_database,)
                Time = ({2008-11-2|3:0:0|54000 Sec,|} )
                Expired = True

                Blackoutname = Blackout RMAN HEBDO
                Targets = (DEV1_TRACB:oracle_database,)
                Time = ({2009-2-8|23:15:0|28800 Sec,|} )
                Expired = True

                Blackoutname = Blackout backup semaine
                Targets = (DEV1_TRACB:oracle_database,)
                Time = ({2008-9-4|23:30:0|27000 Sec,|} )
                Expired = True

                Blackoutname = Blackout Hot Fix Windows 14-15 juin 2008
                Targets = (DEV1_TRACB:oracle_database,)
                Time = ({2008-6-14|6:0:0|136800 Sec,|} )
                Expired = True

                Blackoutname = Blackout DÚploiement Hot Fix Windows
                Targets = (DEV1_TRACB:oracle_database,)
                Time = ({2009-1-25|4:0:0|50400 Sec,|} )
                Expired = True

                Blackoutname = Blackout EXPORT
                Targets = (DEV1_TRACB:oracle_database,)
                Time = ({2009-2-13|23:15:0|28800 Sec,|} )
                Expired = True

                Blackoutname = Blackout BD pour hot fix Windows
                Targets = (DEV1_TRACB:oracle_database,)
                Time = ({2008-8-23|8:0:0|28800 Sec,|} )
                Expired = True

                Blackoutname = Blackout Windows Patch maintenance prise 2
                Targets = (DEV1_TRACB:oracle_database,)
                Time = ({2008-3-16|11:22:46|39600 Sec,|} )
                Expired = True

                Blackoutname = Blackout RMAN
                Targets = (DEV1_TRACB:oracle_database,)
                Time = ({2008-9-7|23:15:0|28800 Sec,|} )
                Expired = True

                Blackoutname = Blackout Hebdo RMAN
                Targets = (DEV1_TRACB:oracle_database,)
                Time = ({2008-9-21|23:30:0|28800 Sec,|} )
                Expired = True

                Blackoutname = Blackout ALL BD
                Targets = (DEV1_TRACB:oracle_database,)
                Time = ({2008-2-24|9:4:8|36000 Sec,|} )
                Expired = True

                Blackoutname = Blackout EXPORT la semaine
                Targets = (DEV1_TRACB:oracle_database,)
                Time = ({2008-9-23|23:15:0|30600 Sec,|} )
                Expired = True

                Blackoutname = Blackou Hebdo Backup RMAN
                Targets = (DEV1_TRACB:oracle_database,)
                Time = ({2008-4-27|8:30:0|26100 Sec,|} )
                Expired = True

                Blackoutname = Blackout Hebdo EXPORT
                Targets = (DEV1_TRACB:oracle_database,)
                Time = ({2008-9-24|23:15:0|28800 Sec,|} )
                Expired = True

                Blackoutname = Blackout SGBDD09
                Targets = (DEV1_TRACB:oracle_database,)
                Time = ({2008-3-11|12:10:4|1196 Sec,|} )
                Expired = True

                Blackoutname = Blackout EXPORT sur semaine
                Targets = (DEV1_TRACB:oracle_database,)
                Time = ({2008-1-16|23:30:0|27000 Sec,|} )
                Expired = True

                Blackoutname = Blackout Maintenance Techno
                Targets = (DEV1_TRACB:oracle_database,)
                Time = ({2008-11-23|4:0:0|54000 Sec,|} )
                Expired = True

                D:\logiciels\Oracle\agent10g\BIN>

                Now, with emclt status, I don't see the blackout "test_black" but I can't see it in the GUI of the EM GRID with the status "Ended".

                Now, how I can remove it with a command line like "emctl" (not by EM Grid) ?

                Thank's
                • 5. Re: How to remove manually a blackout added with the agent (command emctl) ?
                  Bobcatalog
                  Now, with emclt status, I don't see the blackout "test_black" but I can't see it in the GUI of the EM GRID with the status "Ended".
                  Did you mean,You can still see the blackout in the console with status "Failed" ?

                  If that's not the case, then you issue is fixed.
                  Now, how I can remove it with a command line like "emctl" (not by EM Grid) ?
                  check this..

                  Problem: EM Shows a Blackout as Being 'Active' Despite Being Stopped at Management Agent side
                  https://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=286270.1
                  • 6. Re: How to remove manually a blackout added with the agent (command emctl) ?
                    mnazim-Oracle
                    Now, how I can remove it with a command line like "emctl" (not by EM Grid) ?
                    emctl stop blackout <Blackoutname>
                    • 7. Re: How to remove manually a blackout added with the agent (command emctl) ?
                      mnazim-Oracle
                      If don't work can u paste whats the exact error it thrown
                      • 8. Re: How to remove manually a blackout added with the agent (command emctl) ?
                        yvesthib
                        Hi,

                        No, I mean I can still see the blackout in the console (EM Grid) but with the status "*Ended*" (not failed). I just want that the blackout don't appear in my GRID. I know I can't delete it directly in the GRID but I try to do it by a script (prompt command lile "emctl"). Maybe it's not possible...

                        If I made a "emctl status blackout ...", the blackout don't appear. It seems OK.

                        I looked at the link you sent but it's not my case. I didn't have error when I stopped the blackout.

                        Thank's
                        • 9. Re: How to remove manually a blackout added with the agent (command emctl) ?
                          Bobcatalog
                          I know I can't delete it directly in the GRID
                          This will be available in 11g.
                          Maybe it's not possible...
                          could be. I'm not sure if this is the expected behaviour.
                          Can you try recreating the blackout with the same name and try stopping it again.
                          • 10. Re: How to remove manually a blackout added with the agent (command emctl) ?
                            mnazim-Oracle
                            I got your point. Right now you can't removing the blackout via emctl and the only way is to delete from GUI.
                            • 11. Re: How to remove manually a blackout added with the agent (command emctl) ?
                              yvesthib
                              Yes, You got it! This is exactly what I want.

                              Thank's
                              • 12. Re: How to remove manually a blackout added with the agent (command emctl) ?
                                yvesthib
                                Hi,

                                Yes, I can start it again ...

                                D:\logiciels\Oracle\agent10g\BIN&gt;*emctl start blackout test_black DEV1_TRACB:oracle_database -d 00:05*
                                Oracle Enterprise Manager 10g Release 3 Grid Control 10.2.0.3.0.
                                Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
                                Blackout test_black added successfully
                                EMD reload completed successfully

                                D:\logiciels\Oracle\agent10g\BIN&gt;

                                ... and I'm able to stop too ...

                                D:\logiciels\Oracle\agent10g\BIN&gt;*emctl stop blackout test_black*
                                Oracle Enterprise Manager 10g Release 3 Grid Control 10.2.0.3.0.
                                Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
                                Blackout test_black stopped successfully

                                D:\logiciels\Oracle\agent10g\BIN&gt;

                                So, It seems that I can start a blackout with a name that already exist (I'm a bit surprise about that). It fixed partially my problem ... So I can still see the blackout "*test_black*" in the GUI of EM Grid with the status "*Ended*" ...
                                • 13. Re: How to remove manually a blackout added with the agent (command emctl) ?
                                  Bobcatalog
                                  This is expected.

                                  Are you using "emcli" to create the blackouts?

                                  Edited by: Bobcatalog on Feb 16, 2009 9:56 AM
                                  • 14. Re: How to remove manually a blackout added with the agent (command emctl) ?
                                    yvesthib
                                    No,

                                    I am using emctl (I don't know about "*emcli*" and anyway, it doesn't exist on Windows Oracle 32 bits, 10.2.0.3).
                                    1 2 Previous Next