#!/bin/bash LOGFILE="/home/oracle/pdb_output.log" : > $LOGFILE # Clear the log file get_pdb_details() { echo "CDB_UNIQUE_NAME|PDB_NAME|CPU|SGA_MAX_SIZE_GB|SGA_TARGET_GB|PGA_GB|DB_SIZE_GB" > $LOGFILE # Iterate over each CDB for ENV_FILE in /home/oracle/*.env; do source "${ENV_FILE}" # Validate environment variables if [[ -z "$ORACLE_SID" || -z "$ORACLE_HOME" ]]; then continue fi # Check if CDB is running INSTANCE_STATUS=$(timeout 5 sqlplus -s / as sysdba <<EOF SET HEAD OFF FEEDBACK OFF SELECT instance_name FROM v\$instance WHERE status = 'OPEN'; EXIT; EOF ) if [[ -z "$INSTANCE_STATUS" ]]; then continue fi # Fetch CDB unique name CDB_UNIQUE_NAME=$(sqlplus -s / as sysdba <<EOF SET HEAD OFF FEEDBACK OFF SELECT value FROM v\$parameter WHERE name = 'db_unique_name'; EXIT; EO...
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.
Comments
Post a Comment