Posts

scan

#!/bin/ksh # # fs_clone Log Scanner and Analyzer for Solaris # Purpose: Automate scanning and analysis of fs_clone operation logs # # Configuration LOG_DIR="/var/adm/fs_clone" REPORT_DIR="/var/adm/reports/fs_clone" ARCHIVE_DIR="/var/adm/archive/fs_clone" ALERT_EMAIL="admin@example.com" RETENTION_DAYS=90 # Create directories if they don't exist mkdir -p "$REPORT_DIR" "$ARCHIVE_DIR" # Timestamp for report TIMESTAMP=$(date '+%Y%m%d_%H%M%S') REPORT_FILE="$REPORT_DIR/fs_clone_analysis_$TIMESTAMP.txt" # Initialize report exec > >(tee -a "$REPORT_FILE") exec 2>&1 echo "==========================================" echo "fs_clone Log Analysis Report" echo "Generated: $(date '+%Y-%m-%d %H:%M:%S')" echo "==========================================" echo # Function to analyze log file analyze_log() {     local logfile="$1"     echo "A...
Post a Comment
Read more

From Manual to Masterful: 25 Essential Prompts for Leading a Winning Oracle DBA Automation Project

Image
From Manual to Masterful: 25 Essential Prompts for Leading a Winning Oracle DBA Automation Project From Manual to Masterful: 25 Prompts for Leading a Winning Oracle DBA Automation Project Oracle DBA Automation Team Leadership DevOps In the world of Oracle Database Administration, the pressure is always on. We're expected to ensure peak performance, guarantee uptime, and maintain Fort Knox-level security, all while managing increasingly complex environments. The only way to thrive is to automate. But building a robust sui...
Post a Comment
Read more

Automating CPU Load Monitoring for Oracle EBS on Solaris

  Automating CPU Load Monitoring for Oracle EBS on Solaris . 1 The Challenge: High CPU Load in Oracle EBS . 1 The Solution: A Robust Bash Script . 2 Script Overview .. 2 The Script . 2 How It Works . 6 Addressing the “Failed to Generate prstat Report” Error . 7 Setup Instructions . 7 Debugging Issues . 8 Conclusion . 9   Automating CPU Load Monitoring for Oracle EBS on Solaris As an Oracle E-Business Suite (EBS) DBA, managing high database server load is a critical task to ensure system performance and stability in a 24x7 environment. High CPU usage can stem from resource-intensive Oracle processes, concurrent managers, or user sessions, and identifying the culprits is key to optimizing performance. In this post, we’ll explore a Bash script that automates the monitoring of top CPU-consuming processes on a Solaris server, maps their process IDs (PIDs) to Oracle session IDs (SIDs), retrieves session details and SQL text, and sends the results in a...
Post a Comment
Read more