Author: Admin

metalink note: 15566.1 PURPOSE Shared memory and semaphores are two important resources for an Oracle instance on Unix. An instance cannot start if it is unable to allocate what it needs. This paper primarily discusses the process Oracle goes through to allocate shared memory and semaphores at instance startup. Other important points unrelated to startup…

Read More “Nice Article about semaphores and init.ora Processes parameter relations” »

The permission on this file must be 600. else even after changing the authorized keys you will be asked for password authentications.

[1] We have logserver as existing central monitoring server. [2] need to establish other monitoring server same as logserver. [3] so login as oracle copy ~/.ssh from logserver1 to dbmonitor. on dbmonitor: cd .ssh cat id_dsa.pub id_rsa.pub > both_keys then do the following for target servers. pls note that where ssh2 is installed the file…

Read More “Establishing trusted relationship between dbmonitor( central monitoring) and monitoring targets.” »

sunflower1/800P>ssh sunlight1 “grep “Media ” /EMCdb19/oracle/800L/bdump/alert_800L.log| grep -v grep | grep “arch” | tail -1 ” Media Recovery Log /EMCdb16/archlog/800P/arch0000296866.arc sunflower1/800P> sunflower1/800P>ssh sunlight1 “grep “Media ” /EMCdb19/oracle/800L/bdump/alert_800L.log| grep -v grep | grep “arch” | tail -1 | sed -e s#^.*/##” arch0000296866.arc sunflower1/800P>

Following will replace anything except numeric digits. sunflower1/800P>echo /db15/archlogbak/800P/arch0000295711.arc | awk -F”/” ‘{print $NF}’ | sed -e ‘s|[^0-9]||g’ 0000295711

#/bin/ksh -x for myread in `cat /export/home/oracle/scripts/check_recovery.par` do TARGET_SID=`echo $myread | awk -F”,” ‘{print $1}’` SOURCE_SSH=`echo $myread | awk -F”,” ‘{print $2}’` SOURCE_HOST=`echo $myread | awk -F”,” ‘{print $3}’` SOURCE_ENVFILE=`echo $myread | awk -F”,” ‘{print $4}’` SOURCE_ORACLE_HOME=`echo $myread | awk -F”,” ‘{print $5}’` TARGET_SSH=`echo $myread | awk -F”,” ‘{print $6}’` TARGET_HOST=`echo $myread | awk -F”,”…

Read More “Reading parameter file and printing” »

LASTFILE=`${PRDCMODE} ${PRDHOST} “ls -latr ${PRDARCH}/*.arc” |nawk ‘{print $9}’|tail -1|sed ‘s/[A-Za-z/. ]//g’|sed ‘s/^0*/ /g’` if [ $? != 0 ];then print “${STB1SID}: ${ALIAS} Standby on ${STB1HOST} – CRITICAL ERROR” >> ${NOTOKLOG} 2>/dev/null exit 50 fi