OEM Critical Alerts:Grid Control Reports Incident (Bea-337 [Weblogicserver]) ========================================================== We can see the below errors very often in OEM screens: Incident (BEA-337 [WebLogicServer]) detected in /u03/oracle/gc_inst/user_projects/domains/GCDomain/servers/EMGC_OMS1/adr/diag/ofm/GCDomain/EMGC_OMS1/alert/log.xml AS per Oracle Support…
Read MoreLog File Location in EBS R12 Alert Log File location: $ORACLE_HOME/admin/$CONTEXT_NAME/bdump/alert_$SID.log Trace file location: $ORACLE_HOME/admin/SID_Hostname/udump Application Tier Logs Start/Stop script log files location: $COMMON_TOP/admin/log/CONTEXT_NAME/ OPMN log file location $ORACLE_HOME/opmn/logs/ipm.log Apache,…
Read More# ########### # Description: # ########### echo echo “=================================” echo “This script LOCKS database users.” echo “=================================” echo sleep 1 # ########################### # Listing Available Databases: # ########################### # Count…
Read More# ################################################# # Database COLD Backup Script. # ################################################# # ########### # Description: # ########### echo echo “===============================================” echo “This script Takes a COLD BACKUP for a database.” echo “===============================================”…
Read Morefor host in `cat ~oracle/.rhosts| cut -d”.” -f1|awk ‘{print $1}’|sort -u` do echo ” “ echo “************************” echo “$host” echo “************************” …
Read More#!/bin/bash . ~/.bash_profile mailid=’nimai.karmakar@hotmail.com’ date=`date +%Y-%m-%d” “%H:` alertlog=/rac/app/oracle/product/11.2.0/dba-scripts/logs/ioerr.log errlog=err_`date –date=”0 days ago” +_%d_%m_%y_%H_%M`.txt err1=`grep -B 2 “$date” $alertlog | grep -A 2 “An I/O error” | wc -l` err2=`grep -B…
Read MoreThis single script provides the overall picture of the database in terms of Waits events, Active/Inactive killed sessions, Top Processes (physical i/o, logical i/o, memory and CPU processes),Top CPU usage by…
Read More#########———— Installing Rpm files —–######## #Change directory to /tmp/install cd /tmp/install #Install all packages that are not installed during OS installation and that are required packages for Oracle Database 10gR2…
Read MoreSQL> create user gangai identified by gangai; User created. SQL> grant connect, resource to gangai; Grant succeeded. SQL> conn gangai/gangai Connected. SQL> disc Disconnected from Oracle Database 10g Enterprise Edition…
Read MoreCheck the concurrent manager status from backend (database) SELECT a.USER_CONCURRENT_QUEUE_NAME ” MANAGER_NAME” ,a.MAX_PROCESSES,a.RUNNING_PROCESSES, sum(decode(b.PHASE_CODE,’R’,decode(b.STATUS_CODE,’R’,1,0),0)) Running_Normal, sum(decode(b.PHASE_CODE,’P’,decode(b.STATUS_CODE,’Q’,1,0),0)) Pending_Standby, sum(decode(b.PHASE_CODE,’P’,decode(b.STATUS_CODE,’I’,1,0),0)) Pending_Normal FROM apps.FND_CONCURRENT_Q
Read More