We've been using blackouts more and more to prevent tickets being raised when we do maintenance work - as we tend to work more from the command line than from the cloud control gui we wanted to find an easy way to do this.
The first issue we had was trying to find a list of the targets that are actually monitored by the agent - this is easy enough in the GI but how do you just get a list of targets from the command line - looking at the command help there doesn't seem to be anything listed that does that?
After a lot of digging i finally found it (oh and make sure for all of this use use emctl from the agent home and not the db home otherwise you end up running database control commands)
So to get a list of targets you run this:
emctl config agent listtargets
This produces output similar to below
Oracle Enterprise Manager Cloud Control 12c Release 4
Copyright (c) 1996, 2014 Oracle Corporation. All rights reserved.
[server, host]
[agent12c2_2_server, oracle_home]
[server:3872, oracle_emd]
[DB4, oracle_database]
[OraDb11g_home112031_1_server, oracle_home]
[DB3, oracle_database]
[LISTENER_DB1_1521_server, oracle_listener]
[DB2, oracle_database]
[OraDb11g_home11204_22_server, oracle_home]
[OraHome18_23_server, oracle_home]
[DB1, oracle_database]
[agent12c1_24_server, oracle_home]
SO now we have all the info we need to start a blackout just for one of those targets - so as an example if we want to blackout DB1 for 30 days we say
emctl start blackout test DB1:oracle_database -d 30
which then says
Oracle Enterprise Manager Cloud Control 12c Release 4
Copyright (c) 1996, 2014 Oracle Corporation. All rights reserved.
Blackout test added successfully
EMD reload completed successfully
So there you have it
Stopping is then just the reverse command
emctl stop blackout test
which gives
Oracle Enterprise Manager Cloud Control 12c Release 4
Copyright (c) 1996, 2014 Oracle Corporation. All rights reserved.
Blackout test stopped successfully
EMD reload completed successfully
easy!
What a breath of fresh air! Your enthusiasm and positivity are contagious. Thank you for spreading such good vibes!
ReplyDeleteTo handle blackouts in command line, Site Country redirect errors to /dev/null (e.g., command 2>/dev/null) or use a process manager like nohup to prevent interruptions (e.g., nohup command &).
ReplyDeleteNinza Host Iski madad se aap server management aur hosting issues ko asani se handle kar sakte hain, jo command line blackouts ke doraan kaam aata hai.
ReplyDelete