Apex

 #!/bin/bash


# Check if SID is passed as an argument

if [ -z "$1" ]; then

  echo "Usage: $0 <ORACLE_SID>"

  exit 1

fi


# Set the Oracle SID dynamically

export ORACLE_SID=$1


# Source Oracle environment variables using oraenv

. /usr/local/bin/oraenv <<< "$ORACLE_SID"


# Output file for the results

OUTPUT_FILE="${ORACLE_SID}_db_info.log"


# Function to log the output to a file

log_output() {

  echo "$1" >> "$OUTPUT_FILE"

}


# Start logging process

log_output "-------------------------------------"

log_output "DB Information for $ORACLE_SID"

log_output "-------------------------------------"


# 1. DB Growth (Tablespace Size Information)

log_output "-------------------------------------"

log_output "DB Growth (Tablespace Size Information for $ORACLE_SID)"

log_output "-------------------------------------"

sqlplus -S / as sysdba <<EOF >> "$OUTPUT_FILE"

SET LINESIZE 200

SET PAGESIZE 50

SELECT tablespace_name, 

       ROUND(SUM(bytes) / 1024 / 1024 / 1024, 2) AS total_gb,

       ROUND(SUM(bytes) / 1024 / 1024 / 1024 / 1024, 2) AS used_gb

FROM dba_data_files

GROUP BY tablespace_name;

EXIT;

EOF


# 2. APEX Installed Status

log_output "-------------------------------------"

log_output "APEX Installed Status for $ORACLE_SID"

log_output "-------------------------------------"

sqlplus -S / as sysdba <<EOF >> "$OUTPUT_FILE"

SET LINESIZE 200

SET PAGESIZE 50

SELECT status FROM apex_030200.WWV_FLOW_VERSION;

EXIT;

EOF


# 3. Character Set (NLS_CHARACTERSET)

log_output "-------------------------------------"

log_output "Character Set for $ORACLE_SID"

log_output "-------------------------------------"

sqlplus -S / as sysdba <<EOF >> "$OUTPUT_FILE"

SET LINESIZE 200

SET PAGESIZE 50

SELECT value FROM nls_database_parameters WHERE parameter = 'NLS_CHARACTERSET';

EXIT;

EOF


# 4. TDE (Transparent Data Encryption) Enabled

log_output "-------------------------------------"

log_output "TDE Enabled Status for $ORACLE_SID"

log_output "-------------------------------------"

sqlplus -S / as sysdba <<EOF >> "$OUTPUT_FILE"

SET LINESIZE 200

SET PAGESIZE 50

SELECT wallet_type FROM v\$encryption_wallet;

EXIT;

EOF


# Final Message

log_output "-------------------------------------"

log_output "End of Information for $ORACLE_SID"

log_output "-------------------------------------"


echo "Output saved to $OUTPUT_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