KTEXPERTS – Page 61 – KNOWLEDGE SHARING PLATFORM

Protected: Unix Shell Scripting For DBA’s (PART – 02)

7 years ago by Vinod SiramUnix Shell Scripting For DBA's

There is no excerpt because this is a protected post.

How to move or rename Oracle Home

7 years ago by Binnary Ajay KumarOracle DB Admin

How to move or rename Oracle Home If you want to rename Oracle Home you usually need to: 1. uninstall existing Oracle Home 2. reinstall Oracle software to the right directory that will be the new Oracle Home. You cannot just move Oracle Home because… Read More

Protected: Creation of Files in UNIX (Session-03).

7 years ago by Binnary Ajay KumarUnix Basics

There is no excerpt because this is a protected post.

Protected: Unix Shell Scripting For DBA’s (PART – 01)

7 years ago by Vinod SiramUnix Shell Scripting For DBA's

There is no excerpt because this is a protected post.

Oracle : Scheduling crontab to send EMAIL in Unix

7 years ago by Vinod SiramOracle DB Admin

Oracle : Scheduling crontab to send EMAIL in Unix $ vi test.bash

#!/bin/bash
#Script to perform testing
## Environment variables
TODAY=`date +%d-%b-%Y-%H:%M:%S`
export ORACLE_HOME='/u01/app/oracle/product/12102'
export ORACLE_SID='ORCL'
export ORACLE_BASE='/u01/app/oracle'
export PATH=$PATH:${ORACLE_HOME}/bin
export MAILIST='ktexperts@gmail.com'
export LOG='/tmp/test_mig.log'

#Function to trigger email
function mailog
{
cat ${LOG} | mailx -s "${TODAY} - TEST Mail" ${MAILIST}
}

#Function step1
function step1
{
echo " " >> $LOG
echo "Started Step 1" >> $LOG
echo " " >> $LOG
echo "Test email " >> $LOG
sqlplus -s /nolog <<START >>$LOG
Connect / as sysdba
set serveroutput on
set timing on
prompt Todays date
select sysdate from dual;
START
echo " " >> $LOG
echo "----- END OF Step1 ------" >> $LOG
}

#Script execution is here
> $LOG
if [ "$#" -eq 0 ]
then
step1
mailog
else
$1
mailog
fi

#!/bin/bash

#Script to perform testing

## Environment variables

TODAY=`date +%d-%b-%Y-%H:%M:%S`

export ORACLE_HOME='/u01/app/oracle/product/12102'

export ORACLE_SID='ORCL'

export ORACLE_BASE='/u01/app/oracle'

export PATH=$PATH:${ORACLE_HOME}/bin

export MAILIST='ktexperts@gmail.com'

export LOG='/tmp/test_mig.log'

#Function to trigger email

function mailog

{

cat ${LOG} | mailx -s "${TODAY} - TEST Mail" ${MAILIST}

}

#Function step1

function step1

{

echo " " >> $LOG

echo "Started Step 1" >> $LOG

echo " " >> $LOG

echo "Test email " >> $LOG

sqlplus -s /nolog <<START >>$LOG

Connect / as sysdba

set serveroutput on

set timing on

prompt Todays date

select sysdate from dual;

START

echo " " >> $LOG

echo "----- END OF Step1 ------" >> $LOG

}

#Script execution is here

> $LOG

if [ "$#" -eq 0 ]

then

step1

mailog

else

mailog

Crontab entry

00 02 * * * /local/home/oracle/test.bash 1>/local/home/oracle/test.cronlog 2>/local/home/oracle/test.cronerr

1	00 02 * * * /local/home/oracle/test.bash 1>/local/home/oracle/test.cronlog 2>/local/home/oracle/test.cronerr

Updated Script.

#!/bin/bash

#Script to perform testing

## Environment variables
TODAY=`date +%d-%b-%Y-%H:%M:%S`
export ORACLE_HOME='/u01/app/oracle/product/12.1.0.2'
export ORACLE_SID='prod'
export ORACLE_BASE='/u01/app/oracle'
export PATH=$PATH:${ORACLE_HOME}/bin
export MAILIST='ktexperts@gmail.com'
export LOG='/tmp/test_mig.log'

