If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Hi DBA's
I wrote a bckup script using rman.
I set ORACLE_HOME, ORACLE_SID, LD_LIBRARY_PATH variables and then wrote my backup code.
when I execute that script from unix prompt it works fine.
When I submit that in cron job I got an error.

cron executes using a minimal shell. It's always best to explicitly execute your user (in this case, oracle) login file (.login for c-shell, .profile for bourne or korn) early in the script to be sure all of your environment is correct.

as MACSWELL said, you r use SUB schell in cronjob which means there are only 5-6 environment var set (try to display your env var in the cronjob you will be very surprise the result). you have to reset your variable by running .profile (KSH) or create a script then execute it.