insert_pdb() { echo "Running PDB onboarding..." | tee -a "$LOGFILE" TGT_TYPE="Pluggable Database" HOST_NAME=$(hostname -f) for ENV_FILE in /home/oracle/*.env; do source "${ENV_FILE}" if [[ -z "$ORACLE_SID" || -z "$ORACLE_HOME" ]]; then echo "Environment variables not set in $ENV_FILE. Skipping..." | tee -a "$LOGFILE" continue fi # Verify if the CDB is running DB_STATUS=$(ps -ef | grep "[p]mon_${ORACLE_SID}" | wc -l) if [[ "$DB_STATUS" -eq 0 ]]; then echo "CDB $ORACLE_SID is not running. Skipping..." | tee -a "$LOGFILE" continue fi echo "Processing CDB: $ORACLE_SID" | tee -a "$LOGFILE" # Fetch PDBs in NORMAL status PDBS=$(sqlplus -s / as sysdba <<EOF SET HEAD OFF FEEDBACK OFF SELECT pdb_name FROM cdb_pdbs WHERE pdb_name != 'PDB\...
#!/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...
Comments
Post a Comment