for z in SED
do
sqlplus /nolog<<END
connect JUSTIN/JUSTIN
set pages 100 lines 220
drop table sed_flip_1;
create table sed_flip_1 ( x int );
set serveroutput on
declare
CNT number := 0;
begin
for i in 1 .. 500001
loop
insert into sed_flip_1 values (i);
CNT := CNT + 1;
if CNT = 1000 then
commit work write immediate wait;
dbms_output.put_line('Committing now...'||CNT||' '||i);
CNT := 0;
end if;
end loop;
end;
/
-- truncate table justin.sed_flip_1;
delete from justin.sed_flip_1;
disconnect
END
done
Wednesday, 12 October 2016
Wednesday, 20 July 2016
Opatch version check
################################
#
#
# OPATCH Version check
#
#
#
#
################################
for z in SED
do
USR=`echo $USER`
if [ ${USR} = 'oracle' ]
then
ORACLE_HOME=`cat /etc/oratab | grep "oracle/product" | cut -f2 -d":"`
elif [ ${USR} = 'grid' ]
then
ORACLE_HOME=`cat /etc/oratab | grep "grid/product" | grep -v "^#" | cut -f2 -d":"`
else
echo -e "\nERROR - run as either oracle or grid user\n\n"
RSP=Abort
fi
if [ -z ${RSP} ]
then
cd $ORACLE_HOME
echo -e "\nChecking Opatch version:"
OPatch/opatch version
echo -e "\n"
fi
done
#
#
# OPATCH Version check
#
#
#
#
################################
for z in SED
do
USR=`echo $USER`
if [ ${USR} = 'oracle' ]
then
ORACLE_HOME=`cat /etc/oratab | grep "oracle/product" | cut -f2 -d":"`
elif [ ${USR} = 'grid' ]
then
ORACLE_HOME=`cat /etc/oratab | grep "grid/product" | grep -v "^#" | cut -f2 -d":"`
else
echo -e "\nERROR - run as either oracle or grid user\n\n"
RSP=Abort
fi
if [ -z ${RSP} ]
then
cd $ORACLE_HOME
echo -e "\nChecking Opatch version:"
OPatch/opatch version
echo -e "\n"
fi
done
Subscribe to:
Comments (Atom)