Script not working in Cron

[Beverly Wixon]

Thank you so much, John. I learned a few things anyway. Now, we'll see if it works. My fingers are definitely crossed. This is the way it now reads. Please let me know if you see anything else I need to fix.

ORACLE_SID='dbname'
ORACLE_BASE='/ora0/oracle/app/oracle/product'
ORACLE_HOME='/ora0/oracle/app/oracle/product/8.0.5'
PATH=${PATH}:${ORACLE_HOME}/bin
export ORACLE_HOME ORACLE_SID ORACLE_BASE
export PATH=${PATH}:(ORACLE_HOME}/bin
export SHLIB_PATH=$ORACLE_HOME/lib
PSWD=`cat /ora0/oracle/passwd/system`
sqlplus system/$PSWD@dbname @$HOME/SQL/anal_schemas.sql

[Herve BRANGIER]

Beverly

Sorry to be so inprecise ;-)

I see that John give you all informations you
need to make your tests....

Good luck

Herv?

[Beverly Wixon]

Well, John, I tested it. Still did not run sucessfully.

Thanks for helping, Herve. Trust me, I need all the help I can get right now. I am definitely out of my league in this arena.