This discussion is archived
1 2 Previous Next 18 Replies Latest reply: Feb 23, 2009 3:20 AM by bitchingbob RSS

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

yvesthib Newbie
Currently Being Moderated
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 Pro
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Pro
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Pro
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Pro
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Pro
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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

Legend

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