Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

Shell Script Error

edited May 1, 2017 8:35AM in Database Install/Upgrade/Opatch (MOSC) 4 commentsAnswered

Dear Members,

Past few days i am getting an error while running a shell script which i placed in crontab

---Crontab--------

0 9-18 * * * sh /u02/monitor/dailymon.sh

------sell script content----------

date=`date +%d%m%y%H%M%S`

script_home=/u02/monitor

repdir=/u02/monitor/reports

export ORACLE_HOME=/oracle/app/oracle/product/11.2.0/dbhome_1

export ORACLE_SID=*****

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

sqlplus system/password  @$script_home/tblsize.sql

cp -p tblsize.lst $repdir/tblsize_$date.lst

sqlplus system/password @$script_home/indxsize.sql

cp -p indxsize.lst $repdir/indxsize_$date.lst

sqlplus system/password @$script_home/hit1

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center