#Function to trigger email
function mailog
{
cat ${LOG} | mailx -s "${TODAY} - TEST Mail" ${MAILIST}
}

#Function step1
function step1
{
echo " " >> $LOG
echo "Started Step 1" >> $LOG
echo " " >> $LOG
echo "Test email " >> $LOG
sqlplus vinod/vinod <<START >>$LOG
prompt updating records in EMP table
select * from emp where deptno=20;
prompt update emp set sal=sal+500 WHERE deptno=20;
update emp set sal=sal+500 WHERE deptno=20;
prompt select * from emp where deptno=20;
select * from emp;
START
echo " " >> $LOG
echo "----- END OF Step1 ------" >> $LOG
}


#Script execution is here
> $LOG
if [ "$#" -eq 0 ]
then
step1
mailog
else
$1
mailog
fi

#!/bin/bash

#Script to perform testing

## Environment variables

TODAY=`date +%d-%b-%Y-%H:%M:%S`

export ORACLE_HOME='/u01/app/oracle/product/12.1.0.2'

export ORACLE_SID='prod'

export ORACLE_BASE='/u01/app/oracle'

export PATH=$PATH:${ORACLE_HOME}/bin

export MAILIST='ktexperts@gmail.com'

export LOG='/tmp/test_mig.log'

#Function to trigger email

function mailog

{

cat ${LOG} | mailx -s "${TODAY} - TEST Mail" ${MAILIST}

}

#Function step1

function step1

{

echo " " >> $LOG

echo "Started Step 1" >> $LOG

echo " " >> $LOG

echo "Test email " >> $LOG

sqlplus vinod/vinod <<START >>$LOG

prompt updating records in EMP table

select * from emp where deptno=20;

prompt update emp set sal=sal+500 WHERE deptno=20;

update emp set sal=sal+500 WHERE deptno=20;

prompt select * from emp where deptno=20;

select * from emp;

START

echo " " >> $LOG

echo "----- END OF Step1 ------" >> $LOG

}

#Script execution is here

> $LOG

if [ "$#" -eq 0 ]

then

step1

mailog

else

mailog

Crontab entry

02 * * * * /home/oracle/test.bash  1>/home/oracle/test.cronlog 2>/home/oracle/test.cronerr

1	02 * * * * /home/oracle/test.bash 1>/home/oracle/test.cronlog 2>/home/oracle/test.cronerr

Protected: BASIC ARCHITECTURE OF UNIX OPERATING SYSTEM(Session -02).

7 years ago by Binnary Ajay KumarUnix Basics

There is no excerpt because this is a protected post.

Protected: Introduction to UNIX(Session -01).

7 years ago by Binnary Ajay KumarUnix Basics

There is no excerpt because this is a protected post.

Protected: Configure Postfix to use Gmail as a Mail Relay on UBUNTU Server.

7 years ago by Binnary Ajay KumarUnix Shell Scripting For DBA's

There is no excerpt because this is a protected post.

IMPLEMENTING REPLICATION CONCEPT USING MATERIALIZED VIEWS (PART -02)

7 years ago by Binnary Ajay KumarOracle DB Admin

IMPLEMENTING REPLICATION CONCEPT USING MATERIALIZED VIEWS (PART -02) IMPLEMENTING REPLICATION CONCEPT USING MATERIALIZED VIEWS. MATERIALIZED VIEW WITH REFRESH FAST : Now that we know how materialized view logs track changes to base tables we can use them to perform fast materialized view refreshes, i.e. refreshes where… Read More

IMPLEMENTING REPLICATION CONCEPT USING MATERIALIZED VIEWS.

7 years ago by Binnary Ajay KumarOracle DB Admin

IMPLEMENTING REPLICATION CONCEPT USING MATERIALIZED VIEWS. Materialized views are schema objects that can be used to summarize, compute, replicate, and distribute data. They are suitable in various computing environments such as data warehousing, decision support, and distributed or mobile computing. In data warehouses, materialized… Read More