http://www.dba.5341.com/
http://www.dba.5341.com/
I have a script that does the following:
###########################################################
echo "EXPORT FOR $DBNAME" > $LOGFILE
echo "----------------------------------------------------" >> $LOGFILE
echo Todays date is ......................: $DATESTR >> $LOGFILE
echo The Log File for Today is ...........: $LOGFILE >> $LOGFILE
echo The Path for Oracle Home is .........: $ORACLE_HOME >> $LOGFILE
#echo The Oracle Sid is ...................: $ORACLE_SID >> $LOGFILE
echo "\n"
echo The hostname is .....................: $HNAME >> $LOGFILE
echo "\n"
echo The DBNAME is .......................: $DBNAME >> $LOGFILE
echo "----------------------------------------------------" >> $LOGFILE
echo Begin the export process at .........: `date` >> $LOGFILE
echo
The output in Unix lines up nicely:
EXPORT FOR remedy
----------------------------------------------------
Todays date is ......................: 20060320
The Log File for Today is ...........: /backup/exports/remedy_export.log_2006032
0
The Path for Oracle Home is .........: /oracle/app/oracle/product/10.2.0
The hostname is .....................: test
The DBNAME is .......................: remedy
----------------------------------------------------
Begin the export process at .........: Mon Mar 20 16:35:28 EST 2006
**** EXPORT SUCCESS ****
However, when the output is mailed it is off:
EXPORT FOR remedy
----------------------------------------------------
Todays date is ......................: 20060320
The Log File for Today is ...........: /backup/exports/remedy_export.log_20060320
The Path for Oracle Home is .........: /oracle/app/oracle/product/10.2.0 The hostname is .....................: test The DBNAME is .......................: remedy
----------------------------------------------------
Begin the export process at .........: Mon Mar 20 16:35:28 EST 2006
**** EXPORT SUCCESS ****
Any suggestions on how I can make sure “the hostname” and The DBNAME are on separate lines?
This electronic message transmission is a PRIVATE communication which contains information
which may be confidential or privileged. The information is intended to be for the use of the individual
or entity named above. If you are not the intended recipient, please be aware that any disclosure,
copying, distribution or use of the contents of this information is prohibited. Please notify the sender
of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0),
and then delete it from your system.