RMAN Backup Script

 #!/bin/bash

# Source the Oracle environment
if [ -f ~/.bash_profile ]; then
  source ~/.bash_profile
fi

LOG_FILE="/home/oraprod/backup_PRODCDB_${DATE}.log"
BACKUP_DIR="/backup/"

# Create the backup directory if it doesn't exist
mkdir -p ${BACKUP_DIR}

# Run RMAN commands directly
${ORACLE_HOME}/bin/rman target / log=${LOG_FILE} <<EOF
run {
  allocate channel d1 type disk;
  allocate channel d2 type disk;
  allocate channel d3 type disk;
  
  # Database backup
  backup AS COMPRESSED BACKUPSET format '${BACKUP_DIR}/PRODCDB_bu_db_%d_t%t_s%s_p%p' database;
  
  # Archive logs
  sql 'alter system archive log current';
  sql 'alter system archive log current';
  sql 'alter system archive log current';
  sql 'alter system archive log current';
  sql 'alter system archive log current';
  
  backup AS COMPRESSED BACKUPSET format '${BACKUP_DIR}/PRODCDB_bu_al_t%t_s%s_p%p' archivelog all skip inaccessible delete input;
  
  # Controlfile backup
  backup format '${BACKUP_DIR}/PRODCDB_control%U' current controlfile;
  
  # Release channels
  release channel d1;
  release channel d2;
  release channel d3;
  
  # Crosscheck backup
  allocate channel d1 type disk;
  crosscheck backup;
  release channel d1;
}
EOF

# Check if the backup succeeded
if [ $? -eq 0 ]; then
  echo "RMAN backup completed successfully. Backup files are stored in ${BACKUP_DIR}."
else
  echo "RMAN backup failed. Check the log file: ${LOG_FILE}" >&2
  exit 1
fi

Getting Error while login to WebLogic Console Oracle Application R12 (12.2.14)

Getting Error while login to WebLogic Console Oracle Application R12 (12.2)

The Server is not able to service this request: [Socket:000445]Connection rejected, filter blocked Socket, weblogic.security.net.FilterException: [Security:090220]rule 2

 

Issue:
The error I encountered is related to a feature in WebLogic known as a connection filter. This mechanism provides network-layer access control, enabling the server to block unwanted communication based on various criteria.

Solution:

We need to update the connection filter value to 'allow' in the config.xml file located in the $EBS_DOMAIN_HOME/config folder

 

[applprod@cloner12 ~]$ cd $EBS_DOMAIN_HOME/config

[applprod@cloner12 config]$ ls -l config.xml

-rw-r----- 1 applprod dba 55688 Jun 18 22:37 config.xml

[applprod@cloner12 config]$ grep connection-filter config.xml

    <connection-filter>oracle.apps.ad.tools.configuration.wls.filter.EBSConnectionFilterImpl</connection-filter>

    <connection-filter-rule>cloner12.githesh.com * * allow</connection-filter-rule>

    <connection-filter-rule>0.0.0.0/0 * * deny</connection-filter-rule>

 

Backup the config.xml

 

[applprod@cloner12 config]$ cp -rf  config.xml  config.xml_bk

And change the value from deny to allow

 

[applprod@cloner12 config]$ sed -i 's/<connection-filter-rule>0\.0\.0\.0\/0 \* \* deny<\/connection-filter-rule>/<connection-filter-rule>0.0.0.0\/0 * * allow<\/connection-filter-rule>/' config.xml

[applprod@cloner12 config]$ grep connection-filter config.xml

    <connection-filter>oracle.apps.ad.tools.configuration.wls.filter.EBSConnectionFilterImpl</connection-filter>

    <connection-filter-rule>cloner12.githesh.com * * allow</connection-filter-rule>

    <connection-filter-rule>0.0.0.0/0 * * allow</connection-filter-rule>

 

 

Stop and Start the admin server

[applprod@cloner12 config]$ cd $ADMIN_SCRIPTS_HOME

[applprod@cloner12 scripts]$ ./adadminsrvctl.sh stop

[applprod@cloner12 scripts]$ ./adadminsrvctl.sh start

 

WebLogic Console