a1

 #!/bin/bash

# Define the path to oratab

ORATAB="/etc/oratab"

# Check if oratab exists

if [ ! -f $ORATAB ]; then

    echo "$ORATAB not found. Exiting."

    exit 1

fi

DB_STATUS_FILE="/tmp/db_status.log"

GGSCI_PATH="/usr/local/bin/ggsci"  # Modify this to your GoldenGate installation path

LAG_THRESHOLD=0  # Set your lag threshold in seconds (0 for no lag allowed)

# Arrays to hold summary information

WALLET_ISSUES=()

DATAGUARD_LAG_ISSUES=()

DB_HEALTH_GREEN=()

# Function to set Oracle environment for a specific database

set_oracle_env() {

    DB_NAME=$1

    ORACLE_HOME=$2

    export ORACLE_HOME=$ORACLE_HOME

    export ORACLE_SID=$DB_NAME

    export PATH=$ORACLE_HOME/bin:$PATH

    echo "Set environment for database: $DB_NAME with ORACLE_HOME: $ORACLE_HOME"

}

# Function to check if a database is up and running

check_db_status() {

    DB_NAME=$1

    echo "Checking status for database: $DB_NAME..."

    ps -ef | grep pmon | grep $DB_NAME | grep -v grep > $DB_STATUS_FILE

    if [ -s $DB_STATUS_FILE ]; then

        echo "Database $DB_NAME is up and running."

    else

        echo "Database $DB_NAME is down."

    fi

}

# Function to check databases with wallets

check_wallets() {

    DB_NAME=$1

    echo "Checking for wallet for database $DB_NAME..."

    WALLET_COUNT=$(ls -ltr /u01/app/oracle/okv 2>/dev/null | grep -v total | wc -l)

    

    if [ $WALLET_COUNT -gt 0 ]; then

        WALLET_ISSUES+=("$DB_NAME has a wallet.")

    fi

}

# Function to perform Data Guard checks with dgmgrl, including lag

check_dgmgrl_lag() {

    DB_NAME=$1

    echo "Performing Data Guard checks for $DB_NAME..."

    dgmgrl <<EOF > /tmp/dg_status.log

    connect /;

    show configuration;

    exit;

EOF

    if [ $? -eq 0 ]; then

        echo "Data Guard configuration checked for $DB_NAME."

        # Checking for lag

        LAG_INFO=$(dgmgrl <<EOF

        connect /;

        show database verbose primary;

        exit;

EOF

        )

        echo "$LAG_INFO" | grep 'Transport lag\|Apply lag' > /tmp/dg_lag.log

        if grep -q "seconds" /tmp/dg_lag.log; then

            LAG=$(grep 'Transport lag' /tmp/dg_lag.log | awk '{print $NF}' | sed 's/[seconds|second]//')

            APPLY_LAG=$(grep 'Apply lag' /tmp/dg_lag.log | awk '{print $NF}' | sed 's/[seconds|second]//')

            if [ "$LAG" -gt $LAG_THRESHOLD ] || [ "$APPLY_LAG" -gt $LAG_THRESHOLD ]; then

                DATAGUARD_LAG_ISSUES+=("$DB_NAME has Data Guard lag: Transport Lag: ${LAG} seconds, Apply Lag: ${APPLY_LAG} seconds.")

            else

                DB_HEALTH_GREEN+=("$DB_NAME DB HC green")

            fi

        else

            DB_HEALTH_GREEN+=("$DB_NAME DB HC green")

        fi

    else

        DATAGUARD_LAG_ISSUES+=("$DB_NAME Data Guard check failed.")

    fi

}

# Read oratab and loop through each database

while IFS=: read -r DB_NAME ORACLE_HOME DB_STARTUP_FLAG; do

    # Skip comments and entries with no ORACLE_HOME

    if [[ "$DB_NAME" =~ ^# ]] || [ -z "$ORACLE_HOME" ]; then

        continue

    fi

    # Set the Oracle environment for each database

    set_oracle_env "$DB_NAME" "$ORACLE_HOME"

    # Run checks for each database

    check_db_status "$DB_NAME"

    check_wallets "$DB_NAME"

    check_dgmgrl_lag "$DB_NAME"

    echo "-------------------------------------------"

done < $ORATAB

# Print summary of wallet and Data Guard lag issues

echo "================== SUMMARY =================="

if [ ${#WALLET_ISSUES[@]} -eq 0 ] && [ ${#DATAGUARD_LAG_ISSUES[@]} -eq 0 ]; then

    echo "All databases passed the health check."

else

    echo "Wallet Issues:"

    for issue in "${WALLET_ISSUES[@]}"; do

        echo "$issue"

    done

    echo "Data Guard Lag Issues:"

    for issue in "${DATAGUARD_LAG_ISSUES[@]}"; do

        echo "$issue"

    done

fi

# Print databases that passed all checks

echo "Databases with DB HC green:"

for db in "${DB_HEALTH_GREEN[@]}"; do

    echo "$db"

done

echo "============================================="