How does crontab handle Oracle operation problems?

[Root @ localhost home] # vi test. sh
#! /Bin/sh
Oracle_HOME =/oracle/ora10/product
Export ORACLE_HOME
Userpwd = test/test@10.11.0.235: 1521/ora10g
$ ORACLE_HOME/bin/sqlplus-S $ userpwd <EOF
Alter session set nls_date_format = 'yyyy-mm-dd hh24: mi: ss ';
Insert into test values (1, 'test ');
COMMIT;
EOF
Exit;
 
The ORACLE_HOME environment variable must be set in the above test. sh file; otherwise, it cannot be executed normally when added to crontab (for example, comment out the environment variable: # ORACLE_HOME =/oracle/ora10/product
# Export ORACLE_HOME
), Even if the absolute path/oracle/ora10/product/bin is added before sqlplus, the crontab file is as follows: test1_crond. For the logs, see/var/log/cron.

[Root @ localhost cron. d] # vi test1_crond
* *** Root sh/home/test. sh>/home/test. log
~
~
SQL> conn test/test
Connected.
SQL> select * from test;
ID NAME
------------------------------
1 test
1 test
1 test
SQL>

[Root @ localhost cron. d] # tail-f/var/log/cron
Aug 17 14:03:01 localhost crond[ 10718]: (root) CMD (sh/home/x. sh)
Aug 17 14:03:01 localhost crond [10720]: (root) CMD (sh/home/test. sh>/home/test. log)
Aug 17 14:04:01 localhost crond[ 11102]: (root) CMD (sh/home/x. sh)
Aug 17 14:04:01 localhost crond [11103]: (root) CMD (sh/home/test. sh>/home/test. log)
Aug 17 14:05:01 localhost crond[ 11449]: (root) CMD (sh/home/x. sh)
Aug 17 14:05:01 localhost crond [11452]: (root) CMD (sh/home/test. sh>/home/test. log)