Create pfile v1

 #!/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 location

mv "$NEW_FOLDER" "$BACKUP_FOLDER"


echo "Pfiles created successfully in $BACKUP_FOLDER."

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