OEM blackout create

#!/bin/bash


# Get ASM SID

export ORACLE_SID=$(ps -ef | grep '[a]sm_smon.*+ASM' | awk '{print $NF}' | cut -d '_' -f3)

source oraenv <<< "$ORACLE_SID"


# Get cluster nodes

CLUSTER_NODES=$(olsnodes | tr '\n' ',' | sed 's/,$//')


# Dynamic time input

read -p "Enter start time (YYYY-MM-DD HH:MM): " start_time

read -p "Enter duration (HH:MM): " duration


# Transform cluster nodes into required format

TARGETS=$(echo $CLUSTER_NODES | tr ',' '\n' | awk '{print $1".x.com:host;"}' | tr -d ' ')


# Set blackout name

BLACKOUT_NAME="Test_NotificationBlackout_xxxx"


# Set blackout reason

BLACKOUT_REASON="Database Patch/Maintenance"


# Construct the EMCLI command

emcli_cmd="/emcli create_blackout -name=\"$BLACKOUT_NAME\" -reason=\"$BLACKOUT_REASON\" -add_targets=\"$TARGETS\" -schedule=\"frequency:once;start_time:$start_time;duration:$duration;tzinfo:target;tzoffset:1\""


# Print EMCLI command

echo "Executing EMCLI command: $emcli_cmd"


# Execute the EMCLI command with error handling

if $emcli_cmd; then

  echo "Blackout creation completed."

else

  echo "Error: EMCLI command failed."

fi



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

#!/bin/bash


# Ensure script safety with strict error handling

set -e


# Dynamic time input

read -p "Enter cluster_name (frame_cluser): " cluster_name

read -p "Enter start time (YYYY-MM-DD HH:MM): " start_time

read -p "Enter duration (HH:MM): " duration


# Set blackout name dynamically

BLACKOUT_NAME="NotificationBlackout_$cluster_name"


# Set blackout reason

BLACKOUT_REASON="Database Patch/Maintenance"


# Construct targets based on cluster name (assuming cluster-wide blackout)

TARGETS="$cluster_name:cluster"


# Construct the EMCLI command

emcli_cmd="./emcli create_blackout -name=\"$BLACKOUT_NAME\" -reason=\"$BLACKOUT_REASON\" -add_targets=\"$TARGETS\" -schedule=\"frequency:once; start_time:$start_time; duration:$duration; tzinfo:target; tzoffset:1\""


# Print EMCLI command

echo "Executing EMCLI command: $emcli_cmd"


# Execute the EMCLI command (missing in the original code)

$emcli_cmd || echo "Error: EMCLI command failed."


# Post-patching commands (replace hardcoded name with dynamic variable)

emcli_cmd_stop_blackout="./emcli stop_blackout -name=\"$BLACKOUT_NAME\""

emcli_cmd_delete_blackout="./emcli delete_blackout -name=\"$BLACKOUT_NAME\""


# Execute the post-patching commands (missing in the original code)

$emcli_cmd_stop_blackout || echo "Error: EMCLI stop_blackout command failed."

$emcli_cmd_delete_blackout || echo "Error: EMCLI delete_blackout command failed."


Comments

Post a Comment

Popular posts from this blog

SQL Loader V3

Create the Configuration File (config.cfg):Create a file named config.cfg with the following content. Adjust the values to match your environment:[database] username=your_username password=your_password database=your_database [files] csv_file=/path/to/your/file.csv log_file=/path/to/your/log_file.log inserted_rows_file=/path/to/your/inserted_rows.log updated_rows_file=/path/to/your/updated_rows.log ********** #!/bin/bash # Load configuration source config.cfg # Variables CSV_FILE=$csv_file USERNAME=$username PASSWORD=$password DATABASE=$database MASTER_TABLE="master_table" CHILD_TABLE="child_table" LOG_FILE=$log_file INSERTED_ROWS_FILE=$inserted_rows_file UPDATED_ROWS_FILE=$updated_rows_file # Logging function log() {   echo "$(date +'%Y-%m-%d %H:%M:%S') $1" >> $LOG_FILE } log "Starting data load process." # SQL Loader Control File for child table CONTROL_FILE="control_file.ctl" # Create control file for child table cat ...
Read more

Db Unix

-- Insert new records into master table INSERT INTO $master_table (     parent,     parent_sys_class_name,     child_sys_class_name,     child_u_cmdb_ci_used_for,     parent_correlation_id,     type,     child_correlation_id,     child,     modified_date ) SELECT     c.parent,     c.parent_sys_class_name,     c.child_sys_class_name,     c.child_u_cmdb_ci_used_for,     c.parent_correlation_id,     c.type,     c.child_correlation_id,     c.child,     c.modified_date FROM $child_table c LEFT JOIN $master_table m ON c.child_correlation_id = m.child_correlation_id WHERE m.child_correlation_id IS NULL; -- Log inserted rows SPOOL $inserted_rows_file SELECT     c.parent,     c.parent_sys_class_name,     c.child_sys_class_name,     c.child_u_cmdb_ci_used_for,     c.pare...
Read more

Standby redo log add

********* #!/bin/bash # Function to run SQL*Plus commands run_sql() {     sqlplus -s / as sysdba <<EOF     SET HEADING OFF FEEDBACK OFF VERIFY OFF ECHO OFF     $1     EXIT EOF } # Get the max group, max thread, and max size from the v$log and v$logfile views redo_info=$(run_sql "SELECT MAX(l.group#), MAX(l.thread#), MAX(l.bytes/1024/1024)  FROM v\$log l, v\$logfile f  WHERE f.group# = l.group#;") # Extract the max group, max thread, and max size values max_group=$(echo "$redo_info" | awk '{print $1}') max_thread=$(echo "$redo_info" | awk '{print $2}') max_size=$(echo "$redo_info" | awk '{print $3}') # Get the number of redo groups per thread groups_per_thread=$(run_sql "SELECT COUNT(DISTINCT group#) FROM v\$log WHERE thread#=1;") # Get the recovery file destination reco_dest=$(run_sql "SHOW PARAMETER db_recovery_file_dest") reco_dest=$(echo "$reco_dest" | awk 'NR==2 {print $3}' |...
Read more