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
Author: Admin
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” »
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” »
Implementing Listener Security
Implementing Listener Security
# Listener Security #
Implementing Listener Security
Step:1 ====== Do following steps to implement encrypted listener password. $ lsnrctl LSNRCTL> set current_listener LISTENER LSNRCTL>set save_config_on_stop on LSNRCTL> change_password Old password: New password: e1 Reenter new password: e1 LSNRCTL> set password Password: e1 LSNRCTL> stop Step:2 ====== Check your listener.ora file Entries similar to the following should have been added to your listener.ora…
Free conference number from http://www.freeconference.com
dedicated dial-in number 1 (218) 339-2699 access code 328166
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…
Database logon trigger issue
Problem Description ——————- You create a database event trigger that fires each time a user connects to the database. For any reason, the login trigger becomes invalid. (The trigger is retrieving information from a table that may be inadvertently dropped.) Who can connect? Solution Description ——————– Connect under a user who owns the following system…
kill all processes from specific user in solaris.
kill all processes from user name atsscript on solaris. pkill -9 -u atsscript