Dba

 #!/bin/bash # Function to check GoldenGate status check_goldengate() {     if agctl status goldengate | grep -q "is running"; then         echo "GoldenGate is running."     else         echo "GoldenGate is not running."     fi } # Function to check ACFS status check_acfs() {     if acfsutil info > /dev/null 2>&1; then         echo "ACFS is up."     else         echo "ACFS is down."     fi } # Function to check EMCTL status check_emctl() {     if emctl status > /dev/null 2>&1; then         echo "EMCTL is running."     else         echo "EMCTL is not running."     fi } # Function to check if create_rp.ksh exists check_create_rp() {     if [ -f create_rp.ksh ]; then         echo "create_rp.ksh exists."     else         echo "create_rp.ksh does not exist."     fi } # Main function main() {     echo "Patching readiness check starting..."     # Task 1: Verify GoldenGate  

CONFIG_FILE=$1 PATCH_LOG=$(grep PATCH_LOG "$CONFIG_FILE" | awk -F ':' '{ print $2}') CHANGE_NUMBER=$(grep CHANGE "$CONFIG_FILE" | awk -F ':' '{ print $2}') SCRIPT_BASE=$(grep SCRIPT_BASE "$CONFIG_FILE" | awk -F ':' '{ print $2}') DBHOME_NUM_19C=$(grep 19C_NEW "$CONFIG_FILE" | awk -F ':' '{ print $2}') DBHOME_NUM_12C=$(grep 12C_NEW "$CONFIG_FILE" | awk -F ':' '{ print $2}') DBHOME_NUM_11G=$(grep 11G_NEW "$CONFIG_FILE" | awk -F ':' '{ print $2}')

 #!/bin/bash OUTPUT_DIRECTORY="$1" # Get the current timestamp CURRENT_TIMESTAMP=$(date +"%Y%m%d_%H%M%S") # Define the path for the new folder NEW_FOLDER="$OUTPUT_DIRECTORY/$CURRENT_TIMESTAMP" # Create the new folder mkdir -p "$NEW_FOLDER" # Function to create pfile create_pfile() {     local output_directory="$1"     local oracle_sid="$2"          source oraenv <<< "$oracle_sid" > /dev/null     result=$(sqlplus -S / as sysdba <<EOF create pfile='$output_directory/init_$oracle_sid.ora' from spfile; exit; EOF ) } # Loop through Oracle SIDs and create pfiles in the new folder for SID in $(ps -ef | grep '[o]ra_smon' | awk '{print $NF}' | cut -d '_' -f3); do     create_pfile "$NEW_FOLDER" "$SID" done echo "Pfiles created successfully in $NEW_FOLDER."

 #!/bin/bash OUTPUT_DIRECTORY="$1" CURRENT_TIMESTAMP=$(date +"%Y%m%d_%H%M%S") NEW_FOLDER="$OUTPUT_DIRECTORY/$CURRENT_TIMESTAMP" BACKUP_FOLDER="$OUTPUT_DIRECTORY/backup_$CURRENT_TIMESTAMP" mkdir -p "$NEW_FOLDER" create_pfile() {     local output_directory="$1"     local oracle_sid="$2"          source oraenv <<< "$oracle_sid" > /dev/null     result=$(sqlplus -S / as sysdba <<EOF create pfile='$output_directory/init_$oracle_sid.ora' from spfile; exit; EOF ) } # Loop through Oracle SIDs and create pfiles for SID in $(ps -ef | grep '[o]ra_smon' | awk '{print $NF}' | cut -d '_' -f3); do     create_pfile "$NEW_FOLDER" "$SID" done # If backup folder exists, rename it with timestamp if [ -d "$OUTPUT_DIRECTORY/backup" ]; then     mv "$OUTPUT_DIRECTORY/backup" "$BACKUP_FOLDER" fi # Move the new folder to the backup loc

 #!/bin/bash # Check if all required arguments are provided if [ "$#" -ne 5 ]; then     echo "Usage: $0 <SCRIPT_BASE> <CHANGE_NUMBER> <FRAME> <DBHOME_NUMBER> <CLUSTER_NAME>"     exit 1 fi SCRIPT_BASE=$1 CHANGE_NUMBER=$2 FRAME=$3 DBHOME_NUMBER=$4 CLUSTER_NAME=$5 # Define paths SCRIPT_LOCATION="/auto/data.misc/oracle/VAT_PATCH/19.22/PRE_INSTALL" PATCH_LOG="$SCRIPT_LOCATION/PATCH_LOG" # Create directories mkdir -p "$SCRIPT_LOCATION" "$PATCH_LOG" # Tar and extract files tar -xf /auto/data.misc/oracle/VAT_PATCH/19.22/PRE_INSTALL.tar.gz -C "$SCRIPT_LOCATION" # Update ssl jan2024.conf with provided parameters sed -i "s/CHANGE_NUMBER/$CHANGE_NUMBER/g" "$SCRIPT_LOCATION/ssl_jan2024.conf" sed -i "s/FRAME/$FRAME/g" "$SCRIPT_LOCATION/ssl_jan2024.conf" sed -i "s/DBHOME_NUMBER/$DBHOME_NUMBER/g" "$SCRIPT_LOCATION/ssl_jan2024.conf" # Update pat