Db running on nodes

#!/bin/bash


# Check if ASM SID is passed as an argument

if [ -z "$1" ]; then

  echo "Usage: $0 <ASM_SID>"

  exit 1

fi


# Set the Oracle SID (ASM) and source environment using oraenv

export ORACLE_SID=$1

export ORAENV_ASK=NO

source oraenv > /dev/null


# Define log file

LOG_FILE="exadata_db_config.log"

> "$LOG_FILE" # Clear previous log content


# Print header

echo -e "Database Unique Name | Database Instances | Configured Nodes" | tee -a "$LOG_FILE"

echo "--------------------------------------------------------------" | tee -a "$LOG_FILE"


# Get list of all databases managed by Grid Infrastructure

DB_LIST=$(srvctl config database | sort -u)


# Loop through each database and fetch required details

for DB in $DB_LIST; do

    DB_NAME=$(srvctl config database -d "$DB" | grep -i "Database unique name" | awk -F": " '{print $2}')

    INSTANCES=$(srvctl config database -d "$DB" | grep -i "Database instances" | awk -F": " '{print $2}')

    NODES=$(srvctl config database -d "$DB" | grep -i "Configured nodes" | awk -F": " '{print $2}')

    

    # Print in single-row format

    echo -e "$DB_NAME | $INSTANCES | $NODES" | tee -a "$LOG_FILE"

done


echo "--------------------------------------------------------------" | tee -a "$LOG_FILE"

echo "Database configuration check completed. Log saved in $LOG_FILE."

Comments

Post a Comment

Popular posts from this blog

Database growth

#!/bin/bash # Log file LOGFILE="db_growth_check.log" echo "Checking yearly database growth on all running Oracle databases..." > $LOGFILE echo "DATABASE_NAME | YEAR | GROWTH_GB" >> $LOGFILE echo "---------------------------------" >> $LOGFILE # Find running Oracle instances (excluding ASM and APX) ps -ef | grep pmon | grep -v grep | grep -Ev "(\+ASM|APX)" | awk -F'_' '{print $3}' | while read -r ORACLE_SID do     if [[ -n "$ORACLE_SID" ]]; then         echo "Processing database: $ORACLE_SID"         # Set Oracle environment         export ORACLE_SID=$ORACLE_SID         export ORAENV_ASK=NO         . oraenv > /dev/null 2>&1         # Run SQL query to check yearly database growth         SQL_OUTPUT=$(sqlplus -s / as sysdba <<EOF SET HEADING OFF; SET FEEDBACK OFF; SELECT '$ORACLE_SID' AS DATABASE_NAME,  ...
Read more

P2

#!/bin/bash # Ensure ORACLE_SID is passed as an argument if [[ -z "$1" ]]; then     echo "Usage: $0 <ORACLE_SID>"     exit 1 fi export ORACLE_SID=$1 export ORACLE_HOME=/u01/app/oracle/product/19c/dbhome_1 export PATH=$ORACLE_HOME/bin:$PATH SQLPLUS="$ORACLE_HOME/bin/sqlplus -s / as sysdba" # Standard password (static) STANDARD_PWD="xyxyxyxyxytsts" # Fetch cloakware password dynamically NEWPSWD=$(/path/to/pwEcho.exe $ORACLE_SID WALLET) # Function to execute SQL and get database info get_db_info() {     SQL_FILE="/tmp/sql_output.txt"     $SQLPLUS <<EOF > $SQL_FILE SET HEAD OFF FEEDBACK OFF PAGESIZE 0 LINESIZE 500 TRIMSPOOL ON WHENEVER SQLERROR EXIT SQL.SQLCODE SELECT name FROM v\$database; SELECT status FROM v\$encryption_wallet; SELECT NVL((SELECT WRL_PARAMETER FROM gv\$encryption_wallet WHERE inst_id = (SELECT INSTANCE_NUMBER FROM v\$instance)), 'NA') FROM dual; SELECT CASE WHEN COUNT(*) > 0 THEN 'YES' E...
Read more

SQL Loader V3

Create the Configuration File (config.cfg):Create a file named config.cfg with the following content. Adjust the values to match your environment:[database] username=your_username password=your_password database=your_database [files] csv_file=/path/to/your/file.csv log_file=/path/to/your/log_file.log inserted_rows_file=/path/to/your/inserted_rows.log updated_rows_file=/path/to/your/updated_rows.log ********** #!/bin/bash # Load configuration source config.cfg # Variables CSV_FILE=$csv_file USERNAME=$username PASSWORD=$password DATABASE=$database MASTER_TABLE="master_table" CHILD_TABLE="child_table" LOG_FILE=$log_file INSERTED_ROWS_FILE=$inserted_rows_file UPDATED_ROWS_FILE=$updated_rows_file # Logging function log() {   echo "$(date +'%Y-%m-%d %H:%M:%S') $1" >> $LOG_FILE } log "Starting data load process." # SQL Loader Control File for child table CONTROL_FILE="control_file.ctl" # Create control file for child table cat ...
Read more