deployment pre patch

 #!/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 paths in the script files

sed -i "s|GI_NEW|/u01/app/19.22.0.0/grid|g" "$SCRIPT_LOCATION/script1.sh"

sed -i "s|19C_NEW|/u01/app/oracle/product/19.22.0.0/$DBHOME_NUMBER|g" "$SCRIPT_LOCATION/script1.sh"

sed -i "s|12C_NEW|/u01/app/oracle/product/12.1.0.2.240116/$DBHOME_NUMBER|g" "$SCRIPT_LOCATION/script1.sh"

sed -i "s|116_NEW|/u01/app/oracle/product/11.2.0.4.240116/$DBHOME_NUMBER|g" "$SCRIPT_LOCATION/script1.sh"


sed -i "s|GI_CURRENT|/u01/app/19.19.0.0/grid|g" "$SCRIPT_LOCATION/script2.sh"

sed -i "s|19C_CURRENT|/u01/app/oracle/product/19.19.0.0/$DBHOME_NUMBER|g" "$SCRIPT_LOCATION/script2.sh"

sed -i "s|12C_CURRENT|/u01/app/oracle/product/12.1.0.2.230418/$DBHOME_NUMBER|g" "$SCRIPT_LOCATION/script2.sh"

sed -i "s|116_CURRENT|/u01/app/oracle/product/11.2.0.4.230418/$DBHOME_NUMBER|g" "$SCRIPT_LOCATION/script2.sh"


# Print confirmation

echo "Scripts and configuration files updated successfully."

echo "SCRIPT_LOCATION: $SCRIPT_LOCATION"

echo "PATCH_LOG: $PATCH_LOG"

echo "CLUSTER_NAME: $CLUSTER_NAME"

Comments

Post a Comment

Popular posts from this blog

Oratab Entries validate and add

#!/bin/bash # Ask user for log directory read -p "Enter the log directory: " log_directory log_directory=$(realpath "$log_directory") # Ask user for file2 (sop.conf) name read -p "Enter the name of sop.conf file: " file2_name file2_path="$log_directory/$file2_name" # Phase 1: Generate db_unique_name_version.log for SID in $(ps -ef | grep '[o]ra_smon' | awk '{print $NF}' | cut -d '_' -f3); do     export ORACLE_SID=$SID     source oraenv <<< "$SID"     # Get DB unique name and version using the first query     DB_UNIQUE_NAME_INFO=$(sqlplus -s / as sysdba <<EOF set feedback off set heading off SELECT d.DB_UNIQUE_NAME || ':' || SUBSTR(i.VERSION, 1, 2) FROM v\$database d, v\$instance i; EOF     )     # Get instance name and version using the second query     INSTANCE_NAME_INFO=$(sqlplus -s / as sysdba <<EOF set feedback off set heading off SELECT i.INSTANCE_NAME || ':' || SUBSTR(i.
Read more

Golden gate v1

 # Loop through setup_ogg files and execute ggsci commands for value in $(locate setup_ogg); do   source $value   # Extract Oracle GoldenGate home   GG_HOME=$(dirname "$value")   # Change to Oracle GoldenGate home   cd $GG_HOME   # Get information about all processes (including ABENDED)   all_processes=$(./ggsci -S <<EOF   INFO ALL   EOF   )   # Check for ABENDED processes   abended_processes=$(echo "$all_processes" | grep ABENDED)   # Display information about all processes   echo "All Processes in $GG_HOME:"   echo "$all_processes"   # Check for and report ABENDED processes   if [ -z "$abended_processes" ]; then     echo "No ABENDED processes found for $GG_HOME."   else     echo "The following processes are ABENDED for $GG_HOME:"     echo "$abended_processes"     echo "Manual Intervention is needed for the process"   fi   # Stopping running processes (excluding ABENDED)   ./ggsci -S <&l
Read more