Filesystem usage

dcli -l oracle -g ~/dba_groups df -h | grep -E '([8-9][0-9]|100)%' | column  -t > filtered_log_file.txt

Comments

Post a Comment

Popular posts from this blog

Checklist

  Here’s a short 5-point version you can show your manager: Maintain a CSV list of migrated databases with hostname, CDB name, and migration date. Load this CSV into a repository staging table using SQL*Loader, skip duplicates, and log any already-present entries. Check OEM onboarding by querying MGMT$TARGET_PROPERTIES for each migrated database. Check CMDB onboarding by querying CMDB_TAB in the repository database. Generate a YES/NO status report for OEM & CMDB onboarding and schedule the process to run periodically.
Read more

Check2

 #!/bin/bash export ORACLE_SID=<your_cdb_sid> export ORAENV_ASK=NO . oraenv > /dev/null 2>&1 LOG_DIR=/tmp/post_migration_check mkdir -p "$LOG_DIR" LOGFILE="$LOG_DIR/post_migration_check_$(date +%Y%m%d_%H%M%S).log" exec_sql() { sqlplus -s "/ as sysdba" <<EOF set pages 100 lines 200 feedback off heading on echo off col name for a20 col open_mode for a20 col restricted for a15 col object_type for a20 col object_name for a40 col owner for a20 col comp_name for a35 col status for a15 col wallet_status for a20 col tablespace_name for a30 col encrypted for a10 col activating_pdbname for a25 $1 exit EOF } check_flag() {   if grep -iq "$2" <<< "$1"; then     echo "$3 : PASSED" | tee -a $LOGFILE   else     echo "$3 : NOT PASSED" | tee -a $LOGFILE   fi } echo "=== Post Migration Certification Checks ===" | tee -a $LOGFILE # ASM SID detection ASM_SID=$(ps -ef | grep pmon | grep ASM | grep...
Read more

Exadata Topics

 EXA DBA+ OCI Senior Specialist Design implement and manage Exadata Cloud Service ExaCS database solutions Develop and maintain database architecture strategies to support business goals Lead the migration and integration of databases across multicloud database environments including Oracle Cloud AWS Azure and Google Cloud Ensure high availability scalability and performance of database systems Collaborate with crossfunctional teams to define and implement database solutions that meet business requirements Handson experience with migrating large database to Exadata ExaCS ExaCC platform Expereince with migrating database to ATPADW Design Database consolidation and reduce OPEX spending Provide technical leadership and mentorship to junior database architects and administrators Conduct performance tuning capacity planning and security assessments Stay updated with the latest advancements in database technologies and cloud offerings Implement and manage Exadata X9 hardware including pe...
Read more