#!/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
DB_HEALTH_GREEN=()
DB_NOT_OK=()
WALLET_COUNT=0
WALLET_DB_LIST=()
# 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 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
echo "$DB_NAME has Data Guard lag: Transport Lag: ${LAG} seconds, Apply Lag: ${APPLY_LAG} seconds."
DB_NOT_OK+=("$DB_NAME has replication lag: NOT_OK")
else
DB_HEALTH_GREEN+=("$DB_NAME DB HC green")
fi
else
DB_HEALTH_GREEN+=("$DB_NAME DB HC green")
fi
else
echo "$DB_NAME Data Guard check failed."
fi
}
# Function to check if the database is in restricted mode and primary/standby
check_db_mode() {
DB_NAME=$1
echo "Checking mode for database: $DB_NAME..."
sqlplus -s / as sysdba <<EOF > /tmp/db_mode.log
SET PAGESIZE 0 FEEDBACK OFF VERIFY OFF HEADING OFF ECHO OFF;
Select restricted, database_role from v\$pdbs, v\$database;
EXIT;
EOF
if [ $? -eq 0 ]; then
DATABASE_ROLE=$(grep -i "STANDBY" /tmp/db_mode.log)
PRIMARY_ROLE=$(grep -i "PRIMARY" /tmp/db_mode.log)
RESTRICTED=$(grep -i "YES" /tmp/db_mode.log)
if [ -n "$DATABASE_ROLE" ]; then
echo "Database $DB_NAME is a standby database."
DB_HEALTH_GREEN+=("$DB_NAME DB HC green (Standby)")
elif [ -n "$PRIMARY_ROLE" ] && [ -z "$RESTRICTED" ]; then
echo "Database $DB_NAME is in primary role and not restricted."
DB_HEALTH_GREEN+=("$DB_NAME DB HC green (Primary)")
elif [ -n "$PRIMARY_ROLE" ] && [ -n "$RESTRICTED" ]; then
echo "Database $DB_NAME is in primary role but restricted."
DB_NOT_OK+=("$DB_NAME in restricted mode: NOT_OK")
else
echo "Database $DB_NAME is not in the expected mode."
DB_NOT_OK+=("$DB_NAME not in expected mode: NOT_OK")
fi
else
echo "Failed to check database mode for $DB_NAME."
fi
}
# Function to check wallet identifiers in /u01/app/oracle/okv/
check_wallet_identifiers() {
echo "Checking for wallet identifiers in /u01/app/oracle/okv/..."
# Ensure the directory exists
if [ -d "/u01/app/oracle/okv" ]; then
# List files in /u01/app/oracle/okv/ and capture their names
WALLET_FILES=$(ls /u01/app/oracle/okv/)
if [ -n "$WALLET_FILES" ]; then
while IFS= read -r FILE; do
WALLET_COUNT=$((WALLET_COUNT + 1))
WALLET_DB_LIST+=("$FILE")
done <<< "$WALLET_FILES"
fi
else
echo "/u01/app/oracle/okv directory does not exist."
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" ] || [[ "$DB_NAME" =~ ^\+ASM ]] || [[ "$DB_NAME" == "oracon_1" ]]; 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_dgmgrl_lag "$DB_NAME"
check_db_mode "$DB_NAME"
echo "-------------------------------------------"
done < $ORATAB
# Run wallet identifier check
check_wallet_identifiers
# Print summary of wallet identifiers
echo "================== SUMMARY =================="
# Check wallet count and output result
if [ "$WALLET_COUNT" -gt 0 ]; then
echo "Action required: $WALLET_COUNT databases found with wallet configured."
echo "Databases with wallets:"
for wallet_db in "${WALLET_DB_LIST[@]}"; do
echo "$wallet_db"
done
else
echo "No wallet-configured databases found."
fi
# Print databases that have any issues (NOT_OK)
if [ ${#DB_NOT_OK[@]} -eq 0 ]; then
echo "All databases passed the health check."
else
echo "Databases with issues:"
for db in "${DB_NOT_OK[@]}"; do
echo "$db"
done
fi
# Print databases that passed all checks
echo "================== HEALTH CHECK =================="
if [ ${#DB_HEALTH_GREEN[@]} -eq 0 ]; then
echo "No databases passed the health check."
else
for db in "${DB_HEALTH_GREEN[@]}"; do
echo "$db"
done
fi
echo "============================================="
0 comments:
Post a Comment