Changing default shell
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 ~]#
Oracle 11g Environment Setup
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…
New OFA for 11g
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
Alter procedure auditing
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
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…
How to remove blank lines using vi editor command
use the following: :g/^$/d
remove archfiles only when it is applied to DR rm_archfiles.sh
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” »
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
remove archfiles only when it is applied to DR rm_archfiles.sh
/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
run this before doing any dbchange pvm_pre_change.sql
column currdate new_value pvmdt noprint select ‘pvm_comp_’ || to_char(SYSDATE, ‘DDMONRRRR_HH24MI’) || ‘.sql’ currdate from v$instance; spool &pvmdt set lines 120 pages 2000 set head off set feedback off prompt set pages 5000 lines 120 prompt select ‘prompt ‘||a.owner||’.’||a.object_name||’ – ‘||a.object_type|| chr(10)|| prompt ‘alter ‘|| prompt decode(a.object_type,’PACKAGE BODY’,’PACKAGE’,object_type) || ‘ “‘|| prompt a.owner||’”.’||a.object_name||’ compile ‘|| prompt…
Read More “run this before doing any dbchange pvm_pre_change.sql” »