If you set “stty erase ^H” on unix prompt and it works fine on unix prompt. But not working on SQLPLUS then you need to put “stty erase ^H” in .kshrc file as following. -> pwd /home/oracle oem.localdomain:OEMDB:/home/oracle -> more .kshrc stty erase ^H oem.localdomain:OEMDB:/home/oracle ->
Following statement will be used to change default shell to /bin/ksh for oracle user. [root@oem ~]# chsh -s /bin/ksh oracle Changing shell for oracle. Shell changed. [root@oem ~]#
11g Environment Setting: ======================= —————————————————————– ==>cat .profile . /oracle/app/oracle/set_env_var_dba PS1=” `hostname`*${ORACLE_SID}-${PWD} ==>” EDITOR=vi; export EDITOR set -o vi stty erase PATH=$PATH:. dba() { cd /oracle/app/oracle/scripts/MAINT/DBA/bin } ———————————————————————————— ==>cat /oracle/app/oracle/set_env_var_dba # This File Sets all the Oracle Environment Variables and is called from # Each Users’s . profile file. # # Please Don’t change these settings…
export INSTANCE_NAME=`echo $ORACLE_SID | tr ‘[:upper:]’ ‘[:lower:]’` export ORA_BDUMP=$ORACLE_HOME/admin/”$ORACLE_SID”_`hostname`/diag/rdbms/$INSTANCE_NAME/$ORACLE_SID/trace
A common misconception is that the ‘audit any procedure’ is a privileges auditing option associated with the privilege ‘alter any procedure’ and thus does NOT cover the alteration of a procedure that is owned by the user altering it. Note that AUDIT PROCEDURE covers: CREATE FUNCTION CREATE LIBRARY CREATE PACKAGE CREATE PACKAGE BODY CREATE PROCEDURE…
EXTPROC Scope and Application A list of the essential components for executing an external procedure is included below, along with a brief description of the role of each. Database: Responsible for storing any information required to locate and execute an external procedure (e.g. the location of shared library, number and types of arguments, etc.) Initiates…
use the following: :g/^$/d
echo “script execution starts at `date`” echo “COMFORT_SPACE=$COMFORT_SPACE” echo “ARCH_DEST=$ARCH_DEST” echo “ALERT_LOG=$ALERT_LOG” ARCH_SPACE=`df -k $ARCH_DEST | tail -1 | awk ‘{print $5}’ | sed ‘s/%//g’` echo “ARCH_SPACE=$ARCH_SPACE” STDBY_LAST_RECOVERED_FILE=`grep “Media ” $ALERT_LOG |grep -v grep|grep “arch” | tail -1 | sed -e ‘s#^.*/##g’ ` echo “STDBY_LAST_RECOVERED_FILE=$STDBY_LAST_RECOVERED_FILE” STDBY_LAST_RECOVERED_NUMBER=`grep “Media ” $ALERT_LOG |grep -v grep|grep “arch” | tail…
Read More “remove archfiles only when it is applied to DR rm_archfiles.sh” »
ARCH_DEST=$1 COMFORT_SPACE=$2 ALERT_LOG=$3 NOTIFY_LIST=dbaoracle@1800flowers.com
/oracle/scripts/rm_archfiles.sh “/db9/archlog” “90” “/oracle/admin/TESTDB/bdump/alert_TESTDB.log” #!/bin/sh RUNNING=`ps -ef|grep rm_archfiles.sh|grep -v grep|wc -l` if [ $RUNNING -gt 2 ] then echo “Exiting !!! Total $RUNNING occurence of rm_archfiles.sh are running at `date`” exit fi
