Header

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}')

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

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 pat
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